Is there any way to export a report to excel that will put all the data on a single sheet. Right now my report is being broken up into 8 sheets. I know I can expand the height of the page to some huge number to force it to a single sheet, but I’m wondering if there is some setting i’m missing that would just force the report to a single sheet.
1 Like
Did you find an answer? I’ve tried grouping and reviewed the IU videos and still get a page per “sheet”…
No I was never able to find a solution to this. My single page is just incredibly long so that it exports to a single page. But its difficult to work with on the design side.
Hello! Did you find a way to solve this? I have the same need with a report which has lot of rows and I want only one sheet.
This is the only "solution" to this problem. The reporting engine doesn't collapse report content down in any other way.
I’m a little late to the party, but I just ran into this myself. You can export it as a .csv file to have everything on one ‘sheet’.
Yes but the csv file repeats the header after every so many rows that fit on one sheet in the case of an excel file.
Just posting as I'd be also interested in getting all rows in a single sheet.
Expanding height would not work in all cases because amount of data can be different regarding user inputs.
Ignition include the Apache POI java libraries, which allow custom construction of arbitrary Excel files from your data. (Also some built-in, like system.dataset.toExcel(), among others.)
Numerous script examples are on this forum.
The reporting module's primary purpose is to make printable PDF files. The alternate formats are renderings of page-based PDFs.
1 Like