reporting-servicesrdlssrs-2016

SSRS add Horizontal gridlines on Tablix to occupy the remaining space of report body in PDF format


I know this question has been asked multiple times and were already answered using workarounds multiple times also. But just in case this 2021, someone might have a better solution for this.

What I have tried so far:

  1. Background Image - It's hard(impossible) to align the contents perfectly.
  2. Adding additional table rows and show/hide them based on row count. - Sometimes a row content could occupy more than 1 rows, thus generating an extra page.

This is my desired output. Desired Output

But then, this inevitably happens: Page 1

enter image description here

Any suggestions, workarounds, opinions are gladly accepted. If ever an official solution exists, much better. Thanks.


Solution

  • Add additional logic to your hidden logic to account for the extra space in the Remarks.

    This will add additional rows for every 60 characters:

    CountRows() + SUM(INT(LEN(Fields.Remarks.Value) / 60))
    

    You may have to play with the 60 number - it's just a guesstimate based on the remarks in your example. It won't be perfect since two text lines don't quite make up a single row but it should be close.