How to create a SSRS Detail Report or Tabular Report .

To Creating a SSRS Detail Report , First we have to create new project and create a data source and data set . We can also take an existing project solution .

If you are new to SSRS report then , first read the following posts

How to create a new project in SSRS ?

How to create a Shared Data Source and Shared Data Set in SSRS ?

After reading these post  you can eaisly create a new project in SSRS, Shared Data source and Data set. then only you have to create a report .

> Create a new project in SSRS

> Next, Create a shared data source

 

>then ,Create a Shared data set

 

Now we will create a Detail Report / tabular Report

> Right click on Reports folder

 

>Then , Click on Add in Context menu > Next, Click on New Item…

 

Once you click on New Item.. a Add New Item window pop opens

>Select Report > then , specify report name > Next, Click on ADD Button

After Clicking on ADD Button , we see a empty report is created .

As we can see two tabs , a design tab that is used to create a report & a preview tab that is used to see the preview of report after designing or , an output of report.

 

Now, Right Click on Data Sources > Next , Click on Add Data Source..

 

After Clicking on Add Data Source.. > A Data Source Properties window opens

> Name : Specify Name  for data source

> Embedded Connection : If we want to create a new connection string then you can select a Type of source type and specify connection string clicking on Build..  button

> Use Shared Data source reference : If you have already created a shared data source , you can choose it from drop down list else you can create a new data source , ( here we are using an existing shared data source) .

> Next , click on OK Button

 

 

After finishing up the Data source step , we add a data sets for this report.

> Right click on Datasets Folder > then , Click on Add Datasets..

 

 

Once we click on Add Dataset.. , we see a Dataset Properties window opens.




Now we have two option either choose Use a shared dataset or Use a dataset embedded in my report 

In Use a shared dataset: we can use an existing dataset

In use a dataset embedded in my report: We can use custom dataset only for this report.

here we are using this option as it allows us to create a custom query or use an existing stored procedures.

 

After following all the steps through 1- 6 > click on OK button .

Once we click on OK button , we see dataset is created and all the columns that we have selected in our query is showing in dataset.

Now we will design a report using these data set and tool box pane.

> Select Table from Toolbox , and drag it into design pane – it will create a table that is used to show report data.

After adding a table , our design pane look like as

Now we add columns to table that we want to show in our report.

To do this we will drag those columns one by one to table columns from a Dataset.

 

 

As we can see , By default table have only three columns and we have to display five columns in our report. so , in this case we have to add two more column in our table.

Suppose we want to add new column in this last , so we need to right click on last column header >

then , click on Insert Column > Next, select Right .

As we have to add two column then we repeat this step two times

 

After adding column , it will look like as shown below.

Now our report is ready ,to see the report output & design > click on preview tab.

It is simple format of report , we can also customize its font , alignment or color .

To do this go back to design tab – click on design tab > select table > Press F4 key top open the property window

 

We can customize the report as per the requirement, Now to see the report preview we click again on Preview tab.

 

We can also download the report , refresh the report and set report page width.

How to create a new project in SSRS

Shared Data Source

 Shared Data Set

 74 total views,  2 views today