Click to See Complete Forum and Search --> : Suppressing a Blank Page


breathshadow
November 7th, 2007, 08:29 AM
Hi,
I'm using Crystal Reports 8.5.

I had to suppress 2 sections on the Report using some formula and it works fine. But unfortunately it leaves out a blank page where those sections used to be!

how to get rid of the blank page ?

please help!

thanks
Deepak

HanneSThEGreaT
November 7th, 2007, 11:04 AM
Hi,
I'm using Crystal Reports 8.5.

I had to suppress 2 sections on the Report using some formula and it works fine. But unfortunately it leaves out a blank page where those sections used to be!


That's a contradiction, don't you think ¿
What formula did you use ¿

breathshadow
November 7th, 2007, 12:31 PM
Hi Hennes

Yes, Probably.. as i am not very good at Crystal Reports.

Basically this is what i have to do.

in the Details Records if i find Certain Text in a Field,
I have to show a section or else..
Hide it.

here's the formula I use

WhilePrintingRecords
global showDisbCreditSection as number
select case UpperCase({INVOICE_LOG.LINE_ITEM_TYPE})
case "HCDC", "LIDC", "SLDC", "RHCDC"
showDisbCreditSection = 1 'set it to 1 as we found a record which contains one of these 4 Items
case else
if (showDisbCreditSection <> 1 ) then
showDisbCreditSection = 0
end if
end select
formula = showDisbCreditSection

this works ok if the User will Request 1 Report a Time.
If they request the Report say in a "Between" Query
ie, FieldX between 1 to 10
the Formula Falls over.

please show me some techniq to reset the showDisbCreditSection variable each time a new Report is Started in a continuous Report generated with a Between Query from Select Expert of CR 8.5

thanks
Deepak