Paging Issue on printing Invoices

building reports crystal reports
1

Hi Guys,

First of all thankyou to anyone who is able to offer any assistance!

I have created a report that prints out multiple invoices. Some basic rules are that when the invoices are being created they must not print onto the same page as a different invoice.

For example

Invoice 1 is three pages and invoice 2 is two pages. There has to be a page gap between invoice 1 and 2 otherwise the last page of invoice 1 and the first page of invoice two will print onto the same page. To resolve this issue I added a section into the group footer that forces a new blank page between the invoices if the last page of an invoice is an odd number.

This is the formulae I added into the New Page After Section:

pagenumber Mod 2=0

This generated a new issue in that an additional blank page was being printed after the very last invoice. To resolve this I added the a suppression to the same section I had the new page after section for the last record.

At this stage everything is working… except for my page numbers for the invoices. If I add a reset page number formulae it breaks the above onlastrecord formulae. Can anbody offer a soloution so that I can have the page number’s print correctly for the invoices and that the pages do not overlap onto the same piece of paper.

pidgeon001 :australia: (BOB member since 2012-03-06)

2

I have mostly resolved this issue. At this stage no further assistance required.

I ended up using a count fomulae in the group header for invoice no that resets for each invoice number.

pidgeon001 :australia: (BOB member since 2012-03-06)

3

Hi guys,

Apparently I’m still stuck on this.

The problem I’m having now is that I can only do one of the two things, but I need to do both

  1. Have pages print so that they do not print on the same page as another invoice
    OR

  2. Have the correct page numbers showing i.e page 1 of 2

  3. To have the invoice display on the correct page I have add the following formuale into group footer 4f in the New page after section “pagenumber Mod 2=0”

  4. To have the correct page number showing I click reset page number after in group footer 4e. However this stops group footer 4f function from working.

pidgeon001 :australia: (BOB member since 2012-03-06)

4

I have finally killed this beast!

For any who are interested this is what I did.

  1. Created a brand new report and pulled in the table with invoice no in it.
  2. Grouped this report by invoice no
  3. in the group header added a subreport which linked to my original report
  4. In the main report in section expert ticked the option ‘reset page number after’ in group header 1.
  5. For the group footer added the following to Suppress and New Page After
pagenumber Mod 2=0
  1. Ticked “reset page number after” in the group footer
  2. In the Page Footer added the following to supress
TotalPageCount=1
  1. Supressed all other sections.

pidgeon001 :australia: (BOB member since 2012-03-06)