I have an SSRS 2005 report with 2 parameters. The first is an internal parameter that uses the windows user id as input to a stored procedure that provides back a list of users/employees. The second parameter uses the list of users/employees as valid values but also has a default value equal to the current user's windows user id. When the report runs, it does not automatically run with the default value. The user must choose from the parameter list, even if their userid is the only one in the list. Why does it not run with the default value? How can I force it to use the default value when it runs? Janice Juszczec

Make sure the values don't have any leading or trailing blanks. XXX <> XXX<space>

Hi, Can you check the Default Value is Equal to the Drop Down Value and not the Label Field.Because it compare with Drop Down value field and Not label field. Regards, PS Regards, PS

Hi, Can you check the Default Value is Equal to the Drop Down Value and not the Label Field.Because it compare with Drop Down value field and Not label field. Regards, PS Regards, PS

Thank you for your responses. Both were helpful in resolving the problem, but neither was quite exactly the resolution. I do believe the length of the list-of-values values compared to the default value may have been different. The value field in list-of-values query was defined as varchar(6), my default value was 2-4 characters (user login id). I do think this was part of the problem. Another problem was with how my dataset was defined - the parameter for the dataset was not set to be the value from the list-of-values - it was set the same as the default (user login id). To make this work for me I: 1) Changed the dataset parameter to be the value from the list of values 2) Changed the default to come from the list of values query 3) Set up my list of values query to return the employee code for the user running the report. A small list users get a long list of employee codes. In either case, the report runs automatically for the first employee code in the list which I forced (in the list-of-values query) to be the user running the report. Thanks. Janice Juszczec