SQL Server Reporting Services – Opening an RDL in Older Version of Visual Studio Opens as XML

In order to fix this issue, you need to remove a few lines of code from the XML.

    1. Replace xmlns with:
      <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
    2. Remove only the Report Section header and footer tags (leave the child elements)

SQL Server Reporting Services (SSRS) – Order by different values from the same database table column

Let’s say you want to order your data in your tablix by last name, but you want certain names to be sorted first.

1) Double click the first grouping under Row Groups.
2) Select ‘Sorting’.
3) Click the ‘Add’.

SQL Server Reporting Services (SSRS) – Alternating row color with visible rows

Use the Alternating Row Color code function and call it from the BackgroundColor property of the tablix row column.

Here is the Function that needs to be placed in the Code tab of the Report Properties window:

Function AlternateColor(ByVal OddColor 

SQL Server – Multiple data rows into one generated column, XML Path char(13), and removing that last carriage control in SSRS Expression

Let’s say you have a table called ‘car_make’ and another table called ‘car_model’. There is a one to many relationship between make and model.

You want to bring back a result set of all makes, 1 row per make, but …

SQL Server Reporting Services (SSRS) – How to use an image as the layout of the report and then place conrols on top to display the data

1) On the body of the report, drag a tablix. Make the first row the height and width of your page. Call the Tablix ‘TheTablix’.

2) Drag a rectangle into the first row of the tablix. Call the Tablix ‘TheRectangleRow1’.…

SQL Server Reporting Services (SSRS) – Creating Full Width Group Headers in SSRS

Creating Full Width Group Headers in SSRS


Dealing with group headers in banded reporting tools like Crystal Reports feels easy and natural. The group header section is clearly visible