Extend the matrix list based on Prompt's selection


  • Goal:
    Display and extend the sub column state of australia and canada in the matrix list when pressing one of the state in the prompt.

    How should I do it?

    *Using SQL server 2012
    *Adventureworks DW 2012

    Sunday, November 10, 2013 10:05 PM


  • Hi Sakura,

    If I understand correctly, you want to display and extend the state of countries when you select a state value from the Geography parameter. If I have misunderstood, please don't hesitate to let me know.

    In this scenario, we can try to add a filter in the State_Province group to filter the specified state which is selected from the drop-down list. For more details, please refer to the following steps:

    1. Click the cell which contains the [Country] field, set the InitialToggleState property to True in the Properties window.
    2. Right-click the State_Province group to open the Group Properties, select Show “when the report is initially run”.
    3. Click the Filters in the left pane, then Add a filter as follows:
      Expression: [State_Province]
      Operator: In
      Value: [@ Geography]

    If there are any misunderstanding, please elaborate the issue for further investigation.

    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Tuesday, November 12, 2013 9:13 AM