SQL Server Reporting Services (SSRS) – James Software Development Corner

SSRS Report throwing #Error when attempting to convert RTF to Text using Code-Behind

After upgrading from sql2008 to sql2014, the code-behind of the rdl report used to convert RTF to Text was failing and displaying #Error instead of the converted text. There are numerous reasons this can happen, but for me, it was …

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.

Replace xmlns with:

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

Remove only the Report Section header and footer tags (leave the child elements)
```
<ReportSections>
<ReportSection>

..................................
```

…

SQL Server Reporting Services (SSRS) – How to Hide Columns When Exporting to CSV

You can suppress elements that you don’t want to include in a CSV export by doing the following:

Click an element.
In the properties windows, Choose “NoOutput” in the DataElement Output property.

…

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’.
4)

…

SQL Server Reporting Services (SSRS) – How to Stop Creation of rdl.data Files

An rdl.data file will be created each time when the report is viewed with different input parameters. The data file caches the data so running the report again in the IDE with no changes to the parameter data will render quickly. …

Hide duplicate row SSRS 2008

Let's say you have a SQL table with 2 columns. The first column is a name and the second column is a street address. For every address a name has, the name column is repeated for every row as such:

name …

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 Reporting Services (SSRS) – Add a Group Row Header to an Existing Group Row

If you want to add a group row header to an existing group row in order for that group row header to repeat on each group break, do the following.

In the Row Groups Panel below the report designer in

…

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’.…