?
Solved

Multiple Values for using fill in text properties

Posted on 2016-09-03
4
Medium Priority
?
53 Views
Last Modified: 2016-09-04
I am trying to add multiple values for highlighting the cell. Trying to use "IN" and i don't think the syntax for the expression is correct...

Trying to add both values that are bold: (it works with one value, shown below this expression)

= iif ((Fields!ACFD_Level_of_Service.Value in ('Cancelled – PTA or At Scene - No Pt Contact', 'Technical Assistance Provided – No Pt Care') and ((Fields!PPlus_Arrival_Min.Value > 3.00)), "Yellow", "No Color")

This expression works with just one value:

= iif ((Fields!ACFD_Level_of_Service.Value = "Cancelled – PTA or At Scene - No Pt Contact") and ((Fields!PPlus_Arrival_Min.Value > 3.00)), "Yellow", "No Color")
0
Comment
Question by:srodgers45
[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
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 2000 total points
ID: 41783835
Hi! You've me again!
Firstly, your code, as posted, has mis-matched parentheses:
= iif                (
(Fields!ACFD_Level_of_Service.Value in (  'Cancelled – PTA or At Scene - No Pt Contact', 
						'Technical Assistance Provided – No Pt Care'	) 
and 
(
	(Fields!PPlus_Arrival_Min.Value > 3.00)
), 
"Yellow", 
"No Color"
			)

Open in new window


The attached shows my previous example and a second one, where the idea is to colour the employee id if the minutes value is less than 100 AND the break value is two.
= iif(
(     (fields!Minutes.value <= 100) AND (fields!BreakFlag.Value = 2)     ), 
"Red", 
"No Color")

Open in new window


Is this the thing you're looking for?

Mike
Screenshot-from-2016-09-04-14-00-34.png
0
 

Author Comment

by:srodgers45
ID: 41783861
I'm sorry, is the solution you posted an edited version of what I posted? It throws an error when I try to run it. I just need to add the second value of "Technical Assistance Provided – No Pt Care" in addition to "Cancelled – PTA or At Scene - No Pt Contact". Apparently I do not have the correct syntax for the expression. I did some research and there are apparently several ways to do this, split? i cannot seem to get it right.

This is what I tried and got an error message:

= iif ((Fields!ACFD_Level_of_Service.Value in ('Cancelled – PTA or At Scene - No Pt Contact', 'Technical Assistance Provided – No Pt Care') and ((Fields!PPlus_Arrival_Min.Value > 3.00)), "Yellow", "No Color")

Thanks for help!
0
 

Author Closing Comment

by:srodgers45
ID: 41783901
I was able to get it to work with using this. Thanks for your time.

= iif ((Fields!ACFD_Level_of_Service.Value = "Cancelled – PTA or At Scene - No Pt Contact" or Fields!ACFD_Level_of_Service.Value = "Technical Assistance Provided – No Pt Care" ) and ((Fields!PPlus_Arrival_Min.Value > 3.00)), "Yellow", "No Color")
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 41783904
Oh Good!! I think it ended up as just being that you had too many opening-parentheses and not enough closing ones!

Mike
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 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