January 23, 2009 at 11:01 am
hello i am new to reporting svcs. i ahve a situation where i have to color a row which has 2 column duplicate values in it
ex. there are 2 columns with endusername and description. if description and endusername are repeating then color with yellow else no color
there can be multiple column but i want to color only when these two columns repeat.
thanks for ur help in advance
January 23, 2009 at 11:06 am
This may help you figure out how to do this. it is very easy
http://www.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/
January 23, 2009 at 11:10 am
i meant something like =IIF(fields!endusername=previous(fields!endusername) and fields!description like "*compliance*" =previous(fields!description like "*compliance*" ),"yellow","")
i tried but this is not working out
January 23, 2009 at 1:31 pm
Okay,
No you cannot compare rows for conditional formatting Only columns.
I have not found a way to do this, and I really have not needed to.
January 23, 2009 at 2:46 pm
You can determine the color of the row in the query, and return it as a field in the dataset. Then set the color property of the cell/row to the field that represents the color.
January 27, 2009 at 1:23 am
Hi..:)
I guess, you can try this...
=IIf(Fields!F1.Value = previous(Fields!F1.Value),"Yellow","Gainsboro")
in one column and different field name with same condition in different column...this is so..b'coz its your requirement that only 2 columns needs to be validated and affected..
So...you can give it a try and let me knw..if it helps!!
Thanks,
Niraj
January 27, 2009 at 5:49 am
that only effects the color of the column and not the row
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply