SSRS report parametrised

Question

I am creating a tabular report with several conditions. As a case in point, the conditions could be either of these:

X is NULL

X is not NULL

X like '%Y%'

I want to create a kind of drill through report with the capability of selecting one of the above conditions.

Now I am creating three tables and use IIF for the visibility of each. I add the parameter to visibility and by selecting one condition the related table becomes visible and the other two becomes hidden. But I am thinking of just a single table with a parameter for selecting desired condition.

So what is the question/problem? – Benjamin May 30 '17 at 14:12 — Benjamin, May 30 '17 at 14:12

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

As I answered in your duplicate post:

Instead of using a visibility expression, add it as a filter. This will only show rows that match the expression. You can do something like this:

Expression: ="TRUE"

Operator: =

Value: IIF(Parameters!Status.Label = "NULL", "TRUE", "FALSE")

edited Jun 20 '20 at 09:12

Community

1
1

answered May 30 '17 at 14:07

Lucky

4,443
2
8
18

SSRS report parametrised

1 Answers1