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: 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 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

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 Go to previous message
Littlefoot
Messages: 21823
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/

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:34:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.