SSRS - Control visibility of subreports

Based upon a field in the data source turn on/off a subreport
TWengerAsked:
Who is Participating?
 
aelliso3Connect With a Mentor Commented:

In Subreport Properites -- > Visibility and select  Show or hide based on expression. Make the expression something like    

=Iif(Fields!Column1.Value = "123", True, False)
0
 
TWengerAuthor Commented:
I have tried this and what ever I put in as 123 it does not recognize - always comes back false.... any other suggestions.
0
 
aelliso3Commented:
What's the data type of the field that you are using?
0
 
TWengerAuthor Commented:
Tried textbox, Y/N, number
0
 
aelliso3Commented:
can you try this one:
=Iif(FIRST(Fields!Column1.Value) = "123", True, False)
If that doesn't do it, is there only one row returned from this datasource?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.