10 Easy steps to walk through with SSRS

In this post I am giving the 10 easy steps to create the SSRS report.

Step 1 : Write a SQL function or stored procedure which we will use in SSRS.

Step 2 : Open BIDS(Business Intelligence Development Studio) and Add new project. In side that project open solution explorer and right click on report folder and click on add new item.

Step 3 : In this dialogue select Report and Give it a name like CustomerReport

Step 4 : Now Click on View and select Report Data. In this explorer select Data Source folder and right click and say Add Data Source

Step 5 : In the below dialogue box click on edit and give the datasource connection details.

Step 6 : Now click on Add dataset

Step 7 : Now in the below dialogue box select stored procedure radio button and give the your stored procedure name in the textbox.

Step 8 : Right Click on report and click on insert then you will get the list of control for the report. Select Page Header, Page Footer, table and one text box in header and two text box in footer.

Step 9 : Now go into the table properties and assign dataset to it. Now give the field name to each column. In the header text box write "Customer Details". At the footer in one text box write '= "Page:  " & Globals!PageNumber & "  of  " & Globals!TotalPages' this will give the page count and in second text box write '=FORMAT(Globals!ExecutionTime,"MM/dd/yyyy hh:mm tt")' this will give the report execution time.

Step 10 : Now Click on preview and see the report.

Thx,
RS