Monday, December 28, 2009

Post-modern greenbar.



How do I display a "greenbar" effect in my SQL Reports?


As popular as this "feature" is, and for as often as business users ask to have it included in their reports you would think Microsoft might actually include as a feature in SSRS; but they don't. 


To add this to tables in your reports add the following code to the Background Color property of the appropriate TableRow:


= iif (rownumber(nothing) mod 2 = 0, "Azure", "Transparent")


Obviously, feel free to substitute whatever values you prefer. 

No comments:

Post a Comment

Please give me your feedback. Questions, comments, suggestions are all welcome; please be sure to keep all comments professional and courteous.