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

Create New Report in SSRS Report Builder 1

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

Create New Report in SSRS Report Builder 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.

Create New Report in SSRS Report Builder 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

Create New Report in SSRS Report Builder 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.

Create New Report in SSRS Report Builder 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

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

Create New Report in SSRS Report Builder 7

Let me check the fields that the Dataset is returning.

Create New Report in SSRS Report Builder 8

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.

Create New Report in SSRS Report Builder 10

Drag and drop a table to the Data region.

Create New Report in SSRS 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 New Report in SSRS Report Builder 12

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.

Create New Report in SSRS 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 SSRS Report Builder 14

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

Create New Report in SSRS Report Builder 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 SSRS Report Builder 16

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

Create New Report in SSRS 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 SSRS Report Server

Create New Report in SSRS Report Builder 18

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

Create New Report in SSRS Report Builder 19

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

Create New Report in SSRS Report Builder 20