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

CROSS TAB - NO DATA DISPLAY issue if calculated column involved

Started by sengot, 14 Apr 2011 11:24:01 AM

Previous topic - Next topic

sengot

Using 8.4.1. - Report Studio - In CROSSTAB report ,Need to show prompt 1) to view all records by having ALL option [know its easy :)] 2) for example if we have 4 products - we need to have 4+ALL option in the prompt - and need to display NO DATA EXISTS if no data available for particula product - I am facing problem here - I have changed NO DATA CONTENT to YES in cross tab property and given text box having "NO DATA AVAILABLE" but not working - Note I have a calculated column called DIFFRENCE which calculates last 2 months difference.

Tried changing SUPPRESSION property to rows and columns + othe options- then no data content worked but it didn't display the CALCULATED COLUMN called DIFFERENCE in the report output.

One more logic needed.
if ALL option is selected - say if 3 product out of 4 has data - obviously Report studio will be display 3 products record- The catch point is here - apart frm that need to display "no data for XXX product " for the 4th product which ia having no data- below the cross tab or where ever.