Solved

SSRS - Control visibility of subreports

Posted on 2010-09-15
5
652 Views
Last Modified: 2012-05-10
Based upon a field in the data source turn on/off a subreport
0
Comment
Question by:TWenger
  • 3
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
aelliso3 earned 500 total points
ID: 33684587

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
 

Author Comment

by:TWenger
ID: 33754506
I have tried this and what ever I put in as 123 it does not recognize - always comes back false.... any other suggestions.
0
 
LVL 11

Expert Comment

by:aelliso3
ID: 33754601
What's the data type of the field that you are using?
0
 

Author Comment

by:TWenger
ID: 33756392
Tried textbox, Y/N, number
0
 
LVL 11

Expert Comment

by:aelliso3
ID: 33756498
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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS 2008 using rectangles with text boxes 6 79
Highlight a field based on value in another field in SSRS 4 46
SSRS Enable Remote Errors 4 34
SSRS Deployment problem 5 66
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question