Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"This page intentially left blank if page is even"

Status
Not open for further replies.

CrystalLion

Programmer
Jan 3, 2007
113
US
I have a report with several sections. Evertime I run the report, when there Grants but no Gifts, it creates a proper page 1, a proper page 2, and then creates a page 3 with no information on it which contains my "this page intentionally left blank" conditional statement.

I want to display a message that says "this page intentially left blank" if the page# is even. My report has the following sections

PHa - first header page
Phb - suppressed
Phc - header page for pages 2-??)
Phd - "this page intentionally left blank"
shared booleanVar LastPage;
not (LastPage and remainder (pagenumber, 2)=0)
Gh1 - suppressed
contains @resetvars"
shared booleanVar LastPage := False
Details - suppressed
Gf1a - Period Activity
Gf1b - Period balance (hard Page break)
Gf1c - gifts (conditional suppress if no gifts)
Gf1d - grants (conditional suppress if no grants) and
(conditional new page before
shared booleanVar NoGrants; not (NoGrants)
Gf1e - "no gifts and no grants" (conditional suppress if
there are either gifts or grants"
Gf1f - Gifts or Grants out of balance with GL error page
(conditional suppress if nothing out of balance)
Gf1g - @SetLastPage" @shared BooleanVar LastPage := True
Report Footer - suppressed
Page Footer - never suppressed

Any insight would be helpful. I am under a deadline that has passed and am at a dead end.

Thanks
L
 
Can't tell how you are creating the extra page. Also unclear on whether you are saying you ONLY want an extra page if even, otherwise, not.

-LB
 
LBass - I can't tell how I am creating the extra page myself, That is my dilemma.

If the last page containing data is "even", I don't want an extra page that says "this page intentionally left blank.

If the last page containing data is oddreport is "odd" pages long, I want Crystal to generate an additional "even" page which says "this page intentionally left blank"
 
So the blank page belongs after the GF1_g?

-LB
 
Yes - but only if GF1g is odd. If GF1g is even, I don't want anything after it.
 
Insert a GF1_h and format it to new page before and to new page after, and in the suppress->x+2 area add this formua:

remainder(pagenumber,2) <> 0

Also set "reset page number after" on the gF1h.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top