Home Forums Reporting Services Reporting Services SSRS enable Report Parameter only when another Report Parameter is selected RE: SSRS enable Report Parameter only when another Report Parameter is selected

  • you have to use a data source for the second parameter that is configured to use a value from the first parameter

    the second parameter should load/populate automatically that is you should set the parameter to have a default value from this dataset and available values also from this dataset.

    on this dataset you should populate all possible values for the years i.e. 2011, 2012, 2013, 2014

    also for the quarters if needed i.e. Qtr1 2013, Qtr2 2013, e.t.c

    also for all months i.e. Jan 2013 , Feb 2013 , Jan 2014 e.t.c, all these values to be on the same dataset and also add a column on this dataset that has corresponding values to the selections,

    i.e. the column name can be FilterBy such that

    FilterBy | selection | StartDate | e.t.c columns

    Year | 2011 | 2011-01-01 | e.t.c

    Year | 2012 | 2012-01-01 | e.t.c

    Year | 2013 | 2013-01-01 | e.t.c

    Year | e.t.c | e.t.c | e.t.c

    Month | January 2013 | 2013-01-01 | e.t.c

    Month | February 2013 | 2013-02-01 | e.t.c

    Month | March 2013 | 2013-03-01 | e.t.c

    Month | e.t.c | e.t.c | e.t.c

    Month | e.t.c | e.t.c | e.t.c

    Month | e.t.c | e.t.c | e.t.c

    the first parameter should have just year, month e.t.c

    then apply a filter on dataset such that wehn month is selected on first parameter then available values on second parameter should be months.

    ...hope this helps.......