COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: otsizh on 22 Sep 2005 03:19:23 PM

Title: Condition Explorer between Crosstab and textItem
Post by: otsizh on 22 Sep 2005 03:19:23 PM
I have a Crosstab and TextItem. crosstab has some numbers. When the [number] IS NULL(when all numbers in crosstab are null) then only the textItem should appear;

when the crosstab hasÃ,  not null numbers, then Only the crosstab should appear.

How to set the conditional variable that it would be tied to Crostab and textItem at the same time?

the demo would be nice...
thank you, Olha
Title: Re: Condition Explorer between Crosstab and textItem
Post by: sir_jeroen on 23 Sep 2005 06:06:03 AM
Could you formulate it in the sample package "Go Sales and Retailers"? I'll try to create a tutorial for you then...
Title: Re: Condition Explorer between Crosstab and textItem
Post by: otsizh on 23 Sep 2005 07:30:40 AM
You can use the same crosstab you used in my question "crosstab" on Sep 19, but crosstab should be grouped by product name and divieded on separate pages where there is a page for every product Name.
For the product Name =asiseed syrop you will have an empty crosstab - in this case the textItem should appear with message ('No data is available')

thanks, Olha