Skip to Content
avatar image
Former Member

How do I reference an empty running total?

Crystal Reports

I have a running total that I am referencing in a format condition for another cell.

Sometimes the running total will not have any eligible records, and will be blank.

It is when RunningTotal1 is blank that I want a particular color applied to my other text.

I tried with a <1 condition, an =0 condition, I get a syntax error if I try to us = ""

What is the correct way to reference this RunningTotal1 condition/value?

The help section indicates that null number values are 0, but that does not work in this case.

To duplicate, create a running total, that is reset on change of a group. You must have some groups that do not have any eligible records, others that have records.

Then, color condition, or any other condition a different value based on the value of the running total. How do you successfully identify the running total value for your groups that have no records?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 28, 2017 at 08:04 PM

    Answer is:

    Go to File - Report Options

    Check the box Convert Other NULL Values to Default

    This forces a zero to the running totals with no records.

    You can then run reference formulas tying to the running total that reference If runningtotalname = 0

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 28, 2017 at 04:38 PM
    -1

    Hi Jackie,

    Not many people remember this but for ANY (or most) programs if you hit the F1 key it will bring up a local Help file, try it...

    Then search for "To create a conditional running total".

    You'll find examples on how to structure formula syntax in CR Designer.

    Then to set the color search for "Conditional formatting functions (Crystal syntax)"

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2017 at 06:03 PM

    The total is not conditional. The results of the total dictate the condition of a different field. I do not know how to properly reference a running total that has no qualifying records, and is therefore zero or null. My attempts at how to reference this have failed. I did use the program help before posting. I am still new at Crystal, but have been using it for a bit over a year, and this is my first question posting.

    Add comment
    10|10000 characters needed characters exceeded