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 03, 2013 8:31 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 06, 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 03, 2013 10:07 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 2,842, Visits: 2,423
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 04, 2013 7:46 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 2,842, Visits: 2,423
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