Oracle Report - how do I don't print a blank page if no data.
From: Rathan Babu, Rameswarapu <rxbisd_at_ritvax.isc.rit.edu>
Date: Tue, 11 Jan 2000 10:20:31 -0500
Message-ID: <387B4A3E.3035D858_at_ritvax.isc.rit.edu>
In my Oracle Reports, I got many queries, also, I use many formulas,summary columns in each query. In the driving query I got two formula columns, [CV]'calculate value' and ' [DV]database value', now these uses some other formula/database values from other queries.
Now. if the difference of CV and DV is > 0 then only I want to print the information, I am able to do that by using format trigger on repeating frame in layout, but still it prints blank page. If I use range to run the report for example, from x employee to y employee, having above condition, it prints whole information where there is difference but, it also prints balnk pages in between where there is no difference.
[Quoted] To put in simple way, how do we surpress printing blank pages, if there I have to put some condition?
Note that I have tried to use group filter to by using condition, having pl/sql using formula colums CV and DV, but it say error <circular dependency in query Q1>.
Any help is appreciated.
Date: Tue, 11 Jan 2000 10:20:31 -0500
Message-ID: <387B4A3E.3035D858_at_ritvax.isc.rit.edu>
In my Oracle Reports, I got many queries, also, I use many formulas,summary columns in each query. In the driving query I got two formula columns, [CV]'calculate value' and ' [DV]database value', now these uses some other formula/database values from other queries.
Now. if the difference of CV and DV is > 0 then only I want to print the information, I am able to do that by using format trigger on repeating frame in layout, but still it prints blank page. If I use range to run the report for example, from x employee to y employee, having above condition, it prints whole information where there is difference but, it also prints balnk pages in between where there is no difference.
[Quoted] To put in simple way, how do we surpress printing blank pages, if there I have to put some condition?
Note that I have tried to use group filter to by using condition, having pl/sql using formula colums CV and DV, but it say error <circular dependency in query Q1>.
Any help is appreciated.
Thanks
Rathan.
Received on Tue Jan 11 2000 - 16:20:31 CET