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.
| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-08-13 : 04:22:38
|
| Hello!I need to define background colour for every second line of my report. For a table report I used the followingiif(RowNumber(Nothing) MOD 2, "White","LightSteelBlue")In my matrix report it doesn't work - I receive an error for detail column' and if I define condition only for the "rows" column - row count is incorrect.Maybe you have any other idea how to define any prorerty for every second line in matrix report? |
|
|
melon.melon
Yak Posting Veteran
76 Posts |
Posted - 2009-08-27 : 23:47:03
|
| Second row will repeat in color:=IIF("white", IIF(RowNumber("DataSource1") Mod 2 = 1, "PaleTurquoise", IIF(RowNumber("DataSource1") Mod 2 = 2,)) |
 |
|
|
melon.melon
Yak Posting Veteran
76 Posts |
Posted - 2009-08-27 : 23:51:57
|
| shld be this?=IIf(RowNumber(Nothing) Mod 2 = 0, "White", "LightSteelBlue") |
|
|
|
|
|
|
Condition for lines in matrix report