CR9 Showing Message when No Data using formula

[oublie]

Hi,

For years i've been using CR6, now we have upgraded to CR9 and I've got a problem. On the report there is a suppressed message in the Page Header "There is not Data to Report Please change your Selection Criteria". This is suppressed with a formula to show the message when there is no data. This seems to have stopped working. does anyone know of a clever way of doing this other than {AUDIT.CLIENT_ID} > 0 where if the client_id has no value then the message will be shown? Any solutions or ideas would be greatly appreciated.

 

[Naith]

You can use the Alert functionality for this kind of thing.

Look for Create Alert in the Report menu.

Alternatively, if you want to continue your conditional suppression, try suppressing on:

Not (IsNull(Sum({Audit.Client_ID})) or
Sum({Audit.Client_ID}) = 0)

Naith

 

[oublie]

Thanks Naith,

I Tried alerts with no joy, but i'll have a go with your formula.