Apr 22 2024 08:31 AM
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.
May 23 2024 07:08 AM