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 easily create a new project in SSRS, shared data source and data set then you can 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.
Now provide the following details.
> 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 at the end, we need to right click on last column’s header then click on Insert Column > Next, select Right .
As we have to add two column then we repeat this step for 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.
Also Read..
How to create a new project in SSRS
