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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make it to display the <footers> after the page break ?

Status
Not open for further replies.

CrystalReports9

Programmer
Jan 10, 2003
124
US
I am forcing the page break in the <DETAIL> section (only 4 lines).

---------------------
The problm is like
---------------------
The sections like <GF><RF><PF> will not get diplayed in BOTH Pages (before page break page, after page break page) ?

------------
Question
------------
1) How 2 make it to display the <GF><RF><PF> in both pages ?
2) How 2 populate the totals ?

-------------------
Sample format
----------------
<RH> Tax Statement
<PH> Municipality
<GH> Roll Number: 202400
Detail Record 10
Detail Record 20
Detail Record 30
Detail Record 40
Detail Record 50
Detail Record 60
<GF> Total :
<PF> Page
<RF>

-----------------
Output to be
-----------------
Page 1
----------
<RH> Tax Statement
<PH> Municipality
<GH> Roll Number: 202400
Detail Record 10
Detail Record 20
Detail Record 30
Detail Record 40
<GF> Total : 100
<PF>
<RF>

----------
Page 2
----------
<RH> Tax Statement
<PH> Municipality
<GH> Roll Number: 202400
Detail Record 50
Detail Record 60
<GF> Total : 120
<PF>
<RF>
 
Question 1) How 2 make it to display the <GF><RF><PF> in both pages ?
Move the group footer and report footer contents into the page footer. The page footer will print on every page so that will solve the problem for any static text in the group footer or page footer.

Question 2) How 2 populate the totals ?
The easiest way to populate the totals would be to create running totals and place them in the page footer. You will get accurate counts for each page.

The only issue here is that on page 2 of yor example, the total would be at the bottom of the page. I was able to get around that by greating a summary total for the group footer and only displaying the runnning total when the group was not printed on the same page.
To accomplish this, create the follwoing 2 formulas:

@Set Flag to True
[code}
whileprintingrecords;
booleanvar bFlag := True;[/code]

@Set Flag to False
[code}
whileprintingrecords;
booleanvar bFlag := False;[/code]

Place the "@Set Flag to False" in the group header and suppress.
Place the "@Set Flag to True" in the group footer and suppress.
Right Click the Running Total in the Page Footer, and choose Format Field.
Click the X+2 buttong to the right of Suppress and enter this line into the editor:

booleanvar bFlag = True

This should work for you now.


~Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top