Custom Code with AND - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Custom Code with AND

Author

Topic

sz1
Aged Yak Warrior

555 Posts

Posted - 2013-04-23 : 03:51:51

IS it possible to add the AND clause to a piece of custom code in the Font colour expression, so

=Code.fnGetConditionalColor(Fields!Agreed_Solved_Date___Time.Value AND(Fields!Within_Flag = "1")

Thanks

SZ1
Learning and development is the driving force in the universe...!

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-04-23 : 08:34:29

You can - probably this?

=Code.fnGetConditionalColor(Fields!Agreed_Solved_Date___Time.Value)  AND(Fields!Within_Flag = "1"

sz1
Aged Yak Warrior

555 Posts

Posted - 2013-04-23 : 09:43:22

Yeah thats coming back as black only? here is the function that works the colour out, I added this to all the font expressions. Wonder if I can add the AND(Fields!Within_Flag = "1" statements to each of the color parts here?

Public Function fnGetConditionalColor(pDate as datetime) AS String

Dim d AS integer
Dim c as string
d= DateDiff("d", pDate.Date, Now.Date)
IF d<0 and (Fields!Within_Flag = "0"
THEN
c="Green"
ELSE IF d =0 and d <=1 and (Fields!Within_Flag = "1" THEN
c="Red"
ELSE
c="Blue"
END IF

Return c

End Function

SZ1
Learning and development is the driving force in the universe...!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources