Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs

Create a New Report in SSRS

by suresh

In this article, we will show you how to Create a New SSRS report with an example. For this SQL reporting demonstration, We are going to use below shown Data Source and Data Set.

Please refer to Shared Data Source and Dataset articles to understand the steps involved in creating Shared Data Sources and Dataset that we used for this SSRS report.

Create a New SSRS Report

After creating a New 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.

We can create a new SSRS report in multiple ways: Using report Wizard, and Normal Mode.

Create SSRS Report using Wizard

First, we will show you the first option, alter we will show the other option. Right-click on the Report folder will open the context menu, and please select the first option Add New Report from it.

Create a New SSRS Report 1

Once you click on the Add New Report option, it opens the Report wizard. The first page is a Welcome screen. As we already explained the steps involved in creating a report using the wizard, Please refer Create a Report using the Report Wizard article.

Create a New SSRS Report 2

Create SSRS Report without using Wizard

In general, we don’t use the report wizard to generate any report. To create a report usually, first go to Solution Explorer. Next, within the solution explorer, Right-click on Reports folder -> Add -> New Item

Create a New SSRS Report 3

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.

Create a New SSRS Report 4

Let me change the Report name to a more meaningful one (FirstReport.rdl)

Create a New SSRS Report 5

Once you click on the Add button, a new SSRS report with the specified name will generate. If you observe the Report Data pane, we have five different folders.

  • Built-in Fields: These are the built-fields available in SSRS. You can use these items to show the page Numbers, Report Title.
  • Parameters: Used this folder to create parameters. Later, these parameters used inside the report. Please refer Report Parameters article to understand the steps involved in creating parameters.
  • Images: This is used to add images to the Report. Please refer Display Images Report article to understand the same.
  • Data Sources: This folder is used to create an Embedded Data Source. Please refer to the Embedded Data Source article.
  • Datasets: This folder is used to create an Embedded DataSet. Please refer to the Embedded DataSet article.
Create a New Report in SSRS 6

From the below screenshot, you can see the list of Report Items. We have to use these SSRS report items to create a report based on client requirements.

Create a New SSRS Report 7

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy