Tablix Pagination – spacing between report header and column headers in PDF renderer.
Hello,
Worth mentioning that I’m working off of Power BI Report Builder, but I think this is applicable to SSRS report builder as well.
When I make a Tablix that spans multiple pages in Report Builder, the column headers are directly under the page header (literally 0px between them), which I don’t think is the nicest looking thing. I’m looking to add a ‘space’ of 0.5″ or so of whitespace when the table paginates.
Things I’ve tried:
1. Implementing an ‘invisble’ (not hidden) static row with RepeatOnNewPage = True. This caused issues with my tablix border, which was set to ‘solid’ and would show on the ‘invisible’ row. Setting the borders on a ‘per-cell’ basis did not produce as nice of a look.
2. Adding a hidden rectangle with RepeatWith set to my tablix. This works on the report viewer and .mhtml export, but not PDF.
Has anyone had any luck with doing this? I don’t mind a more complex solution if necessary. I can’t imagine this is an uncommon issue, but my google-fu is failing me at the moment.
Hello, Worth mentioning that I’m working off of Power BI Report Builder, but I think this is applicable to SSRS report builder as well. When I make a Tablix that spans multiple pages in Report Builder, the column headers are directly under the page header (literally 0px between them), which I don’t think is the nicest looking thing. I’m looking to add a ‘space’ of 0.5″ or so of whitespace when the table paginates. Things I’ve tried: 1. Implementing an ‘invisble’ (not hidden) static row with RepeatOnNewPage = True. This caused issues with my tablix border, which was set to ‘solid’ and would show on the ‘invisible’ row. Setting the borders on a ‘per-cell’ basis did not produce as nice of a look. 2. Adding a hidden rectangle with RepeatWith set to my tablix. This works on the report viewer and .mhtml export, but not PDF. Has anyone had any luck with doing this? I don’t mind a more complex solution if necessary. I can’t imagine this is an uncommon issue, but my google-fu is failing me at the moment. Read More
