Post reply

Extend a column based on Selection in Parameter Prompts

  • November 5, 2013 at 2:44 pm

    #300016

    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

  • November 6, 2013 at 5:17 am

    #1664409

    yes... take a look at:

    http://msdn.microsoft.com/en-us/library/dd255197.aspx

  • November 7, 2013 at 3:11 am

    #1664687

    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.

  • November 8, 2013 at 1:52 am

    #1665018

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply