• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 785
  • Last Modified:

Running Total Field Error Message?

In Crystal Reports 8.5, I am trying to add a running total field to my report and each time the report generates, I continue to get the follow message, "A running total cannot refer to a print time formula". The following is my formula:

UCase(GroupName ({usp_RPT_PipelineTrend.LocationSubtotalNM})) = "RECURRING REVENUE"

Any suggestions will be greatly appreciated.
0
techdl
Asked:
techdl
2 Solutions
 
bdreed35Commented:
Try changing it to just reference the group field with out using the groupnamce function, you should still get the same result.

UCase({usp_RPT_PipelineTrend.LocationSubtotalNM}) = "RECURRING REVENUE"
0
 
frodomanCommented:
You cannot use "groupname" in a running total because groupname is only available during the "whileprintingrecords" pass of the report engine but the running totals have already been evaluated before that pass.

Interestingly Crystal will (v9 at least) let you create the formula and will check it w/out errors but it does trigger an error as soon as you actually put the running total field on the report.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now