Repeat the vertical line on each page in Report Builder / SSRS

Question

I want to include a vertical line on each page of my report, which runs top down from the body of the report. How can I achieve this?

I tried to use RepeatWith, but it does not work, the line is displayed only on the first page.

thanks

Answer 1

I figured out a way to solve this problem (without using RepeatWith, RepeatOnNewPage or report background image)

I wrote simple code to add empty rows to a table in the body. The number of rows added will be determined by the height of the body and the height of the line.

For example, if the height of the body is 6 ", and the height of the line is 0.5", then only 12 lines can be inserted into one page. Therefore, if your table has 4 rows, add 8 additional black rows so that the height of the table is equal to the body of the report.

If the number of lines is more than 12, say 15, then you will add [12 - (15 mod 12)] lines, i.e. 9 blank lines.

And you can have side borders on any of the columns as needed, with the result that the vertical line runs throughout the page.

Answer 2

Is this just for search and perception purposes?

I would create an image with such a string and use it as the background of the body. Or, if you use tablix that spans multiple pages, another idea would be to create an empty column in tablix with a border on the left side.

And another idea would be to use a rectangle with a left / right border and place all your tabs inside the rectangle, as this will cause the rectangle to expand to several pages, keeping the border (vertical line) in your report.

I don’t think you can tell SSRS to automatically repeat lines across multiple pages.