I have setup a multi-tab replicating report, when printing the entire workbook it is printing out 2-3 extra pages that are blank per tab.
How do I stop the blank pages from being printed?
I can't use select print area function as the report size changes based on the data pulling from Navision (some end up being one page and others 2-4 pages).
Date
Votes
1 comment
-
Jet Reports Historic Posts If the report size changes because of a an unpredictable no. of rows being returned from Navision, you can set the printrange to 1 row below the NL("Rows"). This in combination with scaling all row to fit the page could do the trick?
Do this for each separate sheet, or just once if sheets are being created from a NL("Sheets").
You can do something similar in case of a varying no. of columns.
Hope this helps?
Please sign in to leave a comment.