hi all,
in one of our report , we are using sectoin on one column,
if there is no data in the corresponding query,then it is not displaying other column heading display fields even((it is showing blank page).....i need to dispaly column headings
Thanks,
Raghu
If you have Cognos 8.3, there is a new "No Data" feature built-in for use within Lists, Crosstabs and Charts to display the object even if there is no data. You can add a Table to the "No Data" portion of the object and format it to look like your List, as it would if there were rows. I have done a few of these and it works like a charm.
If you are not on 8.3, you can use a Conditional Block work-around to display something other than your list if there are no rows. This is an old workaround that I am sure a quick search will help you find more details.
Also, if not on 8.3, I suggest upgrading. I am impressed with this version. Not perfect, but nice upgrade from 8.2 or lower, IMO.
Hi,
As above said we have a very nice built in features no data in cognos 8.3. Or if you are working on a old version use the conditional block and use boolean variable in this use the condition like this
count(quantity)>0
Thanks,