The simple SUM OF reports work fine. The ones I need to convert to DBCalc have a truck load of SUM OF's and not on column values.
I was hoping to "do it later". You can see how old the report is by the expressions list below. (Three break levels of subtotals and a grand total.) Oh well, at least it will run a lot faster.
10 : INTEGER : D : INC = (.INC + 1)
11 : INTEGER : D : INCS = (.INCS + 1)
12 : INTEGER : D : INCG = (.INCG + 1)
13 : INTEGER : D : STATC = (IFEQ(TK_STAT,"C",1,(IFEQ(TK_STAT,"c",1,0))))
14 : INTEGER : D : STATX = (IFEQ(TK_STAT,"X",1,(IFEQ(TK_STAT,"x",1,0))))
15 : INTEGER : D : STATI = (IFEQ(TK_STAT,"I",1,(IFEQ(TK_STAT,"i",1,0))))
16 : INTEGER : D : SUMACT = SUM OF STATC
17 : INTEGER : D : TTLACT = SUM OF STATC
18 : INTEGER : D : GTLACT = SUM OF STATC
19 : INTEGER : D : SUMXLD = SUM OF STATX
20 : INTEGER : D : TTLXLD = SUM OF STATX
21 : INTEGER : D : GTLXLD = SUM OF STATX
22 : INTEGER : D : SUMINC = SUM OF STATI
23 : INTEGER : D : TTLINC = SUM OF STATI
24 : INTEGER : D : GTLINC = SUM OF STATI
25 : REAL : D : PCTCD = (100 * (SUMACT / INC))
26 : REAL : D : PCTEM = (100 * (TTLACT / INCS))
27 : REAL : D : PCTGEM = (100 * (GTLACT / INCG))
28 : REAL : D : PCTXL = (100 * (SUMXLD / INC))
29 : REAL : D : PCTEXL = (100 * (TTLXLD / INCS))
30 : REAL : D : PCTGXL = (100 * (GTLXLD / INCG))
31 : REAL : D : PCTI = (100 * (SUMINC / INC))
32 : REAL : D : PCTEI = (100 * (TTLINC / INCS))
33 : REAL : D : PCTGI = (100 * (GTLINC / INCG))
34 : REAL : D : HRSACT = (TK_AMIN * STATC / 60)
35 : REAL : D : HRSACTO = (TK_AOMIN * STATC / 60)
36 : REAL : D : HRSSCH = (TK_SMIN / 60)
37 : REAL : D : TTLAMIN = SUM OF HRSACT
38 : REAL : D : TTLAOMIN = SUM OF HRSACTO
39 : REAL : D : TTLSMIN = SUM OF HRSSCH
40 : REAL : D : TTLESMIN = SUM OF HRSSCH
41 : CURRENCY : D : EMRATE = EM_RATE IN EMPLYS WHE EM_NBR = EM_NBR
42 : CURRENCY : D : ACOST = (ACOST + (TK_CSTA * STATC))
43 : CURRENCY : D : AOCOST = (AOCOST + (TK_CSTO * STATC))
44 : CURRENCY : D : SCOST = (TTLSMIN * EMRATE)
45 : REAL : D : EHRSA = SUM OF HRSACT
46 : REAL : D : EHRSAO = SUM OF HRSACTO
47 : REAL : D : EHRSS = SUM OF HRSSCH
48 : CURRENCY : D : EACOST = (EACOST + (TK_CSTA * STATC))
49 : CURRENCY : D : EAOCOST = (EAOCOST + (TK_CSTO * STATC))
50 : CURRENCY : D : ESCOST = (TTLESMIN * EMRATE)
51 : REAL : D : EHRGSA = SUM OF HRSACT
52 : REAL : D : EHRGSAO = SUM OF HRSACTO
53 : REAL : D : EHRGSS = SUM OF HRSSCH
54 : CURRENCY : D : EAGCOST = (EAGCOST + (TK_CSTA * STATC))
55 : CURRENCY : D : EAGOCOST = (EAGOCOST + (TK_CSTO * STATC))
56 : CURRENCY : D : ESGCOST = (ESGCOST + (TK_SMIN/60 * EMRATE))
>>>>>
At 10:09 AM 8/5/2005, you wrote:
Dennis -
Try changing from SUM OF variables to using the DBCalc object.
Sami
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sami Aaron
Software Management Specialists
913-915-1971
[EMAIL PROTECTED]
________________________________
From: [email protected] [ mailto:[email protected]] On Behalf Of Dennis Fleming
Sent: Friday, August 05, 2005 7:41 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Report breaks and duplicates?
RB7.1
Having some problems in trying to get some reports to subtotal properly
without duplicating a line (or leaving values blank) when going to a new
page. Header and footer page breaks and subtotaling seem to work fine except
for a new page. Keep together or not doesn't seem to matter. One pass or two
pass setting doesn't seem to make a difference either. Examples:
Break_var1 1
Break_var1 23
Break_var2 15
Break_var3 20
or
1
Break_var1
Break_var2 15
Break_var3 20
etc.
Any suggestions appreciated. I thought about building a view instead of
using SUM OF and do all totaling outside the report since this will make it
faster. But I need to get this out the door asap.
TIA,
Dennis
*****
Dennis Fleming
IISCO
http://www.TheBestCMMS.com < http://www.thebestcmms.com/>
Phone: 570 775-7593
Mobile: 570 351-5290
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
