Solved

Multiple Values for using fill in text properties

Posted on 2016-09-03
4
35 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
  • 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

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. …
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

813 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

12 Experts available now in Live!

Get 1:1 Help Now