OraFAQ Forum: Reports & Discoverer » How to display "no data found" when query returns no records?

Home » Developer & Programmer » Reports & Discoverer » How to display "no data found" when query returns no records?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to display "no data found" when query returns no records? [message #291369]

Fri, 04 January 2008 00:37

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

Hi,
How do I display 'No data found' if query doesn't retrieve any data.
Thanks,
Surya

[Topic SPLIT by LF: please, do not hijack a topic which has nothing to do with your problem. Open a new one instead.]

[Updated on: Fri, 04 January 2008 01:01] by Moderator

Report message to a moderator

Re: How to display "no data found" when query returns no records? [message #291390 is a reply to message #291369]

Fri, 04 January 2008 01:21

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Create a Place Holder and track the count of the rows.
When it is zero, in the format trigger of the text box return true.

By
Vamsi

[Updated on: Fri, 04 January 2008 01:25]

Report message to a moderator

Re: How to display "no data found" when query returns no records? [message #291399 is a reply to message #291369]

Fri, 04 January 2008 01:44

lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD

Senior Member

hi,
Thanks for the quick response.
How do I display the End of report and No data found status in a Discoverer report?

thanks,
Surya

Report message to a moderator

Re: How to display "no data found" when query returns no records? [message #291400 is a reply to message #291390]

Fri, 04 January 2008 01:45

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It would be maybe easier to create a SUMMARY column instead, as you wouldn't have to write your own query to count number of records (CS_1 in the example) which will return the FIRST value of one of fields fetched by a query.
Create a text object ("No data found") in Paper Layout Editor (it is the B_1 field on the image) and create a format trigger which will display (or not) this text, depending on summary column's value.

/forum/fa/3690/0/

Attachment: no_data_found.PNG
(Size: 9.74KB, Downloaded 1291 times)

Report message to a moderator

Previous Topic:	Display Column fields in Heading section
Next Topic:	Problem with Save Workbook

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 11 03:54:48 CDT 2024