Using SSRS 2005 I have a detail report that takes three parameters.
Two are date parameters and are not a problem.
I use the third parameter as a lookup for a staff ID.
I have it setup as a multi-value, allowing blanks and pulls from a data set.
This basically works, however sometimes this field is left blank in the database set as NULL.
To also capture the NULL records I have the following in the WHERE clause of the dataset query:
AND (staff.staff_id IN (@staffid) OR staff.staff_id IS NULL)
The trouble with this is that if someone selects a sub set of the staff IDs the records with staff ID = NULL always gets reported too.
I would like to change this so that if you select a specific staff ID only
View Complete Post