Hi Vivek Signh,
Per my understanding that you have several parameters in the report and have add filter to filter the data, you don't want to select the value from the drop down list of the parameter to filter the data, right?
By default, if you have specify the value of the "Available values" you will get drop down list for you to choose value to dynamic filter the report. If you don't specify the "Available values" and only specify the "Default Values", the report will filter using the default value and you will need to input the value in the parameter to change the filter.
In your scenario, you have several parameters and you if you want to keep the filter working, I suggest you to continue to display the list of "availaible values" and if you don't want to display these drop down lists and also don't want to input value in the parameter, you will not need to create parameter, you can add filter in the query like below to get the filtered data of the report:
select * from tablename where col1='value1' and col2='value2' and col3='value3'
If I have some misunderstanding, please try to provide more details information.
Regards,
Vicky Liu
Vicky Liu
TechNet Community Support
No comments:
Post a Comment