Solved

Multiple Values for using fill in text properties

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
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…

820 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