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.
