Currently viewing the category: "Formatting"

SQL Server Reporting Services (SSRS) Report Viewer Toolbar is being rendered black

By On · Add Comment

Problem: SSRS Report Viewer Toolbar is being rendered with a black background.

SSRS Black Toolbar

 

Solution: Make sure the BackColor property of the Report Viewer control is not set to an empty string (BackColor=”") or set the BackColor property to the desired color.

Example: BackColor=”White”

 

Result:

SSRS White Toolbar

How to export a report to Excel using only one sheet in SQL Server Reporting Services (SSRS)?

By On · Add Comment

Remove page breaks from your report.

  1. Click anywhere on your tablix.
  2. Right click on any of the gray row or column headers.
  3. Click on Tablix Properties.
  4. Remove page breaks by unckecking the page break boxes.

image

How do I include a line break in XML (\r in XML)

By On · Add Comment

The carriage return character in XML is represented by “
” (without the quotes.)

So, try using 

Example:

<XMLElement>.NET Tips and Tricks&#xD;This other text will be displayed in the next line.</XMLElement>

For reference you might want to look at the Canonical XML Version 1.0 from the W3C at http://www.w3.org/TR/xml-c14n