Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard

The report going to be designed in on SQL server Tutorial on Northwind Database, so it recommended to download the database from Microsoft website. We are going to design a Basic SSRS Report through report wizard. For that we have to write a stored procedure as given below.

Download full Tutorial for Creating-a-basic-SSRS-Report in PDF Format

Download Sample Code for Creating Basic Tabular Report in SQL Server 2012

Create Procedure [dbo].[RPTSP_EmpList]
( @city varchar(12) )
As
Begin
select EmployeeID,LastName,FirstName,Title,TitleOfCourtesy,City,address
from  Northwind.dbo.Employees where City=@city
End

–exec RPTSP_EmpList ‘London’

Step 1: Open Microsoft BIDS

Step 2: Choose Report Server Project from the available project type, give a suitable name to the project and click on OK button.

After clicking on OK button the below screen will appear
After clicking on OK button the below screen will appear

Step 3: After clicking on OK button the below screen will appear

Step 5: Enter proper information in the Shared Data Source Properties.

Step 6: After clicking on the OK button, the following screen will appear

Step 7: Next click on Reports – > Add New Report

ReportsImages6

Design the Query window

Click on Query Builder button
Click on Query Builder button

Click on Query Builder button and the Query Designer screen opens up .Note that 2 options are there in the table type

  • Text (where we write the normal /inline SQL query)
  • Stored Procedure

 Note: we can click on the Import button and can specify the SQL file that contains the script. For specifying stored procedure , we need to specify the stored procedure name with a parameter name.

ReportsImages7
ReportsImages8
9

ReportsImages9

Step 8: Report created. If we look now into the Project Reports folder a new file ReportSSRS1.rdl is created.

ReportsImages10

Now let us click the Preview button to get the full report

ReportsImages11

If we have specified a parameter, then at the time of preview we need to give some value to it. This is how we can create a Basic SSRS Report with BIDS.

Previous Related Post:

Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from Asp.net
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report
Chapter-5 Creating a Sub Report in SSRS
Chapter-6: Creating a Drill Down Report in SSRS
Chapter-7: Working with expressions and custom code in SSRS
Chapter-8-SSRS (Reporting Services) Working with Calculated fields
Chapter-9-Sorting of Column and Custom Paging in SSRS
Chapter-10 : Creating and Deploying Web Services for SSRS
Chapter-11 : Creating SSRS Report by consuming Web Service Data Source
Chapter-12 : Working with Data Bars in SSRS
Chapter-13-Displaying Color in Data Bar Based on Condition
Chapter-14- Displaying Data Labels along with Data Bars in SSRS
Chapter-15-Displaying Indicators in SSRS
Chapter-16-Creating SSRS Linked Report
Chapter-17 Adding or Creating Drop Down Parameter List in SSRS
Chapter-18 Creating Group above or stepped report in SSRS
Chapter-19-Creating Multi Value Parameter Report in SSRS
Chapter-20-Using CSS Stylesheet in SSRS

Leave a Reply

Your email address will not be published. Required fields are marked *

*

3 × 2 =