CODEWITHSUNDEEP
sql-serverreporting-services
Harvdawg
Harvdawg

Reputation: 75

Creating a Parameter in SSRS

SELECT
Field1, Field2, Field3
FROM
sometable

Hi, I need help in creating a parameter in SSRS.

When False it should only display where Field3 IS NOT NULL and When True it should display all records

Thanks!

Upvotes: 0

Views: 53

Answers (1)

Daniel W
Daniel W

Reputation: 1142

You can change your query to something like this: 

SELECT Field1, Field2, Field3 
FROM sometable 
WHERE (@param = TRUE) OR (Field3 IS NOT NULL)

Upvotes: 2

Related Questions