Hi there,May be a kind of dumb question, but I have a multi-value parameter that I would like to give users the ability to select from in a SSRS 2005 Report and I was wondering if there was a way to adjust the width of the drop down so the user wouldn't have to scroll horizontally to see a full parameter item. It looks like it cuts off after about 30 characters.Any help here would be appreciated.Thanks!Rich

Try this SELECT EmpID, EmpName from Employee UNION SELECT NULL AS EmpID, 'ALL' AS EmpName ORDER BY EmpName And SET default value as NULL Your SP should have default NULL value Create Procedure Employees ( ID int NULL ) AS..