SQLTeam.com | Weblogs | Forums

Ignore Tablix Filter if , parameter is null in SSRS


Hi, I am creating an SSRS report . I want to apply filter to the data for Employee ID and thus created a parameter @EmployeeID which can take null and blank values.
And i have added Tablix Filter:
=IIF(ISNOTHING(Parameters!EmployeeID.Value),FALSE, Parameters!EmployeeID.Value)

But its not working. I want if the parameter value is null.. all records must be shown. Please help ASAP.


did you try this at query level?
WHERE EmployeeId = @EmployeeId
OR ISNULL(@EmployeeId, '') = ''


I want to use it at SSRS level . Can you help with that?


I think this link has your solution


For now i did it query wise only ..