Ignore Tablix Filter if , parameter is null in SSRS

1

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.

2

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

3

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

4

I think this link has your solution

5

For now i did it query wise only ..

1 Like