I have a report that has a dynamic range of columns. Currently we have two report files - one with 9 columns (portrait) and one with 15 (landscape). If we want larger number of columns, how could I create such a report?
Our first thought if the user select more column than what each report can handle, then we simply print the report multiple times. eg: Using the portrait report. First print use columns 1-9 data, then the second report might print columns 10-18 etc. This seems relatively simple to do (but maybe there is a better solution?). The problem with our idea is page numbers? If we print the report multiple times, the pages numbers are incorrect, each run always starting at page 1.
Any thoughts on how to solve the multiple columns and the page numbers? Or can LazReport print larger than a page report, and span it automatically over multiple pages (eg: what Excel or OpenOffice Calc can do?