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 |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2008-09-22 : 10:49:39
|
| I want to add alternate row shading to make it easier to the user to read, but the syntax I tried below doesn't return any shading. Let me just say that I googled this and it was the syntax it said to use.=iif(RowNumber(Nothing) Mod 2, "Sliver", "White")Does anyone know how to make it work?thx,John |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 10:57:32
|
quote:
Originally posted by latingntlman
I want to add alternate row shading to make it easier to the user to read, but the syntax I tried below doesn't return any shading. Let me just say that I googled this and it was the syntax it said to use.=iif(RowNumber(Nothing) Mod 2, "Sliver", "White")Does anyone know how to make it work?thx,John
do you have these colors available in reporting services? check color property's available values. |
 |
|
|
dreamspc
Starting Member
1 Post |
Posted - 2008-09-22 : 11:39:36
|
Try this=iif(RowNumber(Nothing) mod 2=1,"Gainsboro","Transparent") quote:
Originally posted by latingntlman
I want to add alternate row shading to make it easier to the user to read, but the syntax I tried below doesn't return any shading. Let me just say that I googled this and it was the syntax it said to use.=iif(RowNumber(Nothing) Mod 2, "Sliver", "White")Does anyone know how to make it work?thx,John
|
|
|
|
latingntlman
Yak Posting Veteran
96 Posts |
Posted - 2008-09-22 : 16:22:13
|
| It was actually a typo. Thanks, |
|
|
|
|
|
|
|
|
Alternate Row Shading