Hi,
I have an issue with the List report in cognos 10.1. In my report i have list and in that i placed one table
with text and corresponding query items. The problem here is there is no data in the database for the particular dataitems. But i want to display the null values with the 0.00%. i tried with data format property and by writing case statements.
Case statement: case
when [query item1] IS NULL
THEN (0.00%)
ELSE
[query item1]
END
But still in the ouput the list is not appearing. It is only showing the text specified in the no data contents property of that query item.
Please suggest is there any way of achieving this.
Thanks!!
Does Data Format work? The option for Blank value to display specified text
If the query returns no data then there is no result set to display or to base subsequent query calcuations against. Your case statement won't ever be evaluated if there isn't any data returned by the query. There won't be a row with a null value...there just simply won't be a row.
You could just modify your no data contents to include a table that looks just like your list would have looked had there been any data to display. Then put the text and 0.00% in there.
Thanks Lynn!
I tried in the same way as you said it worked for me.
Really thanks for your suggestion.
Great! Glad you got it working :)