Could you give an example?
Do you mean to populate the filter options with the contents of a different field in the datasource? This could be accomplished with a calculated field...
if [Category] = 'Technology' then [Order Priority]
else [Ship Mode]
Thanks for your response and the question.
there are the below filters in the report
1. Year (e.g. values All, 2010, 2011, 2012 etc...)
2. Months (e.g. All, Jan, Feb, Mar... Dec)
3. Week (e.g. All, wk1, wk2.....wk53)
Now i choose the below values for the filter;
Year = All
then my Month filter should be defaulted to "All" It should not allow me to choose any months.
And in you response is [Category] a filter?
And when i was exploring this hit against another question. I have a parameter in my report and has the following values
Year, Month, Week, Day .
Can i change this list dynamically based on value selected in one of my quick filters in the report?