ssrs expression - 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

General SQL Server Forums

New to SQL Server Programming

ssrs expression

Author

Topic

Anand.A
Posting Yak Master

109 Posts

Posted - 2011-12-24 : 01:12:14

hi

i want to create a report in ssrs
i am having table like this
column A column B
smith 100
smith 200
smith 300
smith 400

i want to give a different color for each row in column A
if smith&value 100 i want to give green
if smith&value 200 i want to give red
if smith&value 300 i want to give yellow
if smith&value 400 i want to give black

i dont knw how to write expression for this

i wrote

=iif(column A.value="smite"& column b.value=100,"green",
iif(column A.value="smite"& column b.value=200,"red",
iif(column A.value="smite"& column b.value=300,"yellow",
iif(column A.value="smite"& column b.value=400,"black","white"))))
but i m getting error
so how to write and expression in ssrs background color window

anand

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-24 : 01:20:08

instead of & use And

=iif(Fields!A.value="smite" And Fields!b.value=100,"green",
iif(Fields!A.value="smite" And Fields!b.value=200,"red",
iif(Fields!A.value="smite" And Fields!b.value=300,"yellow",
iif(Fields!A.value="smite" And Fields!b.value=400,"black","white"))))

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Anand.A
Posting Yak Master

109 Posts

Posted - 2011-12-24 : 01:24:41

ya thanks for ur reply

quote:
Originally posted by visakh16

instead of & use And

=iif(Fields!A.value="smite" And Fields!b.value=100,"green",
iif(Fields!A.value="smite" And Fields!b.value=200,"red",
iif(Fields!A.value="smite" And Fields!b.value=300,"yellow",
iif(Fields!A.value="smite" And Fields!b.value=400,"black","white"))))

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

anand

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-24 : 02:50:28

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources