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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Running Total

Status
Not open for further replies.

BradCustom

IS-IT--Management
Oct 5, 2007
296
US
I have one minor problem with a report. When I pass the Job Count value from the subreport to the mainreport the values are off by one record. I've had this problem in the past and corrected it by placing the formulas in the correct section. I believe I have the formulas in the right sections but the passed value is still off by one record. I'll explain the structure below.
Code:
The mainreport has 1 table Employee and one group Employee
Everything is in the Group footer
GF1a has a Sub Report for employee's job punches 
GF1b has a passed variable {@PassJobCount} this comes from the Sub Report
GF1c has The employee's First and Last Name
GF1d has a line to seperate the records


The subreport has 3 tables
Job
Job_Operation
Transaction_Data
Transaction_Detail

The detail section has the following fields
Job.Job
Job_Operation.Op
Transaction_Detail.Start
{#JobCount) a running total formula on the Job.Job field set to count (eval each record and reset at change of group)

The Group Footer has one formula
{@PassJobCount}
whileprintingrecords;
shared numbervar jobcount := ({#JobCount})

The Pass formula in the Mainreport as listed above is in GF1b
(this is the formula)
whileprintingrecords;
shared numbervar jobcount;

Any ideas would be greatly appreciated!!
Thanks for the help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top