Home » Developer & Programmer » Reports & Discoverer » Reports
Reports [message #89164] Tue, 28 October 2003 04:44 Go to next message
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 Go to previous message
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
Previous Topic: oracle reports scheduling
Next Topic: wrong totals with Discoverer and unbalanced hierarchies
Goto Forum:
  


Current Time: Sun Nov 24 09:59:46 CST 2024