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 |
|
Tart_SQL
Starting Member
41 Posts |
 Posted - 2008-10-08 : 18:50:54
|
| Hello,I have this report where the details are grouped by each user.Ex.Day amount task endtimeUser 11 10 1 4pm2 20 3 5pmUser 21 10 1 4pm2 20 2 5pm3 5 3 6pmI need the details rows to alternate colors so I use this expression =iif(RowNumber(Nothing) Mod 2, "Red", "White")The problem is the user row is "Red" and in some detail lines after each user group line it comes as red too while it doen't for some. Is there a way I can do this where after each user group line the next line for the details must be white? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-11 : 01:50:06
|
| you could use grouping scope to achieve this. try like below:-=iif(Inscope("UserGroup"), "Red", "White")where UserGroup represents the name of group which invlives user field (you get it from grouping properties window) |
 |
|
|
|
|
|
Alternating colors by groups