Solved

Multiple Values for using fill in text properties

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 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

22 Experts available now in Live!

Get 1:1 Help Now