The invoice is created in a landscape format hence I have the address to be printed on the back of the invoice in a portrait format.
The issue I am having is when I print a group of invoices of different clients in one .pdf, and I need to add an extra blank page for each invoice that has odd pages count, because I need to print them using double-side print.
Example:
Invoice #1: 2 pages
Invoice #2: 1 page
Invoice #3: 1 page
I need to print a pdf with 6 pages (page 4 and 6 should be empty).
I’ve seen posts about this type of thing on other forums, but have never attempted it.
Some will add a rectangle (or even a subreport) that forces a blank page… but that rectangle is only visible if the page number is odd.
The trick is, you can’t reference page numbers in your report outside of the header/footer. So you’ll need to research how to reference the page number within the report. Then if it is even, the rectangle is not visible and the next group starts. If one of your invoices ends on an odd number, the rectangle is then visible which forces a blank page.
Again, haven’t done it so I can’t speak to how to set it up… but I would do some online searching with terms relating to SSRS, Report Builder, Duplex, etc. and see if you can put the pieces together.
Gotcha! Well, I would go with what @dcamlin says above and was going to be my proposed solution to you is create an item which only appears (visible/not hidden) when you will NOT have a normal page 2 for your invoice for force add one to keep the double sided output sequenced properly and be sure to setup the printer settings to NOT remove blank pages as this can also cause a different problem for you.