Row Formatting depending on row numbers
how to format the rows based on row numbers ex: if row number is zero it bg fill should be black ,if row number is 1 it should be white..............................
April 19th, 2011 3:25am

when am using this exp =iif(RowNumber( "ARR") Mod 2 = 1, "LightSteelBlue","#ccdcf5") am getting following error: the bg color exp for the textbox has a scope parameter that is not valid for an agg function. the scope parameter must be set to a string const that is equal to either the name of containing group,or containing region or the dataset name.............
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 3:32am

Hi, What is "Arr"? Is it a group name or dataset name? You need to write DataSetName or GroupName inide the RowNumber() For example, =IIF(RowNumber("DataSet1") mod 2 = 1,"Red", "Blue") - Chintak (My Blog)
April 19th, 2011 3:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics