In this article we will show you, How to create Table Report in SQL Server Reporting Services 2014.
Creating Report without using Report Wizard in SSRS 2014
After creating New SSRS Project, We have three folders in the solution explorer such as Shared Data Sources, Shared Datasets and Reports. Reports folder is enough to design a basic report.
In the solution explorer, Right click on Reports folder ->Add -> New Item
It will open the Add New Item window with all the available option. Please select the Report option and rename it as per your requirements. In this example, We are renaming it as NEW SSRS REPORT.rdl
Click on the Add button to create Blank report as shown in below screenshot.
If you don’t find the SSRS Toolbox then press Ctrl+Alt+X or goto View tab and select the Toolbox
Drag and drop table from SSRS toolbox to the Data region.
In this example, we are using the already created Data Source and Dataset. Please refer Embedded Data Source and Embedded Dataset article to check the data.
We can add the Column names to the Table in two ways:
- We can Drag the Column name from Report data to the Table Column.
- When we click on particular cell, it will open the context menu displaying available column names in that Dataset. We can select the required column from the list as shown in below screenshot
We successfully created our first SSRS table report. Columns we selecting for our First report are: English Product Name, Color, Sales Amount and Tax Amount (Renamed the TaxAmt).
Click on the Preview button to see the report preview
Thank You for Visiting Our Blog
