COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: jmoore on 19 Sep 2007 03:12:00 PM

Title: crosstab no results
Post by: jmoore on 19 Sep 2007 03:12:00 PM
Does anyone know how to display a message of no results when the output of a report containing a crosstab has no records? I've tried using a render variable with no success. Also tried the previous example when a report has a list but this doesn't work in the crosstab case.
Title: Re: crosstab no results
Post by: COGNOiSe administrator on 20 Sep 2007 09:30:00 AM
Create another query, using your existing crosstab as shortcut source, and get number of rows as your only column. Then create a variable that will conditionaly control the display of the crosstab or a text message.