Solved

Setting conditional visibility in a SQL reports table row

Posted on 2007-12-06
1
378 Views
Last Modified: 2012-08-13
Hello~

I have a row in a sql report table that I need to show visible for certain titles.  I currently have the following code in the visibility property of the row:

=iif(Fields!Title.Value = "Blood pressure", false, true)

I also need it to return false for Body fat.  Does anyone know how to do this??
0
Comment
Question by:tracimcp
1 Comment
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
Comment Utility
=iif(Fields!Title.Value = "Blood pressure", false, iif(Fields!Title.Value = "Body fat", false, true))
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now