Solved

Crystal Reports Summarizing a field that uses NEXT in the formula

Posted on 2012-12-20
2
344 Views
Last Modified: 2012-12-20
I'm trying to summarize a formula in my report and can't find it to select it in my summary.  I googled this and have read that you can't summarize something that uses NEXT or PREVIOUS in it's formula.  Is there a work around for this?

I want to be able to count the number of "On Time" jobs by process code as well as the number of sequences so that I can insert a chart in my report.

Thanks,

Sue
Process-OTD-if-Arrived-On-Time.rpt
0
Comment
Question by:ITworks
2 Comments
 
LVL 18

Expert Comment

by:vasto
ID: 38711352
ITWorks, I guess this is the 3rd question related to the same report. I proposed the Next function for the first question, although I was almostsure that the right way to handle this is on the database side. Looks like you are going from one problem to another when you are trying to use the report side. If you explain what the report should do and what is the database type and structure  somebody might propose a better approach.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 38711363
There is no work around to be able to summarize using the summary functions.

You can however do similar functions with formulas and variables.

mlmcc
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now