Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Page History: GreenBar in Reports - SSRS

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Tue, Aug 17, 2010, 10:43 AM


Overview

The term greenbar is taken from tractor-feed paper that was used in computer printers in the 1970s and 1980s. It had bands of green across the width of the page so that three lines of data would be on a white background, alternating with three lines on a green background. This was done to make it easier to read across long lines of data. This article demonstrates how to reproduce this effect in Reporting Services.

Walk-Through

1. Layout your data in a Table control, with group headers and footers as required. 2. For the BackgroundColor property for the cells of interest, specify the following expression.

=Iif((RowNumber("table1")-1) Mod 6 < 3, "#c0ffc0", "White")

Notes
  • If you have no groups for your table then table1 should be the name of your table control. Otherwise, it should be the name of the lowest level group.
  • The color #c0ffc0 is a light green. You can change it to suit your preferences.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.