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 |
|
Serge
Starting Member
44 Posts |
 Posted - 2008-01-29 : 04:14:00
|
| Can someone please clarify this for me.If you have a table in a report that has data groupings on more than one value, i.e. Grouping by Company, Department, Manager etc. the groups are dependant upon each other, so by removing a parent group report will remove all subs dependant upon it?So the question is this. I wonder if there is a way of "union" two groups in such way in a table so that if you have:CompanyA...DepartmentA(OfCompnayA)...DepartmentB(OfCompanyA)CompanyB...DepartmentA(OfCompnayB)...DepartmentB(OfCompanyB)one can "union" it to be displayed as such:CompanyA...DepartmentA(OfCompnayA)...DepartmentB(OfCompanyA)...DepartmentA(OfCompnayB)...DepartmentB(OfCompanyB)Because currently if I try and hide row CompanyB it hides all subs under it. i.e. DepartmentA(OfCompnayB) and DepartmentB(OfCompnayB).Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-29 : 13:01:06
|
| You might have bring the hierarchial data as various levels from db and apply various level filters on report detail rows. |
 |
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-01-30 : 06:38:26
|
| Yeah, that sounds like what I had in mind... I was just unsure if SSRS was capable of such thing. Mostly I found its much easier to get DB doing all of the logic and SSRS just plain and blunt representation of raw data in a not too clever way... I guess its merely because of the product being fairly new. |
|
|
|
|
|
|
Table grouping parentness