4 June, 2009
0 Comments
0 categories
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
Production.ProductModel pm
order by Name
Solution found at: http://www.discombobulator.net/index.asp?article=9
Tags: Reporting Services