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:
|Vehicle Type||Name of Model||Price||Qty on Hand|
|Hundai i10 Sports||500000||20|
|Hundai i20 Sports||550000||5|
|Hero Honda Splendor||55000||50|
- Create Datasource connected with SQL Server 2012 sample Database Northwind “NorthwindDataSource”.
(as expianed in “Chapter-1-Creating a basic SSRS Report”)
- 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.
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.
In the Report wizard window just click next as we had already created DataSource as “NorthwindDataSource”
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
Choose tabular Report Type and click on next button
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.
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.
Now choose Table Style for Report as shown below and click on next button.
Click on finish button to open the report in the design view
In design view report will look like the image given below.
Now adjust the column width of Report and click on Preview button this completes “Chapter-18-Creating Group above or stepped report 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