You can send a null (as the default value) and have it be an indicator that you don't need to filter by that parameter. For example:select id, name
from mbv_netrt
where (id = @parameter1 OR @parameter1 IS NULL)
and (name = @parameret2 OR @parameret2 IS NULL);
Are you using an adhoc query or using a stored proc? If you are using a stored proc, there may be performance implications in this type of "catch-all" queries.
help with report parameters
Posted - 02/14/2013 : 14:48:55
