Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUERY RETURNS ZERO RECORDS

Status
Not open for further replies.

Iloveoracle

Programmer
Oct 2, 2006
22
US
Hi,
I am trying to supress the report header and blank pages when the report query returns no records.
Some body asked about this question before,but still i am unable to apply that solution to my problem. I created summary column with row count.Query looks like this:


select id,name,rownum from temp_table
where id=:id and rownum>0
then i created summary column with function COUNT and source ROWNUM.Then I wrote condition on the header,but it says the header feild references the summary column feild at the wrong frequency.

Thanks for your help in advance.

Thanks
gp
 
Hi,

I got solution.I created formula column instead of summary column,then i wrote condition on title.Its working fine.

Thaks
gp
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top