Hi All
I have a crosstab report which is sectioned on a dimension called Entity(Entity is the section header here and the detailed cross tab displays data corresponding to the header).The user selects the entities from a drop down and the data corresponding to all selected entities are displayed and if there is no data against a particular enity that enity is Not displayed in the section as of now.The user now wants the enity name to be displayed in the section header even if there is no data against an entity.I amon Cognos 8.is there any way to achieve this? It was quite easy in the earlier version of cognos as creating sections would create 2 seperate queries there .
Regards,
Ramesh
If the fuctionality existed in previous version, then it is a good candidate for a bug. Open a case with Cognos Support.
You can replicate the old functionality by creating two seperate queries, one that will bring back the data for entity and another that will bring back the rest of the data used by the crosstab. Then you must define a master detail relationship between them, that way even if there is no data for the child query (query two used for crosstab) there will still be page for the master query (query one)