Click to See Complete Forum and Search --> : Suppressing a Blank Page
breathshadow
November 7th, 2007, 07: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, 10: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, 11:31 AM
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
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.