Excluding null values in graphs with outer joins

Hello,

I'm creating a cross tab and bar chart. The query uses a left outer join and the charts are including a zero value and blank item on the x axis where the y axis value is missing, an empty item on the y axis is inserted in the cross tab report.

I would like to keep the null values in the query as this allows me to display a column for each month of the year regardless of if it has a value or not. I do not want to display the blank items that do not map to a value in my x axis though.

The zeros are being inserted because there is always a set of dates but not necessarily an entry for the other set being joined (offices).

This must be a common issue, I'm new to BIRT and haven't been able to find anything.

Any tips much appreciated!

Thanks,
Mike

Find more posts tagged with

Comments

dzish

Hi,

if it's fast query and I know the query is not often changed I would create another one.
If I wanted one query with different results I would saw in javascript events for chart maybe beforeRendering event.

Jan

alex520

just create a filter with condition "is not null" in dataset editor filter tab.