[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Running Total Field Error Message?

Posted on 2004-04-27
4
Medium Priority
?
743 Views
Last Modified: 2010-07-27
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
Comment
Question by:techdl
2 Comments
 
LVL 28

Accepted Solution

by:
bdreed35 earned 500 total points
ID: 10929153
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
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 500 total points
ID: 10929201
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month20 days, 8 hours left to enroll

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question