locked
SSRS CASCADING PARAMETER RRS feed

  • Question

  • I have two parameters @Branch & @Teller.

    What I would like to do is; whatever @Branch parameter is selected, I would like my @Teller parameter to be populated based on @Branch parameter.

    For @Branch parameter, I have set the Report Parameter Properties as

                    General

                                    Name: Branch

                                    Prompt: Branch

                                    Data Type: Text

                                    Allow Multiple Values

                                    Visible

                    Available Values

                                    Get values from a query

                                    Dataset: Branch

                                    Value Field: BranchID

                                    Label Field: Branch

                    Default Values

                                    Get values from a query

                                    Dataset: Branch

                                    Value Field: BranchID

     

    For @Teller parameter, I have set the Report Parameter Properties as

                    General

                                    Name: Teller

                                    Prompt: Teller

                                    Data Type: Text

                                    Allow Multiple Values

                                    Visible

                    Available Values

                                    Get values from a query

                                    Dataset: Teller

                                    Value Field: TellerNumber

                                    Label Field: LastName

                    Default Values

                                    Get values from a query

                                    Dataset: Teller

                                    Value Field: TellerNumber

     

    In my Teller dataset, my query looks like the following:

     

                    SELECT

                    [Name]

                    ,LastName

                    ,[TellerNumber]

                                     FROM [ARCUSYM000].[cu].[ActiveDirectoryUsers] u

                                      WHERE Terminated = 0

                                                    AND Department IN (@Branch)                                                           

                                    ORDER BY u.LastName

     

    What is happening now when I run the SSRS Report from Report Builder,

    Branch parameter is populated with all branches selected which is what I expected.

    My Teller parameter is NOT populated with any values.

    Any help is appreciated.

    Thank you

    Friday, March 2, 2018 5:36 PM

Answers

All replies