Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008
    Posts
    4

    Post Unanswered: Pretty up Reports

    Hi, am trying to use the highlight expert to make a box show/not show. I have several groups. I want to highlight every other group total (detail is hidden).
    Any suggestions?
    Thanks in advance.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Yep! Create a running count (i.e. first group = 1, second group = 2, etc) then create a formula that colours each row based on the modulus 2 of the running sum.

    pseudo code:
    Code:
    If (running_sum % 2) = 0 Then
        green
    Else
        orange
    End If
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2008
    Posts
    4

    Thank you

    After posting, I played around w/GroupNumber. Didnt think of the modulus function... thank you it works wonderfully now.

    Denise

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •