Bill,
Variable expressions, with the computation done in the detail section.
examples below
1 : TEXT : D : frinvno = invoiceno
2 : TEXT : D : PCPrevtech = prevtech from chistory whe invno = invoiceno
3 : CURRENCY : D : CHCharge = Charge from Chistory whe invno = invoiceno
4 : CURRENCY : D : ChChargeSum1 = (ChChargeSum1 + CHCharge)
5 : CURRENCY : D : PCAccSum = (pcAccsum + PCAccrued)
6 : CURRENCY : D : vpcmaacc = FRnclsa in frhistory whe invno = invoiceno
7 : CURRENCY : D : PCReal = (.vpcmaacc + .chcharge)
8 : CURRENCY : D : PCRealSum = (PCRealSum + .PcReal)
9 : INTEGER : D : PCCount = (PCCount +1)
10 : CURRENCY : D : PCRealAVG = (BRND(PCRealSum / PCCount,8,.01))
11 : CURRENCY : D : ChChargeSum2 = (ChChargeSum2 + CHCharge)
12 : CURRENCY : D : PCAccSum1 = (pcAccsum1 + PCreal)
13 : CURRENCY : D : vpcmaaccsum = (vpcmaaccsum + vpcmaacc)
14 : CURRENCY : D : vpcNCL = frncl in frhistory whe invno =
invoiceno and invno in (select invoiceno from procomptable where
invoiceno = .frinvno and pccalltype cont "RC")
15 : CURRENCY : D : vpcncle = frncle in frhistory whe invno =
invoiceno and invno in (select invoiceno from procomptable where
invoiceno = .frinvno and pccalltype cont "RC")
16 : CURRENCY : D : vpcnclt = (.vpcncl + .vpcncle)
At 03:36 PM 1/2/2008, you wrote:
Dan,
That's exactly one solution I have used: a summary version, the same
report, but deleting the "detail" section. How did you calculate or
generate your sub-totals and totals? With DBCalc objects, or with
variable expressions, or with math in header or footer eeps?
Bill
On 1/2/08, Dan Champion
<<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]> wrote:
Hi all,
I think the other list isn't working. So I will ask here.
I have a nice report that gives me my monthly sales with each
invoice showing in the detail section of the report. Breaks based
on salesmen, Totals of each sales are in the break section, and a
report total in the report footer.
I would like to have a summary report that doesn'tt show the
details, just the break totals and report totals. I made a copy
of the report and tried making the detail section not VISISBLE, but
the data isn't parsed and therefore my totals are all blank.
How do others accomplish what I am after?
Thanks for your time.
Dan
At 03:00 PM 1/2/2008, you wrote:
Wednesday, January 2, 2008
To all users of R:FTPClient 7.6 and 8.0:
The updated versions of R:FTPClient 7.6 and 8.0 are
now available.
Depending on your license, these updated versions are
available as FREE updates to all existing users of
R:FTPClient 7.6 and 8.0.
All users of R:FTPClient 7.5 can also UPGRADE their
existing versions to R:FTPClient 7.6 or 8.0.
Please contact our Sales Team at 1+724.733.0053 or
e-mail to <mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED] for appropriate
link
to download R:FTPClient 7.6 updates.
For product details and the complete Help Manuals:
R:FTPClient <http://www.rftpclient.com/>http://www.rftpclient.com
Very Best R:egards,
Razzak.
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
616-299-7420 cell
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
616-299-7420 cell
