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
Thanks
I figured it out myself
just gone to the dataformat of the reveune column just set the missing filed as 'N/A'
sudhakar
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?
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.
Joe, that explains an issue I'm having. Have you found a solution to this? Thanks.
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.
OK, thanks for the update. I'll post a work-around if I find one.