No data message

[dmurray00]

Greetings to all --

I'm trying to send a message to a report whenever a particuliar query returns no data .. I'm trying to have a cell output -- "There's No Data !!!". An alert will work if there is data but I haven't cracked it if there is no data after a refresh. The alert will take a "counter = 0" and the counter shows 0 but the alert does not functions as expected -- it just shows the 0 and not the message.

Any thoughts or ideas are appreciated.

D. Murray

 

[blom0344]

Classic solution:

Avoid having the message 'no data to fetch' by adding a dummy record through a union-query.
In that case there will be no message, cause there will be always 1 record fetched.

So, if NumberOfRows("data provider") =1 display the 'no data to fetch' message.



T. Blom
Information analyst
tbl@shimano-eu.com