Reporting

Many production level reports use an alternating row style as an aid to readability. This technique is used in the ProductCatalog sample report.

This look can be achieved with conditional formatting by setting up a rule that fires on every other line.

  1. Select the detail section of your report.
  2. Select the ConditionalFormatting property of the detail section.
  3. Click the New Rule button.
  4. Enter the expression "= RowNumber()%2"
  5. Select the equal "=" operator from the drop down list.
  6. Enter the value as "=1".
  7. Click the Style button.
  8. Click the Background style item.
  9. Enter the color as "#F0F0F0".
  10. Click OK to close each of the open dialogs.