parameter on change event RRS feed

  • Question

  • Hi all,


    I have multi-values parameter I need when user change value remove value from another parameter


    Thanks In advance

    Monday, June 9, 2008 1:03 PM


All replies

  • Hi Hossam;


    It would be valueable if you could just describe that parameter issue more.


    1- Do you want another parameter to be triggered by another?

    2- Do you want dynamically fill second parameter?

    3- Does you parametres are from datasets( sql queried) or manual?




    Onur Omer


    Monday, June 9, 2008 5:19 PM
  • i want my parameter  dynamically fill second parameter

    Tuesday, June 10, 2008 10:50 AM
  • You could write a Stored Procedure. You can then pass in a parameter and set your variables dependent on the value passed in. Then select and return your data based on the variables.




    Tuesday, June 10, 2008 1:43 PM
  • Hai


    What i understood from your explanation is u have two parameters which are multi-valued.


    Your second parameter values are dependent on the First parameter value. Is it correct?


    Select Column1

    From TableName

    Where Column2 IN (@Parameter1)

    Friday, June 13, 2008 7:19 AM
  • Hi Hossam;


    Assume that you have two parameters.


    One is City and other is District.


    And you are looking for a "sales by District" report. And you want the reportuser to select District to view Sales.


    You should have 3 datasets:

    1-Main Query (Sales data)

    2-City List

    3-District List



    Main Query: Assume that you have this SQL statement as Main Dataset:


    Code Snippet

    Select Sum(QTY), Sum(Amount),Salesperson from SalesTable

    Where District=@ParDistricts

    Group by SalesPerson



    And you have unclaimed City-District Hierarchy in your Relational DB (RDB)


    For instance, you have two report parameters.

    1. ParCity (Use Add Button in left down corner in Report Parameters window)

    2. ParDistricts (Dont add this is grabbed from Main dataset automatically)


    District List: You grab the District Data as of this Query-Dataset:

    Code Snippet

    Select DistrictName From LocationTable

    Where City=@ParCity





    City List: And lately the Query-Dataset for @ParCity is:

    Code Snippet

    Select Distinct CityName From CityTable

    Where CountryCode=90





    Well in Report Parameters Window, do this setup:


    1- @ParCity:

    Available Values Section, Select "From Query", In Datasets List, select "City List Dataset" and For Value Field Select CityName.


    2- @District:

    Same Above but now select "District List Dataset" and for Value Field select DistrictName




    When you run the report, District Parameters are filled under the code of City selected in City Filter.


    So by this you will be able to change the the second multivalued parameter based on the values of first parameter dynamically.


    Is this post helpful?



    Onur Omer Ozturk




    Friday, June 13, 2008 9:11 PM
  • What these guys are talking about is cascading parameters.  Here is the tutorial right from Microsofts tutorial website:




    Wednesday, June 18, 2008 4:50 PM