BradCustom
IS-IT--Management
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.
Any ideas would be greatly appreciated!!
Thanks for the help
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