Alpha Video Training
Results 1 to 3 of 3

Thread: conditional color on calculated field on a report

  1. #1
    Karyl Cardullo
    Guest

    Default conditional color on calculated field on a report

    How do I change the color of a calculated field on a report based on the value of the calculated field. i.e. everything >= to a certain value is bold red.

    Karyl

  2. #2
    Member
    Real Name
    RT
    Join Date
    Apr 2000
    Posts
    726

    Default RE: conditional color on calculated field on a rep

    Hello:

    Go into report design, select the appropriate field, right-click with your mouse, and select Properties.

    Then ............

    Click on the Setup Tab
    Go to Color and Font Equations
    For now we'll deal only with color so ......
    Place a check mark in the Color Equation Box
    Click on the xy button on the right side of the box
    Then choose a Text Color, background color, and once again, click on the xy box to create an expression Alpha will use to check for a specific condition.

    For example, you may have a Bal_Due field on your report. You can create an expression that turns the font from black to let's say red if the following condition is true:

    Bal_Due > 0

    That means every balance due greater than zero will show up in red text, otherwise the text will be black. Anyway, that should give you a pretty good start on figuring out a solution.

    Robert T

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: conditional color on calculated field on a rep

    Depending on the complexity of the calculated field to which you are applying the font color equation, I have found it useful in some instances to substitute the background calculation for the calculated field in the test instead of the calculated field name, expecially if the calculated field is built up from other calculated fields.

    For example with the Bal_Due example as given, using the Bal_Due > 0, for instance, if Bal_Due is defined as Charges - Payments, you can make the conditional test for the font color equation be

    Charges - Payments >0

    This is just from my experience and might be a reflection of some other error I made.

Similar Threads

  1. Color Expression for field on report
    By Jim Chapman in forum Archived Wishlist
    Replies: 6
    Last Post: 06-14-2005, 05:42 AM
  2. Conditional Memo field on a report
    By Paul Smithson in forum Alpha Five Version 5
    Replies: 4
    Last Post: 09-12-2003, 08:46 AM
  3. calculated field on V4 report
    By Carolyn Simpson in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-14-2003, 01:05 PM
  4. conditional calculated field
    By Greg Fong in forum Alpha Five Version 4
    Replies: 2
    Last Post: 06-16-2002, 09:25 AM
  5. calculated field in a report
    By david dickie in forum Alpha Five Version 4
    Replies: 10
    Last Post: 03-10-2002, 03:42 AM

Bookmarks

Posting Permissions

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