Skip to Content
author's profile photo
Former Member

Manual Running Total

Post Author: dbmngleaf

CA Forum: Formula

I'm using Crystal Report XI and I have a report where I need to supress data and show a running count for just the records that are showing on the report. My supression works fine but the running count isn't. I've seen that you can't use the built in running totals when you're supressing data and I seen that you can create 3 formulas to get this to work however it isn't working.

My formulas are:

total_init

WhilePrintingRecords;

numberVar overall_total:=0;

total_calc

WhilePrintingRecords;

numberVar overall_total;

overall_total:=overall_total+1;

total_disp

WhilePrintingRecords;

numberVar overall_total;

The formulas are totaling everything including the supressed records. How do I get it to count just the records that are displaying? Thanks for any help in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 09:06 PM

    Post Author: yangster

    CA Forum: Formula

    you're almost therethe only thing you need to is change your evaluation formula, you don't have an if statement in there to tell it to ignore the records you don't want to countwhat you have right now is it will increment by 1 for every recordtotal_calc

    WhilePrintingRecords;

    numberVar overall_total;if not(whatever you are supressing on) thenoverall_total:=overall_total+1;so this will count every time the record is not supressed

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 09:38 PM

    Post Author: dbmngleaf

    CA Forum: Formula

    Thanks so much, I knew I was forgetting something!

    Add comment
    10|10000 characters needed characters exceeded