Create New Report in SSRS Report Builder

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

Open Report Builder from Manager

Create New Report in SSRS Report Builder

Once you click on the SSRS 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

Select New Blank Report 2

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.

It open a Black Page to design 3

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

Add Data Source 4

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.

Select Data source 5

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

Add Dataset 6

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 to the Create a New dataset in Report Builder article to understand the steps involved in creating the shared dataset.

Select Shared DataSet 7

Let me check the fields that the Dataset is returning.

Check the Fields or Column available in a dataset 8

Add Table

Within the SSRS Report Builder, please select the Insert Tab to insert the table in to report designer.

Create New Report in SSRS Report Builder 9

Please click on the down arrow below the table button, and select the Insert table option to add the Table to the report region.

Insert Table report in SSRS Report Builder 10

Drag and drop a table to the Data region.

Create Table Report in Report Builder 11

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.

Create Table Report in Report Builder 12

Format

Let me format the table report to change the overall look. I suggest you refer to Format Table Report to understand the list of available formatting options.

Format Table Report in Report Builder 13

Please check the formatted final table report. Please adjust the width and height of all the Columns in a table.

Create New Report in Report Builder 14

Let me change the report name to Table report without using the SSRS Report builder wizard, and click the Run button.

Hit Run Button 15

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.

Create New Report in Report Builder 16

Let me click on the Save button to save the report on the report server.

Save Report in Report Builder 17

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 Report Server

Create New Report in Report Builder 18

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

Save Report in Report Manager 19

Now you can see the Table report that we created in the SSRS report builder in Report Server.

View report in report manager 20