I have a report that displays sales orders data. They need me to add some parameter options to filter the report on. There's a total of 5 filter options: Order Date (date range) Order # Product # Product Category Product SubCategory I can successfully create these 5 filtering options on my report, however my problem is I need to only allow the user to sort by one of the following criteria: Filter by Order Date Filter by Order # (Order date not allowed) Filter by Product # (Order date optional) Filter by Product Category AND product sub-category (order date optional) Is there a way I can setup my filters to enable and disable other filtering options depending on which filters the user originally chooses? Thanks.

Hi Goalie35, Could you please answer this question: how to determin which filters are the original filters that the users had selected? As we know, if the parameter has multiple available value, you must choose one value from the drop-down list, so if you want to check if it is the original parameter, you should set the paramter has no default value or avaiable values. In this condition, you can use if condition in the filter expression. For the filters, just like this: Expression: =Fields!FieldName.Value Value: =Iif(Parameters!p2.Value="" or isnothing(Parameters!p2.Value),Fields!FieldName.Value, Parameters!p2.Value) Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.