SSRS – Grouping – How to group the some particular fields in SSRS Reporting Services - Part 6
SSRS – Grouping – How to group the some particular fields in SSRS Reporting Services.
Last few weeks i have been working with SSRS Reporting Services, moreover i shared some topices with you. It will be my success if any one reader uses my article.
SSRS – Grouping – How to group the some particular fields in SSRS Reporting Services
Open SQL Server Business Intelligence Development Studio
Add a new report names grouping_report.rdl
Set the Connection Properties ( If not familiar, look up previous sessions )
Select AdventureWorks Database
Paste the following query in Data Tab and execute it and find the output in the same screenSelect A.FirstName,A.LastName,B.Title,B.BirthDate,
C.AddressLine1,C.City
from Person.Contact A inner join HumanResources.Employee B on A.ContactID=B.ContactID
inner join HumanResources.EmployeeAddress D on B.EmployeeID = D.EmployeeID
inner join Person.Address C on C.AddressID=D.AddressID
order by C.City
In Layout tab, Design the reports as like below
Click Preview and find the report output
Grouping
Select the Header Fields row and right click
Select Insert Group
In Grouping and Sorting Properties, do the changes like below
After grouping, screen looks like below
Click preview ( Note : There is no changes, because we should hide city field )
Select the City(Grouping) Field and right click and select Properties
In Properties Window, Select Hide duplicates option and select group name in the dropdown listbox
Now click preview and find the difference
Tree View Grouping
If you want to see the grouping fields in tree view format, select Edit Group
In Grouping and Sorting Properties Window, Select our grouping field(City) value in
dropdown listbox near Document map label:
Click Preview
Here, you can find separate explorer window named your grouping name (which mentioned while creating this report)
Click that + button, you can find lot of groups(City)
Select a particular city and find their corresponding values
Conclusion
Do the above steps properly and enjoy grouping
Reference: http://www.dotnetspider.com/resources/42873-SSRS-SQL-Server-Reporting-Services-Create.aspx
Follow