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.
COGNOS GURU's - Any updates plz?