Guys......I have some thing like score card.its has several boxes contains the count for diff queries.Finally i am calculating (adding) sum of all the counts of different boxes.But when one query results comes "Zero" its not displaying any thing its showing the blank.When the total of all the counts will also becoming zero.
when i used the missing value zero its displays zero in the individual box but not in the total count.its making all the values becoming zero.
I have tried all the combination's in the data item expressions like is null ,is missing and blank check never worked out.
I am not sure why if no records in the query....count() have to return zero or null or blank or some thing.but i cant find which value its returning.
Please any one help me to resolve this issue
Thanks in Advance
Raja[/b]