You can select default values within the "Report Parameter Properties" - Default values. Choose from either "Specify Values" by selecting from your sub-datasets, or "Get values from query".

Hi Amit, If the default value of the parameter is always applied, we can make it hard-coded in the filter. For example, if we have a multi-value parameter P1 with available values specified, and its default value is specified to 2. The dataset of the report contains a data field Field1. Generally, in order to filter the dataset by the parameter P1, we can add a filter in the Dataset Properties with the settings below: Expression: =Fields!Field1.Value Operator: In Value: =Parameters!P1.Value Now, in order to ensure the default value 2 is always applied, we need to change the filter settings to: Expression: =(InStr(Join(Parameters!P1.Value,"-"),Fields!Field1.Value)>0 OR (Fields!Field1.Value=2)) Data Type: Boolean Operator: = Value: =True After that, the default value will always pass to the filter whether user check/unchecked the "Select All". Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

HI techherit, In that case when user Unchecked the "Select All" option, this value is not intact with the filter, i want whether user check/unchecked the "Select All", this default value must have pass to the filter. AMit

Create a hidden parameter and assign the default value to it. Then pass this hidden value to your query. Other option is if you are reporting from store procedure then you can create a parameter with default value. Thanks, Manish

Hi, I have created one parameter, making it having multi value option. Now i want to assign a default a value to the parameter , which does not depend whether i have check or uncheck "Select All"option in the filter. For e.g . if i check SELECT ALL in filter, this default value will pass for sure. but when i unchecked the "Select ALL" option, in tha case too , i want that default value will pass. Amit