displaying n/a or zero in rows

[phani1979]

Hello :)
I had list report with 3 columns,
country, order year, revenue
and on country column i had created a section
and then  i turned to it pivotlist to crosstab..
when i run the report. .In Revenue (measure) some fields shows blank.(might be there is no data).
So what can i do  TO show"N/A or "0"  in the blank fields
can any one help how to sort this issue, can u explani me step by step, i can resolve this issue.
I know i can do it by conditonal formattting..
Please guys
sudhakar

[phani1979]

Thanks
I figured it out myself
just gone to the dataformat of the reveune column just set the missing filed as  'N/A'

sudhakar

[otsizh]

hi,
I have a similar problem here : I have a list with some data A, B, C if C is 0 or nothing I have nothing displayed under A and B columns. I tried the missing data formating  but still no luck.
Can u help me please?

[JoeBass]

If your report happens to be based on joining two child models and one of the children returns a null result set, the parent will receive no result set.

[bdybldr]

Joe, that explains an issue I'm having.  Have you found a solution to this?  Thanks.

[JoeBass]

No, no way that I know of, other than putting more logic on the database to substitute spaces or zeros for null rows.  Its enhancement request 458945.

[bdybldr]

OK, thanks for the update.  I'll post a work-around if I find one.