Solved

Crystal Reports Summarizing a field that uses NEXT in the formula

Posted on 2012-12-20
2
349 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

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. …
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 video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

776 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