Hour 8. Report with Style

 

This article shows how to create a style for an SSRS report. 

 

 

To add the report, right-click on "Reports", select "Add" and click on "New Item".

 

 

 

Select "Report" and provide the report name.

 

 

 

Right-click on the design surface then select "Insert" and click on "Page Header".

 

 

 

Right-click on the design surface then select "Insert" and click on "Page Footer".

 

 

 

Right-click on the page header, select "Insert" and click on "TextBox".

 

 

 

Create two textboxes, one is for "Report Header" and another is for "Report Header Detail".

 

 

 

Create a table in the database where we have EntityName with style parameters like "BackgroundColor", "Font" and so on. For each parameter create one column.

 

 

 

Now we set style parameter values for each entity in the database table. We set Black as the background color and White as the font color for the Header Title.

 

 

 

Right-click on "Shared Datasets" and select "Add New Dataset".

 

 

 

Provide an appropriate dataset name and select data source.

 

Provide a Stored Procedure name that selects the data from the preceding table.

 

 

 

Add a dataset in the report data, right-click on "Datasets" and click on "Add Dataset".

 

 

 

Provide a dataset name and select Use a shared dataset.

 

 

 

Select the "Report Header" text box and go to properties.

 

 

 

In properties, select "BackgroundColor" and click on "Expression…".

 

 

 

Set the expression as follows.

 

 

 

In the same way set the expression for the font color.

 

 

 

Now click on preview and you can see that the report header has a Black background and White font.

 

 

 

Now change the background color and font color in the database for HeaderTitle. Here we change the background color from Black to Red and the font color from White to Black.

 

 

 

In the preview tab click on the refresh button and your report style is changed based on the data you changed in the database.

 

 

Using the same pattern you can apply a dynamic style for all the entities in the entire report.