Step by Step SSRS in 11 Hours: Hour 8

Introduction

 

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

 

Contents

• Hour 1: What is SSRS and determine whether it is installed
• Hour 2: Report using wizard
• Hour 3: First SSRS report
• Hour 4: Report with parameter
• Hour 5: Custom template
• Hour 6: Drill down report
• Hour 7: Sub report
• Hour 8: Report with style
• Hour 9: Report with chart
• Hour 10: Report deployment
• Hour 11: RDL file to ASP.Net

SSRS Report with Style

 

Step 1

 

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

 

 

Step 2

 

Select "Report" and provide the report name.

 

 

Step 3

 

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

 

 

Step 4

 

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

 

 

Step 5

 

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

 

 

Step 6

 

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

 

 

Step 7

 

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.

 

 

Step 8

 

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.

 

 

Step 9

 

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

 

 

Step 10

 

Provide an appropriate dataset name and select data source.

 

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

 

 

Step 11

 

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

 

 

Step 12

 

Provide a dataset name and select Use a shared dataset.

 

 

Step 13

 

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

 

 

Step 14

 

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

 

 

Step 15

 

Set the expression as follows.

 

 

Step 16

 

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

 

 

Step 17

 

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

 

 

Step 18

 

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.

 

 

Step 19

 

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.

 

Next >>  Hour 9: Report with chart