Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-05-10 : 18:18:35
|
| 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? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-05-10 : 19:31:39
|
| 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.http://technet.microsoft.com/en-us/library/dd255263(v=sql.105).aspx |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-10 : 20:09:00
|
| 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2012-05-11 : 09:27:01
|
| Thank you very much! |
|
|
|
|
|
|
report builder groupings