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 |
|
aka_ankur
Starting Member
5 Posts |
 Posted - 2011-12-02 : 13:54:48
|
| I have a query in my matrix report like this.SELECT T1.A1,T1.A2,T1.A3,T1.A4,T1.A5,T1.A6,T1.A7,T1.A8,T1.A9,T2.B1,T2.B2 FROM T1 INNER JOIN T2 ON T1.A9 = T2.B3 LEFT OUTER JOIN T3 ON T1.A10 =T3.C1DI have row groups on A2,A3,A4,A5 and column group on A6.Now I have added new column A1 and I have to make drill down on this A1(country name) and after trying every technique it's not coming.It should look like this : +USA +Russia +France +Japan and some one select like 'france' then: +USA +Russia -France A2 A3 A4 A5 A6 A7 A8 A9 B1 B2 .. ... ... +JapanCan some one help in my case.Thanks |
|
|
k_nataraj
Starting Member
7 Posts |
|
|
elmozamil
Starting Member
4 Posts |
Posted - 2011-12-22 : 03:44:21
|
| after you add the column on your select statement.drag and drop the filed from field list on reporting service and put it on top of group row, make sure it is the first one on the group.then do the usual work on properties to hide and show based on it.I hope it is helpful, if not please post a detail description of what you tried and fail. I did this tasks many times and always success.[url]elmozamil.blogstot.com[/url]There is no thing is impossible if you try harder! |
 |
|
|
elmozamil
Starting Member
4 Posts |
Posted - 2011-12-22 : 08:01:07
|
| after you add the column on your select statement.drag and drop the filed from field list on reporting service and put it on top of group row, make sure it is the first one on the group.then do the usual work on properties to hide and show based on it.I hope it is helpful, if not please post a detail description of what you tried and fail. I did this tasks many times and always success.[url]elmozamil.blogstot.com[/url]There is no thing is impossible if you try harder! |
|
|
|
|
|
|
|
|
Toggling problem in Matrix report ssrs2008