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

Extend a column based on Selection in Parameter Prompts Expand / Collapse
Author
Message
Posted Tuesday, November 5, 2013 2:44 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
I have a parameter prompt with hierarchy (Category, sub category, product)

If I select for instance "Locks" in the prompt, the matrix table should be enable to extract and display the list of Category and sub catebory.

If I select for instance "7456 Pumps" (name of a produkt from the sub catebory Pumps), the matrix table should be be enable to extract and display the list of Category, sub catebory and product.

The quesion is:

Is it possible to do it in SSRS?

Information:
I'm using SSAS as a data source


  Post Attachments 
picture1.png (8 views, 8.61 KB)
picture2.png (5 views, 24.70 KB)
Post #1511646
Posted Wednesday, November 6, 2013 5:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:27 AM
Points: 243, Visits: 2,738
yes... take a look at:
http://msdn.microsoft.com/en-us/library/dd255197.aspx
Post #1511817
Posted Thursday, November 7, 2013 3:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
Thank you for your help!

The info you have provided do not explain based on my requested result. It gives a part of it but not the main part.
Post #1512169
Posted Friday, November 8, 2013 1:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 7:34 AM
Points: 44, Visits: 211
You can try to write conditinal group expression for matrix Row Groups that depends on the selected value of the Parameters. You need three level Row Group: when one of these level is unnecessary the group expression is 1=1 and you set Visibility To Hidden.
You need to parametrize Drill-down function too
Post #1512562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse