crosstab no results

[jmoore]

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.

[COGNOiSe administrator]

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.