First, make sure that this is the problem. This will lists the orphaned users:
EXEC sp_change_users_login 'Report'
If you already have a login id and password for this user, fix it by doing:
EXEC sp_change_users_login 'Auto_Fix', 'user'
If you want to create a new login id and password for this user, fix it by doing:
EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'
Continue reading →
If a table value is returned as NULL then its appearance may be improved by displaying a ‘0’ instead. this is achieved by the expression:
=IIF(Sum(Fields!theCount.Value) is Nothing, “0”,
In SQL Server 2008 Reporting Services all the values from a multi-value parameter can be displayed using the JOIN function as below:
The second parameter accepted by this function being the separating character. It took me a lot of trawling through BOL to find this.