mkbhagat4u (8/21/2014)
Yes,Its not possible.
I have one more question.
I have report which is parameterized..
Can I provide 2 level filter in report.
1st level- When I pass parameter then click on view button then result shown on report ., After that
2nd level-
I want to make a drop down list from the report view table result set .
I want to column name as value of drop down list .
After that I want to filter result set on selected value filed + operator
like,=,>, + text box value.
expression like --
ddl value + operator = 100;
salary(ddl value) >= 2000(text box value) .
pls suggest.
The short answer is no, there isn't dynamic filtering in SSRS. Any parameters for a report are applied when the report is run. Any changes made to parameter selections require the report to be re-run to be applied.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question