I have a parametered filter in my sql query: Warehouse_Class_Code like '%' + @Filter + '%'
In the parameter I have several value to set the right filter. When I run the report I always have to select one of the values. I added a label "All records" with a value "&". I tried "%" as a default value at the parameter settings.
In the preview the label "All records" is shown, but when I run the report in the HTML browser, I see <Select a value>. How to change the default value to "All records"
Default value for "All records" in a parametered filter
Kyle Leitch
NickNotYet
if you do not need to select one, you can make it non-mandatory and use a query like the following one:
@ParameterName IS NULL OR
Warehouse_Class_Code like '%' + @Filter + '%'
HTH, Jens K. Suessmeyer.
---
http://www.sqlserver2005.de
---