Iloveoracle
Programmer
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
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