Using Crystal Reports 7
Have a report that displays items and their amounts in the Details section
The report includes a Group section where in the Group Footer it displays the total amount of all the items from the Details section above.
We print on custom paper that lays out all the sections i.e Titles on the Page Header section, a box for the Details etc...
Problem arises when the Details section takes the entire page or most of it, leaving not enough room for the Group Footer section to print. Instead of generating a following page (i.e another page header etc) it dumps the footer on to the top of the next page - so we are left with the Group Footer (the totals) being displayed on our customs titles etc.
Therefore we end up with the subtotals being unreadable because they are printed on top of the titles of the custom page.
For some reason I can't get Crystal to regonise that this particular record flows on to another page.
I've tried using a variable to force a page break, but this either leaves big gaps in the report or some parts of the footer still overflow into the top on the next page.
Ideally I need to tell Crystal that the footer section should always print from this point on the page downwards (i.e. that start of the details section) - never above this point
I hope this is clear
Can anybody offer any other suggestions I could look into ??
CheersIn Crystal Reports 8.5, there's a property in Group Footers called PrintAtBottomOfPage. Maybe there's something similar in version 7?|||Yes Print at Bottom of Page is available in Crystal 7, however this would leave quite a significant bit of white space if say I had only a couple of detail lines.
Any other suggestions ?|||FYI
Seem to have come up with a solution that works so far:
Have created another Page Header section - so now have Page Header a and b
Page Header b is the same size as my Group Header section. Under Supress format for Page Header b have inserted:
pagenumber =1 or
InRepeatedGroupHeader = true;
Meaning that Page Header b will appear when there is no Group header section on subsequent pages
Sweet as!
Monday, March 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment