QUERY RETURNS ZERO RECORDS

[Iloveoracle]

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

 

[Iloveoracle]

Hi,

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

Thaks
gp