34759

Repeat a vertical line on every page in Report Builder / SSRS

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

I've tried using RepeatWith, but it doesn't seem to work, the line appears only on the first page.

Thanks

Answer1:

Is this for look and feel purposes only?

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

And yet another idea would be to use a rectangle with a left/right border and place all your tablixes inside the rectangle as this would make the rectangle to be expanded to multiple pages keeping the border (the vertical line) on your report.

I don't think that you can tell SSRS to automatically repeat lines on multiple pages.

Answer2:

I've figured out a way to solve that problem (without using RepeatWith, RepeatOnNewPage or Report Background Image)

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

For example, if the body height is 6" and height of a row is 0.5" then a total of 12 rows can be fitted into one page. So if your table has 4 rows then add 8 extra black rows so as to make the table height equal to the report body.

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

And you can have side borders on any of the columns as required, resulting in a vertical line running throughout the page.

Recommend

  • SQL Server Report Builder: Hiding Tablix Rows based on value in Subreport
  • SSRS Report is 'dropping' rows.
  • SSRS sum(distinct()) equivalent
  • JavaScript RegEx to match punctuation NOT part of any HTML tags
  • Multiple Actionscript 3 layers
  • Bash expand variable containing sed pattern correctly
  • Event difference bootstrap collapse
  • Get text between two elements JQUERY
  • SSRS 2008 - Sorting within a group
  • Best HTML5 structure for a layout where the title/header is outside the article tag
  • Change navbar in bootstrap if user login
  • Can I update/select from a table in one query?
  • Python/Javascript: WYSIWYG html editor - Handle large documents fast and/or design theory
  • WordPress > setting permalink option via script buggy?
  • Do I need to seed any random number generator before using EVP_PKEY_keygen of OpenSSL?
  • Ember.js model to be organised as a tree structure
  • How to add a focus style to an editable ComboBox in WPF
  • JqueryMobile Popup menu is not working
  • How can I speed up CURL tasks?
  • xtable package: Skipping some rows in the output
  • Groovy: Unexpected token “:”
  • how to display data from 1st point on words on y axis for line chart in d3.js
  • Jackson Parser: ignore deserializing for type mismatch
  • Replace value with Factor in r data.table
  • How to use remove-erase idiom for removing empty vectors in a vector?
  • Google Custom Search with transparent background
  • Android fill_parent issue
  • Extracting HTML between tags
  • How to access EntityManager inside Entity class in EJB3
  • Why is an OPTIONS request sent to the server?
  • Change JButton Shape while respecting Look And Feel
  • Android screen density dpi vs ppi
  • Read text file and split every line in MSBuild
  • C# - Serializing and deserializing static member
  • Bug in WPF DataGrid
  • Java applet as stand-alone Windows application?
  • How to apply VCL Styles to DLL-based forms in Inno Setup?
  • jquery mobile loadPage not working
  • Error creating VM instance in Google Compute Engine
  • java string with new operator and a literal