If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display section headers when no data

Started by n_ramesh_in, 22 May 2007 06:42:05 AM

Previous topic - Next topic

n_ramesh_in

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

COGNOiSe administrator

If the fuctionality existed in previous version, then it is a good candidate for a bug. Open a case with Cognos Support.

goose

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)