-
Toggling problem in Matrix report ssrs 2008
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.C1D
I 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 when user select multiple countries at a time:
+USA
+Russia
+France
+Japan
and some one select like 'france' then:
+USA
+Russia
-France
A2 A3 A4 A5 A6 A7 A8 A9 B1 B2
.. ... ...
+Japan
Can some one help in my case.
Thanks
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|