I am asking this question since I am new to working with report builder 3.0 that runs on sql server 2008 R2. I would like to know how to display the data by grouping levels. There will be no amounts to calculate summary data.
When I supply data to the report builder 3.0 report, the sql (stored procedure) will have the data all ready presorted the way the data is suppose to appear on the report.
The data will look like the following:
highest level group
second highest group
third highest group (which is the lowest level group)
Now there will be detail lines that look like
detail line 1
detail line 2.
Thus can you tell me and/or point me to a reference that will tell me how to generate a report like this in report builder 3.0?
That sounds like the standard grouping available in SSRS, but didn't quite follow what you meant when you said that the output of the data will be already presorted. In any case, see if the information in the MSDN page below helps you. A link in that page has step by step instructions as well.
if you're getting data pregrouped then its a matter of applying row level filters to show only corresponding level data at each level. You've also set visbility property of rows to be toggle based on another report item and link it to corresponding row if you want to get the expand/collapse functionality.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
report builder groupings
Posted - 05/10/2012 : 18:18:35
