In this article we will show you, How to create 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 we are going to use the Shared Data Source, and the Shared Dataset that we created in our Early reports.
In order to create a New Report 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 opened with a starting page as shown in below screenshot. 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, report builder will display the Blank Report. We already explained about the Panes in our previous article so please refer Create a New Report article to understand the same.
To create 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, it will open 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 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. This will open New window and from that window you can select the New Dataset option
This 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 selecting second option we can create a new dataset also. For now we are selecting the first option. I suggest you to refer the Create a New dataset in Report Builder article to understand the steps involved in creating shared dataset.
Let me check the fields that the Dataset is returning.
Within the 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 from the Menu 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 Create New Table Report so please refer the same.
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 Report builder wizard, and click the Run button
Once you click the Run button, following report will be generated. From the below screenshot you can see that the report is showing the Formattd Table report with the given fields.
Let me click on the Save button to save the report in report server.
After you click on the Save option, a new window called Save As Report will be opened. Here you have an option to select the local file system, or the Report Server. Let me select the Report Server
Let me open my 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 inside the Report Server
Thank You for Visiting Our Blog