Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total to exclude Group 2

Status
Not open for further replies.

rwn

Technical User
Dec 14, 2002
420
US
I have a report that is Grouped By Promised Date for Jobs. So a Job could have multiple Promised Dates. I would like to create a formula or running total that indicates the count of Promised Dates for each Job. So if a Job has 4 Prom Dates, then it would be (1,2,3,4). But when I include the Group into the report it changes the count based on where the Job is relative to the Group.

Thank you..
 
How does it change based on where the job is? If you group on Promise date it should total from promise date not location.

Have you tried doing a group under promise for Job? Count for that group and hide details.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
If you want a report total by job, then you would have to create running totals by job where you use an evaluation formula like this:

{table.jobno} = 1234

In other words, a running total per job.

Or, you could try inserting a crosstab in the report footer where you use promise date as the row, and job as the column, with count of job as the summary field.

-LB
 
I have attached the report, it will better clarify my intent.
 
sorry attachment didn't work...
 
I'm not looking for a running total but a count of the Deliveries against a Job. So if a Job has four deliveries and each delivery is in a separate Group (Date by week), the running total count would be 1 for the first job's delivery, 2 for the second job's delivery,3 for the third job's delivery,and 4 for the foruth job's delivery.

example:

Grouped by Promised Date -Weekly
Job xyz count 1 (this job has 4 deliveries)
Job abc count 1 (this job only has one delivery)

Grouped by Promised Date -Weekly
Job xyz count 2

Grouped by Promised Date -Weekly
Job xyz count 3

Grouped by Promised Date -Weekly
Job xyz count 4

I hope this helps. Thanks for the assist!!

 
Then you can try my suggestion... Group on Promised Date -Weekly

then group on Job

then do a count summary to the job group level

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Thanks to all.

The Edit Running Total is:
Field to Summarize is Delivery.Promised Date.
Type of Count.
Evaluate for Each Record
Reset on Change of Job.
 
that should work as well ... make sure your records are sorted by job

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
I thought that I had it until I see that it first Groups by Jobs then Group by Date. The Summary Count is fine then. But it needs to be Grouped by Date and show the Jobs by each date and have the correct count of deliveries for the job(s). I will keep trying.
 
Then you should try my suggestion for a running total, where you have one running total per job, evaluate based on a formula using the job number, reset never. Or if you really only need the summary count, then use the crosstab suggestion.

-LB
 
I like option A. Is this what you mean?

Here is the summary.
Field to Summarize: job.job
Type of summary: count

evaluate: Use a Formula = Job.job field

Reset Never


The results are all 0 next to each Job.
 
Using Crystal syntax:

{job.job field} = 1234 //the id of a specific job

-LB
 
I thought I understood what rwn is trying to do.

When the post a few above this showed a count of jobs under Promised Date -Weekly, it made sense to sub group jobs and do summary count.

My apologies lbass....

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
LB,

I must be overlooking the obvious. I don't understand the & where this goes:
{job.job field} = 1234 //the id of a specific job

My appologize. rwn
 
Here is how the report looks. This should help clarify.

GH1 9/27/2009
job # 13033 should be count of 1
job # 13034 should be count of 1
job # 13037 should be count of 1

GH1 10/25/2009
job # 13034 should be count of 2
job # 13033 should be count of 2
job # 13036 should be count of 1
job # 13037 should be count of 2

GH1 11/22/2009
job # 13034 should be count of 3

GH1 12/6/2009
job # 13034 should be count of 4

GH1 1/10/2010
job # 13034 should be count of 5
 
When you insert the running total, you choose count of job#, evaluate using a formula and enter the formula there:

{table.job#} = 13034

Reset never.

-LB
 
If I don't reset then the count is 10. What is needed is a count for each delivery off a job. So job field data of 13034 will have a count of 1, 2, 3, 4 and 5 for each time if is shown.
 
How would you get a 10? You would get a 10 if you did NOT enter the conditional formula in the running total. In the running total there are three sections. First is the summary section: count of job. Second is the evaluation section where you should choose "Use a formula" and then click on the x+2 box and enter the formula:

{table.job#} = 13034

The third section is for the reset, where you should choose "Never."

-LB
 
Can't you just do a Distinct Count against the date field based on Groups?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top