Home » Developer & Programmer » Reports & Discoverer » HELP!_NO_Data_Returned
HELP!_NO_Data_Returned [message #89035] Wed, 06 August 2003 08:10 Go to next message
Ben Parker
Messages: 9
Registered: December 2002
Junior Member
I have a report that consists of several independent queries.

In running it I am getting a 'No data returned' message that is displayed when I print the report even though the report returns data; curiously the message does not display on screen.

It appears that perhaps one of the queries is returning no data but the others are.

Does anyone know of a way to suppress this message?
Re: HELP!_NO_Data_Returned [message #89142 is a reply to message #89035] Thu, 16 October 2003 05:27 Go to previous message
Bhavin Mehta
Messages: 18
Registered: October 2003
Junior Member
If your report is using formula columns, handle Oracle Error - 1403 'no_data_found' in your PL/SQL exception handling section. If you are having only SQLs and no PL/SQLs, this error should not come.
Previous Topic: sum of formula column
Next Topic: NO_DATA_RETURNED
Goto Forum:
  


Current Time: Sun Nov 24 09:32:47 CST 2024