Reports [message #89164] |
Tue, 28 October 2003 04:44 |
Sano
Messages: 2 Registered: October 2003
|
Junior Member |
|
|
Hi,
When query in my report does not fetch any records I want to display a message saying 'No matching records found' instead of just displaying column headings, lines drawn.
How should I solve this problem?
Thanks
Sano
|
|
|
Re: Reports [message #89166 is a reply to message #89164] |
Tue, 28 October 2003 06:35 |
khalid
Messages: 24 Registered: September 1999
|
Junior Member |
|
|
Hi Sano,
An easy way to do this is:
1- create a parameter called DATA_NULL
2 - transfer to it from the calling form (if you call the report from a form) 0 if no data found
3 - create a formula that would return a string 'No data found ' if the parameter equals 0
|
|
|