Home » Developer & Programmer » Reports & Discoverer » How to display "no data found" when query returns no records?
How to display "no data found" when query returns no records? [message #291369] Fri, 04 January 2008 00:37 Go to next message
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 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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 Go to previous messageGo to next message
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
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 Go to previous message
Littlefoot
Messages: 20891
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.

./fa/3690/0/
Previous Topic: Display Column fields in Heading section
Next Topic: Problem with Save Workbook
Goto Forum:
  


Current Time: Sun Dec 04 08:19:57 CST 2016

Total time taken to generate the page: 0.06348 seconds