locked
Crystal Reports - forcing next page RRS feed

  • Question

  • User-631236766 posted

    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

     

    Saturday, February 16, 2013 2:13 AM

Answers

  • User614805505 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, February 16, 2013 2:48 AM

All replies

  • User614805505 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, February 16, 2013 2:48 AM
  • User1880191058 posted

    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

    Friday, May 10, 2013 9:06 PM