Display text string when cross-tab returns no results 1

[cubeblock]

Hi,

I have a cross tab that operates on a date range. When there is no data for the range nothing is displayed on the page. When this occurs I would like to display a text string on the page. I have looked at conditional suppression of a section but I cannot find a solution.

Thanks

CR9

 

[AndrewBaines]

Version?

Andrew Baines

http://www.pursuittechnology.co.uk

 

[cubeblock]

Hi Andrew,

Its CR9

Thanks

 

[AndrewBaines]

oooh, old then!

Have a subreport that runs the same or similar query, but with some sort of count. Place that in a section before the cross tab. Use a shared variable to pass back whether or not there's any data. Suppress sections based upon that.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[lbass]

Assuming you have a selection formula like:

{table.date} = {?daterange}

...you should be able to create a formula like this to place in the section:

if isnull({table.ID}) then
"No data"

The field used should be a non-null (recurring) field.

You also should make sure that in file->report options you have NOT checked "suppress report if no records".

-LB

 

[cubeblock]

Thank you for the help on this. Your solution works great