Chapter-18 Creating Group above or stepped report in SSRS

A Group above or stepped report is a type of report that shows detail rows or child groups indented under a parent group in the same column, as shown in the example below:

Download Full Tutorial for Chapter-18-Creating Group above report in SSRS



Download Source Code for Chapter-18-Creating Group above report in SSRS

Vehicle Type Name of Model Price Qty on Hand
Car
Maruti 800 350000 20
Maruti ALTO 400000 10
Hundai i10 Sports 500000 20
Hundai i20 Sports 550000 5
Bike
Hero Honda Splendor 55000 50
Bajaj Pulsar 80000 40
Bajaj Discover 35000 20





Prerequsite

  1. Create Datasource connected with SQL Server 2012 sample Database Northwind “NorthwindDataSource”.

(as expianed in “Chapter-1-Creating a basic SSRS Report”)

  1. Create a Report Server Project “BasicSSRSChapter18” using Visual Studio 2010 or higher Version (as expianed in “Chapter-1-Creating a basic SSRS Report”)

Step-1: Right Click on the Project  “BasicSSRSChapter18” and select context menu Add>New Items as shown in the image.

Click Add New Item from Context Menu
Click Add New Item from Context Menu

Add New Item window will appear choose “Report Wizard” and provide the name of the report as “Chapter-18-Creating Group above report in SSRS” as shown in the image and click oK button, it will bring the Report Wizard window.



choose “Report Wizard” and provide the name of the report as “Chapter-18-Creating Group above report in SSRS
choose “Report Wizard” and provide the name of the report as “Chapter-18-Creating Group above report in SSRS

In the Report wizard window just click next as we had already created DataSource as “NorthwindDataSource”

Select Shared Data Source
Select Shared Data Source

Step2: Paste the following query to Query Text Box as shown in the Image and click on next button.

SELECT CategoryName,ProductName,QuantityPerUnit,UnitPrice,UnitsInStock FROM Products p,Categories c where p.categoryID= c.CategoryID

Paste the above query in the Query Space
Paste the above query in the Query Space

Choose tabular Report Type and click on next button

Choose tabular Report Type
Choose tabular Report Type

Now from available column value from the Dataset put “CategoryName” cloumn in the Group textbox as shown and all other column in Detail section of Report and click on OK Button.

select the fields

Choose Report Table Layout window will appear choose “Stepped” and choose “Include Subtotal”  checkbox as shown in the image. Click on Next Button to complete next step.

appear choose “Stepped” and choose “Include Subtotal” checkbox as shown in the image
Choose “Stepped” and choose “Include Subtotal” checkbox as shown in the image

Now choose Table Style for Report as shown below and click on next button.

choose Table Style for Report

Click on finish button to open the report in the design view

Click on finish button to open the report

In design view report will look like the image given below.

design view report will look like the image

Now adjust the column width of Report and click on Preview button this completes “Chapter-18-Creating Group above or stepped report in SSRS”.

preview of report

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

 

 

 

Leave a Reply

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

*

3 + 1 =