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

CR6 multi page check? 1

Status
Not open for further replies.

dougdnh

Programmer
Apr 13, 2001
4
US
I am trying to get a check to print on a duplex printer, that will print an address on the back. By adding a dummy Group Footer #2, I am having some success. However, this is causing Group Footer #1 to not print at bottom of page on the first page, even when the bottom of page option is set. Is there any way to get this to work?
 
I am sorry, you will have to provide more info. I am not sure what you are trying to accomplish. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Here is a more detailed explanation of our dilemma: We are using a Crystal report in Crystal 6 to print our AP checks. This Crystal report is in fact PeopleSoft's Check1.rpt.
We are printing the checks as stub over check to a duplex printer. What we need to happen is have a mailing address print on the reverse side. PeopleSoft suggested adding an addtional Group Footer (Group Footer #1b). This does work, by causing the check to again reprint on the back, and we could suppress the unwantd lines on this second copy. The problem we are running into is that when adding the Group Footer #1b, and setting the 'New Page Before' on it, the Group Footer on the first page refuses to print at bottom of page, even with the 'Print at Bottom' on. As soon as we remove the Group Footer 1b, the Group Footer 1a prints fine, but then we don't get the second page. Is there any way around this? Ken, thanks for your response!
 
You might try adding another group on the same field, rather than simply splitting the seciton. Now, CR won't let you group by the same field twice, but if you create a formula with that field as the formula, and group on the formula, you will have two GH and GF sections that behave like subsections. However, they should allow the "print at bottom" with a page break between. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
I have created another group on the same field as per the above tip, and the printing is now working, except when I encounter a multi line check. These are checks with multi details for the same group. For these checks, only the first detail line prints, but no following detail lines, and no group totals.
 
Nothing that we have discussed should affect how the detail section prints. Was it working correctly before you made the changes I described? Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
What I did was add another group as the formula of the original group. I had to make the 'real' group group #2, and the dummy group as group#1 (it doesn't work the other way around). It works fine (prints the check & stub, then the duplex page) until I hit a check with multi detail lines, all in the same group. It then prints the first line, skips the rest of the details, skips the group total,prints the page footer, and then goes to the duplex page. The multi line checks print fine when not using the dummy group, but I can't get the duplex page then. I wonder if what I'm trying is possible!
 
>>I had to make the 'real' group group #2,
>> and the dummy group as group#1
>>(it doesn't work the other way around)

What doesn't work? You are using the exact same database field in the formula as you are for the group?

Doesn't make any sense. Adding a group shouldn't effect the details.
Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top