# Problem with pagination on crosstab report **URL:** \ **Category:** Ignition\ **Created:** [May 23, 2010, 11:08pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859 "2010-05-23T23:08:44Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![ISDProj](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@ISDProj](https://forum.inductiveautomation.com/u/ISDProj)\ **Post date:** [May 23, 2010, 11:08pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/1 "2010-05-23T23:08:44Z")
I have a curly one for anyone to solve… We have used the “reporting module” in ignition to generate a crosstab report with multiple grouping and have an issue with the way it paginates the report. I have not been able to get the report to keep the text size static & spread across, or down, multiple pages. Instead it tries to “fit” it all into a single page as per the attached example ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/b86567ac7312f20f267d48527466e15a5a094447.png) As you can see it condenses the report into one page no matter how many columns or rows there are. Any Ideas how to fix this would be appreciated. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [June 3, 2010, 11:13pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/2 "2010-06-03T23:13:49Z")
Can you export the offending window and post it here? With the data filled in? ---
**Author:** ![ISDProj](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@ISDProj](https://forum.inductiveautomation.com/u/ISDProj)\ **Post date:** [June 4, 2010, 4:21am UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/3 "2010-06-04T04:21:16Z")
Carl, Id rather not post the report to the forum (due to the nature of the data contained there-in) so I have uploaded it to the “support” link instead - it will be named “ReportDowntimeHyne.vwin” You can ignore the “tabs” other than the “Report” one. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [June 4, 2010, 2:56pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/4 "2010-06-04T14:56:53Z")
Of course, I understand. We’ll take a look, thanks. ---
**Author:** ![ISDProj](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@ISDProj](https://forum.inductiveautomation.com/u/ISDProj)\ **Post date:** [June 10, 2010, 1:44am UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/5 "2010-06-10T01:44:31Z")
Carl Not that I’m pushing (I am really) but have you had a chance to look at this for me? ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [June 14, 2010, 7:03pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/6 "2010-06-14T19:03:00Z")
I will be looking at this later this afternoon ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [June 21, 2010, 7:59pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/7 "2010-06-21T19:59:29Z")
Ok, so right now the reporting plugin does paginate vertically on the crosstab, meaning it will expand onto more pages as more rows are returned. However, the crosstab does not paginate horizontally. The report you get is correct, it is just that you have so many groupings that the data gets crunched onto a single page. So the only thing you can do is make the page size of the report bigger where the printer will decide how to break it up. ---
**Author:** ![ISDProj](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@ISDProj](https://forum.inductiveautomation.com/u/ISDProj)\ **Post date:** [June 21, 2010, 9:40pm UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/8 "2010-06-21T21:40:24Z")
Travis, So is this horizontal pagenation by a “change” to the reporting plugin? I ask this because from what I have seen I cannot get the report to “paginate” - i.e. Yes it does change pages when the first grouping column changes, however until that column changes it continues to “crunch” all of the lines on a single page. ---
**Author:** ![ISDProj](https://avatars.discourse-cdn.com/v4/letter/i/58956e/32.png) [@ISDProj](https://forum.inductiveautomation.com/u/ISDProj)\ **Post date:** [June 25, 2010, 6:16am UTC](https://forum.inductiveautomation.com/t/problem-with-pagination-on-crosstab-report/1859/9 "2010-06-25T06:16:07Z")
Travis / Carl, I have managed to get a “sort of” workaround happening for this pagenation problem. What I did was to add another (Yes, more) grouping to the crosstab which had the key being a combination of the other groupings (all strings fortunately) i.e. Key = g1 + g2 + g3 + g4 + g5 + g6 then changed what was being displayed to being a “.” and shrunk the cell so that it wasn’t really visible. The only ugly part about this solution is that the remainder of the column groupings are now repeated on each row of the report. Is there any way that you know of to “hide” the repeated group values - like it does normally. e.g. `G1 G2 G3 G4 G5 G6 . **** **** ****. **** **** **. **** ****. **** **. ****. **. **** **** **. **** **`etc… rather than: `. **** **** ****. **** **** ****. **** **** ****. **** **** **** `etc… I tried using `@if(Up.==," ",)@ `but it ends up with every row being blanked out because Up. on the first row still returns the first row value.