James is passionate about enterprise data architecture, data modeling, data management, and governance. He is a data management expert who possesses a rare combination of deep technical acumen, coupled with broad-based business and thought-leadership experience. He’s an accomplished enterprise data architect, project manager, and technologist with Fortune 1000 experience, who combines the hard-skills and soft-skills needed to effect meaningful organizational change.
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.
Subscribe to:
Post Comments (Atom)
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.