Solved

Setting conditional visibility in a SQL reports table row

Posted on 2007-12-06
1
414 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 25

Accepted Solution

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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

730 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