Solved

Multiple Values for using fill in text properties

Posted on 2016-09-03
4
44 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 500 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

724 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