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

I don't understand what your problem is.

???

Can you give us the table structures, some sample data and the result that you want?

If I can make anything from your description, this is not a database problem but an interface/programming problem.

Country AccNam Accnum Name DoorRep Address1 City\
USA TURNER 531 Ashley Ryan 11 Capital Tallahassee
USA TURNER 531 Ashley Michael 314 S.W Mobile
USA TURNER 531 Ashely Michael K 100 Shore Blvd Fort
France TURNER 53 Ashley Ryan 11 Capital Tallahassee
France TURNER 53 Ashley Michael 314 S.W Mobile
France TURNER 53 Ashely Michael K 100 Shore Blvd Fort
Japan TURNER 54 Ashley Ryan 11 Capital Tallahassee
Japan TURNER 54 Ashley Michael 314 S.W Mobile
Japan TURNER 54 Ashely Michael K 100 Shore Blvd Fort

I want like this:

+USA
+France
+Japan

When user click on France

+USA
-France
Country AccNam Accnum Name DoorRep Address1 City\

France TURNER 53 Ashley Ryan 11 Capital Tallahassee
France TURNER 53 Ashley Michael 314 S.W Mobile
France TURNER 53 Ashely Michael K 100 Shore Blvd Fort

+Japan


I hope now you can underatnd what I want.

Yes, now I can.

What you want is an opening/collapsing tree view, comparable with a directory structure. That is an interface problem. Sorry, can't help you with that.

Is there no way to solve this issue. there should be some alternative. If you know please let me know.