Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to show details from matrix cell like excel pivot? Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 8:31 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 6, 2014 3:45 PM
Points: 52, Visits: 199
I have excel pivot table where i can click on pivot cell and it opens another sheet containing detail data. Can i do same thing with matrix or tablix control? I would appreciate if someone can guide me.
Post #1501398
Posted Thursday, October 3, 2013 10:07 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 3,024, Visits: 2,628
The way to do this in reporting services is...
- create a report that has the details
- in the matrix, add an action to the cell that you want to drill down on (in BIDS, right click on the text box, select textbox properties and then go to "Actions"). In the action, Select "go to report" and then fill in the relevant details



Post #1501410
Posted Friday, October 4, 2013 7:46 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 6, 2014 3:45 PM
Points: 52, Visits: 199
Will this be in sub report?
Post #1501601
Posted Thursday, October 10, 2013 4:23 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:49 PM
Points: 3,024, Visits: 2,628
You could consider the detail report to be a sub report. In reality, it is simply another report that will be displayed when you click on the cell in your matrix report (similar to clicking on a link on a web page - the browser will take you to the web page in that link)


Post #1503452
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse