This examples uses the Microsoft SQL Server 2008 example database AdventureWorks (http://msftdbprodsamples.codeplex.com/) If you want to return all rows of a table when a parameter is null, use the TSQL function isnull: declare @productModelID as
Exception: Error 1 [rsInvalidReportParameterDependency] The report parameter ‘productModelID’ has a DefaultValue or a ValidValue that depends on the report parameter “productModelID”. Forward dependencies are not valid. C:\Projects\Temp\Report Project1\Report Project1\Products.rdl 0 0 This error occurs, because
To allow nullable parameters on a Microsoft Reporting Services report, add an extra row for all product models: — Dataset 2 select null as ‘ProductModelID’,‘[All models]’ as ‘Name’ union select pm.ProductModelID, pm.Name from