Post reply

color duplicate rows with multiplt columns

  • January 23, 2009 at 11:01 am

    #205726

    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

    #931962

    This may help you figure out how to do this. it is very easy

    http://qa.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/

  • January 23, 2009 at 11:10 am

    #931963

    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

    #932020

    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

    #932076

    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

    #933041

    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

    #933113

    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