You can set the parameter properties to 'Allow NULL' and also handle it accordingly on the query side. For example:
Where (customer = @Customer or @Customer is NULL)
OR
Where (customer IN (@Customer) or @Customer is NULL)
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI