Re: Oracle Report - how do I don't print a blank page if no data.

Report parameter BLANKPAGES=NO....check out the Help.

Regards
Graeme King

Rathan Babu, Rameswarapu <rxbisd_at_ritvax.isc.rit.edu> wrote in message news: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.
> 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 Mon Jan 17 2000 - 00:08:44 CET