Wednesday, March 21, 2012

Matrix Reports Spawn Extra Page - Enclosing in List fixes this.

We really like using the Matrix reports, but we were finding that every Matrix report that we created would spawn an extraneous blank page. We tried putting the matrix in a rectangle, which works well for positioning other items on reports, but this had no effect on the problem.

Then we tried placing the matrix in a list with the list group details set to "=Nothing". It worked great - no more extra pages. Looked and didn't see this tip mentioned elsewhere so thought it might be worth sharing.

This usually happens because you have too many columns in your matrix, and it is spreading onto a second page horizontally.

Several other ways to fix this are: have less columns; make the columns and the fonts within them smaller; decrease the size of the margins on the report page; and alter the report page dimensions so that it is rendered in landscape mode.

No comments:

Post a Comment