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.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…