I have a crystal report in my program (using VS 2008, SQL Database) to print a corporate check (standard STUB/CHECK/STUB format). On the STUB, it prints out all of the invoices that the check is for. This is done in a subreport and it works fine. What I
would like it to do it is if the number of invoices exceeds 12, force it to a second page because only 12 invoices fit on a check stub. The second page would be a VOIDED CHECK (XXXX.XX) but would print the remaining invoices over 12 on the stub. For example,
if my check batch had a vendor where I selected 20 invoices to pay with one check, on page one it would list the first 12 invoices on the check stub, total all 20 invoices and create a check for the full amount, then on page two, print the remaining 8 invoices
on the stub and void the check on the second page. Right now my program and the crystal report works fine if you print 12 or less invoices on a stub - no more than 12 invoices fit on a stub. If I have more than that in my check batch, the check prints correctly
but only the first 12 invoices will print out on the crystal report in the space provided on the stub. I need to force it to print to a second page so that the remaing invoices print out on the stub so that I can mail one check (totalled correctly), with two
check stubs (from page one and page two). Can anyone give me some insight?
I'm checking to see if either of those solutions worked for you. I'm also creating a Stub-Check-Stub in Crystal, with the first stub in the Details section and the check and second stub in the Page Footer A and C respectively. The Stub in the Details section
is working perfectly. The stub in the Footer is correctly cutting off at 10 records on the first page, but when I advance to the second page of the check, the second stub is repeating the same 10 records as the first page.
I'm using a subreport for each detail section.
The links in the answer seemed to be applicable for the stub in the details section, but there is no 'new page after' checkbox for the footer section. I have opened the subreport and checked the 'new page after - 10 visible records' checkbox in the subreport.
It just doesn't seem to know it is on page 2.
If you were able to get it working, please let me know what you did. If anyone else has a suggestion, I'd be grateful!
TFLerew325
0 Points
2 Posts
Crystal Reports - forcing next page
Feb 16, 2013 06:13 AM|LINK
Hello everyone;
I have a crystal report in my program (using VS 2008, SQL Database) to print a corporate check (standard STUB/CHECK/STUB format). On the STUB, it prints out all of the invoices that the check is for. This is done in a subreport and it works fine. What I would like it to do it is if the number of invoices exceeds 12, force it to a second page because only 12 invoices fit on a check stub. The second page would be a VOIDED CHECK (XXXX.XX) but would print the remaining invoices over 12 on the stub. For example, if my check batch had a vendor where I selected 20 invoices to pay with one check, on page one it would list the first 12 invoices on the check stub, total all 20 invoices and create a check for the full amount, then on page two, print the remaining 8 invoices on the stub and void the check on the second page. Right now my program and the crystal report works fine if you print 12 or less invoices on a stub - no more than 12 invoices fit on a stub. If I have more than that in my check batch, the check prints correctly but only the first 12 invoices will print out on the crystal report in the space provided on the stub. I need to force it to print to a second page so that the remaing invoices print out on the stub so that I can mail one check (totalled correctly), with two check stubs (from page one and page two). Can anyone give me some insight?
Thank you.
Todd
CruzerB
Contributor
5399 Points
1098 Posts
Re: Crystal Reports - forcing next page
Feb 16, 2013 06:48 AM|LINK
Hi,
http://stackoverflow.com/questions/11189049/page-breaks-in-crystal-reports-by-a-condition
http://stackoverflow.com/questions/10808768/crystal-reports-break-page-after-certain-of-details
Maybe these two posts can help you.
My Technical Blog
SPetr
Member
2 Points
1 Post
Re: Crystal Reports - forcing next page
May 11, 2013 01:06 AM|LINK
Hi,
I'm checking to see if either of those solutions worked for you. I'm also creating a Stub-Check-Stub in Crystal, with the first stub in the Details section and the check and second stub in the Page Footer A and C respectively. The Stub in the Details section is working perfectly. The stub in the Footer is correctly cutting off at 10 records on the first page, but when I advance to the second page of the check, the second stub is repeating the same 10 records as the first page.
I'm using a subreport for each detail section.
The links in the answer seemed to be applicable for the stub in the details section, but there is no 'new page after' checkbox for the footer section. I have opened the subreport and checked the 'new page after - 10 visible records' checkbox in the subreport. It just doesn't seem to know it is on page 2.
If you were able to get it working, please let me know what you did. If anyone else has a suggestion, I'd be grateful!
Thanks!
-S