Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2011
    Posts
    3

    Unanswered: Toggling problem in Matrix report ssrs2008

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    I don't understand what your problem is.

    I have row groups on A2,A3,A4,A5 and column group on A6.
    ???

    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.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Dec 2011
    Posts
    3

    Toggling problem in Matrix report ssrs2008

    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.

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    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.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  5. #5
    Join Date
    Dec 2011
    Posts
    3

    Toggling problem in Matrix report ssrs2008

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

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
  •