how to set a default value to "Aggregation" report item

hi,
i want to set a default value to aggregation report Item in case do filter and there are no data that answer to this filter,e.g. do aggregate to 'A' column where 'B' column is 4, I want that in case there is no 'B' = 4 the aggregation display 0, (for now it display blank) does it possible?

thanks
mby.

Find more posts tagged with

Comments

mwilliams

Hi mby,

Can you explain this a little more? I'm not sure I'm quite getting the scenario you have set up. If possible, could you make an example that I could run using a flat file or the sample database? Thanks.

mby

Hi,
sorry, but i can't do a sample that you can see, i try to explain again:
I mean that in case I use the aggregation item and I put a filter in the filter condition field, so in case there is no rows that answer this filter, the BIRT display a blank cell and I want it displays 0 value. does it possible?

thanks
minka.

mwilliams

mby,

In the onCreate script of the aggregation, you should be able to do a check of the value for null and place a value of 0 in there if it's blank.