Allow NULL value in Multi Value Report Parameter in SQL Server Reporting Services Your report has a multi value parameter, but it doesn't show NULL in the parameter drop down along with the other parameter values. In SSRS a multi-value parameter cannot include a NULL value, so users can't filter the data for NULL values. Your requirements state a need to be able to filter the data for NULL values, so in this tip I will demonstrate how to allow NULL values in a multi value SSRS report parameter.
Evolution of SQL Server Self Service Business Intelligence Learn how Reporting has evolved into Business Intelligence (BI) on the SQL Server platform then determine how your current solution measures up. In this session, we will discuss the self-service BI continuum along with the associated technology options, challenges, opportunities and more. Learn the best practices from the field to overcome some common challenges for getting reporting out to the user community.