In this article, we will show you how to create a New Report in SSRS Report Builder without using Wizard. Or we can say, steps involved in creating New Table, or Matrix report using SSRS Report Builder.
For this SSRS report builder table report, we are going to use the Shared Data Source and the Shared Dataset that we created in our Early reports.
To create a New Report in SSRS report builder, we have to open the report builder. To do this, Please open your report manager and click on the Report Builder button as shown in below screenshot
Create New Report in SSRS Report Builder
Once you click on the Report Builder button, SQL Server Report Builder will be open with a starting page
In this example, we want to create a new report in SSRS without using Report Builder Wizard so Please select the New Report tab, and then select the Blank Report option as we shown below
After you select the Blank Report option, the SSRS report builder will display the Blank Report. We already explained the Panes in our previous article, so please refer to Create a New Report article.
To create a data source, Right-click on the Data Sources folder present in the Report Data pane and select the Add Data Source option from the context menu
Once you click on that option, the SSRS report builder will open the Data Source Properties window to configure the Data Source. In this example, we are selecting the Shared data Source that we created earlier.
Please refer to Create Shared Data Source in Report Manager to understand the steps involved in creating Data Source.
To create a dataset for this report, Right-click on the Datasets folder present in the Report Data, and select the Add Dataset option from the context menu. It opens a new window, and from that window, you can choose the New Dataset option
It will open a New window called Dataset properties. Here you can select the first option to select the Shared Dataset that we created earlier, or by choosing the second option, we can create a new dataset also.
For this SSRS Report builder demo, we are selecting the first option. I suggest you refer the Create a New dataset in Report Builder article to understand the steps involved in creating the shared dataset.
Let me check the fields that the Dataset is returning.
Within the SSRS Report Builder, please select the Insert Tab to insert the table in to report designer.
Please click on the down arrow below the table button, and select the Insert table option to add the Table to the report region.
Drag and drop a table to the Data region.
Next, add the Columns to the Table. We already explained the steps involved in adding the Columns to the table fields in the Create New Table Report, so please refer to the same.
The following screenshot will show you the Columns that we added to the Table report.
Let me format the table report to change the overall look. I suggest you to refer Format Table Report to understand the list of available formatting options.
Please check the formatted final table report. Please adjust the width and height of all the Columns in a table.
Let me change the report name to Table report without using SSRS Report builder wizard, and click the Run button
Once you click the Run button, the following report will generate. From the below screenshot, you can see that the report is showing the Formatted Table report with the given fields.
Let me click on the Save button to save the report on the report server.
After you click on the Save option, a new window called Save As Report will open. Here you have an option to select the local file system or the Report Server. Let me select the SSRS Report Server
Let me open my SSRS Report Server to show the newly created Table Report. Here, If you want to see the report preview, or Run the report, then you don’t have to access the Report Builder or BIDS.
Just click on the Table report will run the report. Let me select the report that we saved previously and click on it
Now you can see the Table report that we created in SSRS report builder in Report Server