|
|
 | | From: | Larry Kinder | | Subject: | Report with average for groups | | Date: | Wed, 29 Dec 2004 13:19:08 -0600 |
|
|
 | My last line gives me the average for each day, but what I want to see is
the average of each of the weeks. Each Subtotal is being displayed, so seams
like I could reference that the STREAMSOURCE1.GROUP1.footerBand.????, and
average it?
Larry Kinder
begin 666 RptStats4Emp.zip
M4$L#!!0````(`!%HG3'.5MSFA H``#M9```0````4G!T4W1A=',T16UP+G)E
M<.U<;7/:.A;^O)WI?]"PLQ-H4P?;8"#3=H8TSLML"%E#V^WM)FGNWOO?5Y)?D+$,`GO9L%EFTH(DGR,]SY%L/3[VFS= OST'5WKW7#? NW=@
M[ '7"P""CO<`03"S?&!;+GS]ZN2$_(%+Z$)D!G ,/!?(RHG2.5'J]498;WLC
MTP;H]2L$/@`7/@+C;C@8=H>#AMZ[,_2[OC&LUG"MA* [AHA\?_UJ9)N^SVD)
MO D(O[U^!0!XM((9J)(.U>AO_ FM8%?4Q.GI1=_H_6K@\>A&W"2P`AOB%A5C
M'@P",_ ;NC.OQ+4.#) UPM7J7_#0KMW1#/JT#ALF_DCWB!'L5&([*$?#^\=G
MW?A6K>4TDN8F[F& VY*ZE4&DFR9#LN&$'/"N+M7KG58R"F\>%MA4<^M.$H`&_ !'D.J*!YX--Q0F\G%= W"+5GWP`Z[P[UHR5XORV@']Q8
M#P2?B6G[,*XR1T%8&J %Y.#!C&*.+#> *.G_>#&WX4]\J$P0O?7M&5@X;J+J.P\%R+2"N,GM._)L#\5^>I[KC688GJ0S9&##ISF\\-S Q\T4TNS<>W1MSQSG1MV?BDQQ' EC'!F6TO71K]STG@T!_5;*O:*KX\&PG84^0MYF=/)+S15PA_5-9S
MQ;,ES:")Y]"9Z8X3LS.(@211B.-M!XL3SPOR+:I-M2D$<-:<--3_.32&USU]
M\&T0(TG*MNB,>.?3WGA#D34MF:'1O)4E16ZO3-L81>I]C-V3HJ92;\>E#R:R
MS'L;7L6FDVF'/W,$)]9/W24-5NM:2V-<(,X2'H'?Q)G__KC#W?A*#,GFM!TS8K_,Z>#A5/%3=@ZY#WZ,) F%K3'
M_B\5-+0<.'CR*]^E!]->P#]KM3^+,+P?9KF,8E+4%48Q>TJ](\!HI]E.EN;=
M2%L24GE_U?@(0 6\!1Q2M4T6H^5^;;!BCLB8;Q=SH[VG2)=X$&58(=&O1O=NCQ13=X(<
MJY+<;"3DO2"."4BEDGQ]?J/OD63J3ICDMK*\GG]!)!.02B7Y4_?F9H\D4W>"
M)#>D1JOU$E=K`E*I)'>_7.Z18^)-D.*F)"O*05YR.3Z?XNX7W>A>ZB(T8YQ*
M8YF$S+[VL*$O888/Y%P\MT;!`E%MK]/I'.,_SD9JUUE-(5N278SKWN!R7U13
M5X),:U)#T[3#(UOJ=/XF2K7@[":PE<5V]_.POR>VJ2M!MEN2W$BTC1=--D%M
M/=FY/(QA8%KVDC"05H]4614+G:6=D$@BW6R*F57?`IUDC'.CA+E:6ZI=`C'2
M8C3.=6&PPM<$!X3$WH>1UVI8@M-P=;B"^O#.<*Y5A+.(RI*L-A-A< VHR4J\
M#E&1Z<._M!4`?T7'%5T'>0`):(:%",A5"7D$M-JR3,@@0D/0*$9 K
MXF4)4*2&VA+9^S\/`@PO*(,`$<6M$ /Y&EN6`E6JMX2V;<^#@J_(G)?!@8@@
M5HB#? F,QT%+[8A<;C\/#J['-BR#`Q&]JA '^0I5EH.&I'::(OO;Y\'!)].V
MR^! 0$XJ1$&N@)1EH"G5&[+(#?+2&/ 7M+4J/D ZT,SEKE!\>-2VQW(72J!&7< 0((9/%+[AW$%%J=B8C7YO)MNP;13;<`$SU_6I0($1%E9R+R99,L$2VIKBE[O7@MD8CN(O *$D$VY,I_B@AJ
MG*ND\/)P6EI=9$:H^!.7[BQ@+;'V%_=^@*JCL??(G!O8+,LL[F,S6%X['M:O[9X:Y[J0_UWMT-HP"Q9=1G!M;445D`93D+3%M*HM@QT=1RAQ&$6E-3TC4W
M,>(*<\$:5IUY0> YM++=6C%H+.ECF)HB:WQCN?!K3) 0$E'@7!C=WDJJ)2W*
M12$/HY2]+&!M">]0LUJ8(KM#UG"405-9X),!\IBF) YDUT4MT&!6N!-.%5K:-GA9]:]94D\=$5J=M0$)($I
M57D_DS^29%7["="EBV#S_@07)@L=!2L>+ MT%ALE["QYQH!V/!*=(X'7XU6$A8E)1\E11PEXY:9:KM#%9H17-,5J<-1AM1F
M(UF0EG@IK1+N2TSP:3?.(U>6:R0I/O/L,<%T\F=,G7, 0E4"MG!?8#.((SCT47)+$[PVIVXJB-?+HYUN1AM?#&STY,V>#89WSC7UM1V*[1>BJ\=$@I^DP279GG')O-I0%U:'<;:"(#IY\'-$E0,J]?5 FI(=P_P"?
M*1L?^XL`GQR+XLF]&U FGH=P.X#B:7AEX,D7]\L$]"#4?8HH$>M+@)2OU9<)
MZ4&(]112HKV7`"E?>B\3TH/0WBFD0]/^40*D7"6]3$2?M93.`MI]F!;$,T?Z
M+@O-[;7O_UIP4NFZ()I\Z;HL,)^W=LUB2<3G@E#RQ>>RH'S>ZC,+Y:U'!.1<
M,',&O9K4F!ZDUFGF2C=\*QNRNM:YWMA#@8PNWF.'W#T6(X-Q>-E9LBB62LF_
M_9Q)G'R R)S"U<3)M'A?X*G?3>!OW.X5(':KYTFY.[V72"R3A5:$V(W[S@+$
M;O48*7?+^1*)9;+;BA"[>0-<@-GMGA[E[GU?(K5LUEP1;C?OQ MPN]U#H]Q-
M^$ODELW&*\+M9DF@`+?Y:@#O65&N&O 2N66S_(IPNU&;*$#M5H^(UAOR0<[:
MW$=$=V66R0_8>[L;Q9O-F1Y.V>
M!^7J-L^>XZT>$=R%X50^XVX$;Y:4=B1XNT= N6K2_PE.Y4GF$SRQD!_<8>O#
M*&T#?(@J,OD7?B\IBPPJ<5J_92=1$JJ8-Y:8X1
M(I.%.Z(O7R0-?\4@CR&*.;(F('B:PRJHA/&[ML<6Q0^?!%PL^0D2,?<#!T6>MX0^.HT<(,.G@'EKN%(SPZ@S'X;LQ3MFL'1#SPM@ \A=3V#J0..:*J:`V:FGSG6!#C0,)38,S*?3M/U:X81\TJ.70X)
MI(\/71!NUC@!$9A1DP]@K:\\!V3,CFFYT7M3^2XX"7(T?PFMOJ^8P:%B39BBZ'<^[QEX\.K'.I(L_^_P";<^I_G%I&7:(VV;FXK\8/D66;]6
M>L^8^Y[M+?.#8,?&<5R)(%[!7/+\"42GI^$,"=]XB[_2-]:2[\D\NL57H%>]
M*K"BWF.K> UU\7H6^ !?GMY#1()S-IN=.LZI'U(8OG!W=@R<8Q"6D.7;<@-B
MYP2H6KT>F7.B\JH%WN%&;VA=#;?1\+^T!0D:4NG@2JW.M**U\6@"5,7NU&-0
M/P9'X*@&WH*CTR/\+ZG!O5#"FOI1+3.ZWN 01I<:0VIT?GIT_P902P,$% ``
M``@`9&>=,3V*21%M`P``[@X``! ```!2<'13=&%TM$&TB%@C!DB6H3S"J*O_:RY"PB(!$(D%9CY1)B)A\- E('(2C<#\\='TZTSV1
M%6%IU#7VL_U<57ZNY]]>O7W3-,V?G=_-9GM6?OOO3P\.OQ[#:'#05ON[)Q\>
M&=]_T?2+<5L=SJ\66]%-L_?NX?_5R>75XOC7W32Z:0Y?/OS_#W]T?CZ-WH+_
M@*_7GNK-R?PG^\N
M'H$7_,Z#_ZO='_N+Q7+>?KR\/ENL
MVLF&,7KH+1]#QYVY([8`LV*!^WP`Z7(ZZ@*#9CF)E137(I-R4$&*0J!^8?(4
M/*] B;?PA)UB@;]=#CI=^EHO@])R342%%@#6D/ #VEHL9N=M,L>)U9+,:)&M0HI'"ZDHHT:*:DAA3KV[2\PRGXR@DW-CL-,"]PU)J14YX#"3
MN5/A(W UI"CR%@3)RVF[CG.%_."TP%\=74=?+,FIXBD^!LRB^M%(Q0I2V$%@
M3Z62Z=P;,I^;4I<4"_SU04-*.HIL#<.7AL%E4JF"%.7@>P)E?[U]44*04+*K
M-5(YV)TCM29RRL)GI+H:4@`=;ECK!OW'.=M623UJP8"46$-2-3I%10EZQY>+
MX3E_B@[(N6,<$<5R)76Z6IZ]5Q+==,J"*Z2P)M$+C)=#3)K4'GDSC*9)ZA5'
MFE/>_,BD<$9*+PPSCDGY&E()^/:5_4WL1)5]H#&IUCPUR#@^T#"G.ATU4J&"
M%$5@=U- +XMDSZ2*C(USRBMZ*14!G[4\(F_2_A4XXQ4C2249PYIPUHWZ#^4<4SJ*;=/276KH]O5I^M2<[:/
M-%.=@?[H9K'[OZ2HIDIP1M":F:*L&5*J5?SF&(\E2@:$UP8YUJDR6_B8-34E)KE$1723!2=54"<&(6L35-
MMFH2(-\T 2I,*8R=&&X3-2->))R?'),'52?F0I_(I.YU&1%TO3Z6(5
M06'0P%/F92-5HU-M0'E*R6E.I<#TRBH2H""%,0*HIU39M%XPR1R*IY&JT:DB
M>I(_9K46JDSCG'K"[2/Z"U!+`P04````" !D9YTQ>4XETM@`````% ``$ ``
M`%)P=%-T871S-$5M<"Y-1%CMF$N*PE 01>O%7]2H\3OK%3AQ"Y'T7.(#M^#8
M%;@A%<5ONSEOR15G.FPT=:#(R:$F@0Q>4IA'/]G$3WWBIT("D:(;#<5),*O)
M$ZR*D4LM#GH?C;L_M\ZW?]2X=PM&KNGSRO=DN3J-DX!M#2^PJQ?9-_ 2NWJ9?0NOL*N'
M[#MXE5V=_Q26>WB=.P=XQ*[>8#_"F^SJ+?83/*:?X6WNJ'?8+_ NNWJ/_@=_
M//<5+H:14VY02P$"% L4````" `1:)TQSE;M`" `````````4G!T4W1A=',T16UP+G)E<%!+`0(4"Q0````(`&1GG3$]BDD1
M;0,``.X.```0``````````$`( ```+(*``!2<'13=&%TM`A0+% ````@`9&>=,7E.)=+8`````!0``! ````````````@````30X``%)P
D=%-T871S-$5M<"Y-1%A02P4&``````,``P"Z````4P\`````
`
end
|
|
| | From: | Michael Nuwer [dBVIPS] | | Subject: | Re: Report with average for groups | | Date: | Thu, 30 Dec 2004 17:04:51 -0500 |
|
|
| This is a multi-part message in MIME format.
--------------050605030808080703000909
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Larry Kinder wrote:
> My last line gives me the average for each day, but what I want to see is
> the average of each of the weeks. Each Subtotal is being displayed, so seams
> like I could reference that the STREAMSOURCE1.GROUP1.footerBand.????, and
> average it?
>
> Larry Kinder
>
>
--
Michael Nuwer
http://www.ChelseaData.ca/dLearn/
http://www.nuwermj.potsdam.edu/dSamples/
--------------050605030808080703000909
Content-Type: text/plain;
name="RptStats4Emp.rep"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="RptStats4Emp.rep"
** END HEADER -- do not remove this line
//
// Generated on 12/30/2004
//
local r
r = new RPTSTATS4EMPREPORT()
r.render()
class RPTSTATS4EMPREPORT of REPORT
with (this)
render = class::FORM_RENDER
title = "RptStats4Emp"
metric = 3 // Inches
endwith
this.RPTSTATS4EMP1 = new QUERY()
this.RPTSTATS4EMP1.parent = this
with (this.RPTSTATS4EMP1)
left = -0.0097
top = -0.0104
sql = 'select * from "rptstats4emp.dbf" ORDER BY rWeek'
requestLive = false
active = true
endwith
with (this.printer)
duplex = 1 // None
orientation = 1 // Portrait
paperSource = 15
paperSize = 1
resolution = 4 // High
color = 1 // Monochrome
trueTypeFonts = 2 // Download
endwith
this.STREAMSOURCE1 = new STREAMSOURCE(this)
this.STREAMSOURCE1.GROUP1 = new GROUP(this.STREAMSOURCE1)
with (this.STREAMSOURCE1.GROUP1)
groupBy = "rWeek"
endwith
with (this.STREAMSOURCE1.GROUP1.footerBand)
height = 0.3535
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMESYS1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMESYS1)
height = 0.1667
left = 1.2187
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agSum({||this.parent.rowset.fields["rTimeSys"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXT1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXT1)
height = 0.2083
left = 0.0209
top = 0.0
width = 0.9584
prefixEnable = false
colorNormal = "b+"
text = {||" " + this.parent.parent.parent.rowset.fields["rDATE"].value + ""}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEOFF1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEOFF1)
height = 0.1667
left = 1.8639
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agSum({||this.parent.rowset.fields["rTimeOFF"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEROT1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEROT1)
height = 0.1667
left = 2.5201
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agSum({||this.parent.rowset.fields["rTimeROT"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEWRAP1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEWRAP1)
height = 0.1667
left = 3.1548
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agSum({||this.parent.rowset.fields["rTimeWRAP"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEIDLE1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEIDLE1)
height = 0.1667
left = 3.8215
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agSum({||this.parent.rowset.fields["rTimeIDLE"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMECALL1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMECALL1)
height = 0.1667
left = 4.4771
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agSum({||this.parent.rowset.fields["rTimeCALL"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEAVG1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRTIMEAVG1)
onRender = class::TEXTRTIMEAVG1_ONRENDER
height = 0.1667
left = 5.1229
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2ms(this.parent.parent.agAVERAGE({||this.parent.rowset.fields["rTimeAVG"].value}))}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRCALLS1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRCALLS1)
height = 0.1667
left = 5.8
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "999,999"
text = {||this.parent.parent.agSum({||this.parent.rowset.fields["rCALLS"].value})}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRMSGS1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRMSGS1)
height = 0.1667
left = 6.4666
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "9.99%"
text = {||this.parent.parent.agAVERAGE({||this.parent.rowset.fields["rMSGS"].value})}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXTRAUTO1 = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXTRAUTO1)
height = 0.1667
left = 7.143
top = 0.0
width = 0.5208
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "9.99%"
text = {||this.parent.parent.agAVERAGE({||this.parent.rowset.fields["rAUTO"].value})}
endwith
with (this.STREAMSOURCE1.detailBand)
height = 0.2313
endwith
this.STREAMSOURCE1.detailBand.TEXTRDATE1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRDATE1)
height = 0.1771
left = 0.0
top = 0.0
width = 0.7187
prefixEnable = false
text = {||this.form.RptStats4Emp1.rowset.fields["rDATE"].value}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMESYS1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMESYS1)
height = 0.1771
left = 1.1354
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = {||num2hm(this.form.RptStats4Emp1.rowset.fields["rTimeSys"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMEOFF1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMEOFF1)
height = 0.1771
left = 1.7812
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = {||num2hm(this.form.RptStats4Emp1.rowset.fields["rTimeOff"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMEROT1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMEROT1)
height = 0.1771
left = 2.4375
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = {||num2hm(this.form.RptStats4Emp1.rowset.fields["rTimeRot"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMEWRAP1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMEWRAP1)
height = 0.1771
left = 3.0729
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = {||num2hm(this.form.RptStats4Emp1.rowset.fields["rTimeWrap"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMEIDLE1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMEIDLE1)
height = 0.1771
left = 3.7396
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = {||num2hm(this.form.RptStats4Emp1.rowset.fields["rTimeIdle"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMECALL1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMECALL1)
height = 0.1771
left = 4.3958
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = {||num2hm(this.form.RptStats4Emp1.rowset.fields["rTimeCall"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRTIMEAVG1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRTIMEAVG1)
height = 0.1771
left = 5.0417
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
suppressIfBlank = true
text = {||num2ms(this.form.RptStats4Emp1.rowset.fields["rTimeAvg"].value)}
endwith
this.STREAMSOURCE1.detailBand.TEXTRCALLS1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRCALLS1)
height = 0.1771
left = 5.7187
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
picture = "999,999"
text = {||this.form.RptStats4Emp1.rowset.fields["rCalls"].value}
endwith
this.STREAMSOURCE1.detailBand.TEXTRMSGS1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRMSGS1)
height = 0.1771
left = 6.3854
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
picture = "9.99%"
text = {||this.form.RptStats4Emp1.rowset.fields["rMsgs"].value}
endwith
this.STREAMSOURCE1.detailBand.TEXTRAUTO1 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRAUTO1)
height = 0.1771
left = 7.0625
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
picture = "9.99%"
text = {||this.form.RptStats4Emp1.rowset.fields["rAuto"].value}
endwith
this.STREAMSOURCE1.detailBand.TEXTRDATE2 = new TEXT(this.STREAMSOURCE1.detailBand)
with (this.STREAMSOURCE1.detailBand.TEXTRDATE2)
height = 0.2083
left = 0.7604
top = 0.0
width = 0.3333
variableHeight = true
prefixEnable = false
text = {||substr(cdow(this.form.rptstats4emp1.rowset.fields["rdate"].value),1,3)}
endwith
this.PAGETEMPLATE1 = new PAGETEMPLATE(this)
with (this.PAGETEMPLATE1)
height = 11.0
width = 8.5
marginTop = 0.6562
marginLeft = 0.2396
marginBottom = 0.875
marginRight = 0.2604
gridLineWidth = 0
endwith
this.PAGETEMPLATE1.STREAMFRAME1 = new STREAMFRAME(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.STREAMFRAME1)
height = 8.3751
left = 0.2188
top = 0.9791
width = 7.6875
form.STREAMFRAME1 = form.pagetemplate1.streamframe1
endwith
this.PAGETEMPLATE1.TEXT1 = new TEXT(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.TEXT1)
height = 0.3646
left = 0.25
top = 0.25
width = 2.5938
prefixEnable = false
text = "Weekly Stats for"
form.TEXT1 = form.pagetemplate1.text1
endwith
this.PAGETEMPLATE1.TEXT2 = new TEXT(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.TEXT2)
height = 0.1667
left = 5.6875
top = 0.3646
width = 2.1771
prefixEnable = false
text = {||Date()}
form.TEXT2 = form.pagetemplate1.text2
endwith
this.PAGETEMPLATE1.TEXTRNAME1 = new TEXT(this.PAGETEMPLATE1)
with (this.PAGETEMPLATE1.TEXTRNAME1)
height = 0.2083
left = 2.9375
top = 0.3542
width = 2.2708
variableHeight = true
prefixEnable = false
fontSize = 12.0
fontBold = true
text = {||this.form.RptStats4Emp1.rowset.fields["rname"].value}
form.TEXTRNAME1 = form.pagetemplate1.textrname1
endwith
with (this.reportGroup.headerBand)
onRender = class::HEADERBAND_ONRENDER
height = 0.2264
endwith
this.reportGroup.headerBand.TITLETEXTRDATE1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRDATE1)
height = 0.1771
left = 0.0
top = 0.0
width = 0.7188
prefixEnable = false
text = "Rdate"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMESYS1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMESYS1)
height = 0.1771
left = 1.1354
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "System"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMEOFF1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMEOFF1)
height = 0.1771
left = 1.7812
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Out"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMEROT1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMEROT1)
height = 0.1771
left = 2.4375
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Rot"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMEWRAP1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMEWRAP1)
height = 0.1771
left = 3.0729
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Wrap"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMEIDLE1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMEIDLE1)
height = 0.1771
left = 3.7396
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Idle"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMECALL1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMECALL1)
height = 0.1771
left = 4.3958
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Talk"
endwith
this.reportGroup.headerBand.TITLETEXTRTIMEAVG1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRTIMEAVG1)
height = 0.1771
left = 5.0417
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Avg"
endwith
this.reportGroup.headerBand.TITLETEXTRCALLS1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRCALLS1)
height = 0.1771
left = 5.7188
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Calls"
endwith
this.reportGroup.headerBand.TITLETEXTRMSGS1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRMSGS1)
height = 0.1771
left = 6.3854
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "Msgs"
endwith
this.reportGroup.headerBand.TITLETEXTRAUTO1 = new TEXT(this.reportGroup.headerBand)
with (this.reportGroup.headerBand.TITLETEXTRAUTO1)
height = 0.1771
left = 7.0625
top = 0.0
width = 0.6
prefixEnable = false
alignHorizontal = 2 // Right
text = "NoAuto"
endwith
with (this.reportGroup.footerBand)
height = 0.691
endwith
this.reportGroup.footerBand.TEXTRTIMESYS1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMESYS1)
height = 0.1667
left = 1.1354
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rTimeSys"].value}))}
endwith
this.reportGroup.footerBand.TEXTRTIMEOFF1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMEOFF1)
height = 0.1667
left = 1.7812
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rTimeOff"].value}))}
endwith
this.reportGroup.footerBand.TEXTRTIMEROT1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMEROT1)
height = 0.1667
left = 2.4375
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rTimeRot"].value}))}
endwith
this.reportGroup.footerBand.TEXTRTIMEWRAP1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMEWRAP1)
height = 0.1667
left = 3.0729
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rTimeWrap"].value}))}
endwith
this.reportGroup.footerBand.TEXTRTIMEIDLE1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMEIDLE1)
height = 0.1667
left = 3.7396
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rTimeIdle"].value}))}
endwith
this.reportGroup.footerBand.TEXTRTIMECALL1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMECALL1)
height = 0.1667
left = 4.3958
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = {||num2hm(this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rTimeCall"].value}))}
endwith
this.reportGroup.footerBand.TEXTRTIMEAVG1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRTIMEAVG1)
canRender = class::TEXTRTIMEAVG1_CANRENDER
height = 0.1667
left = 5.0416
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
text = ""
endwith
this.reportGroup.footerBand.TEXTRCALLS1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRCALLS1)
height = 0.1667
left = 5.7188
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "999,999"
text = {||this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rCalls"].value})}
endwith
this.reportGroup.footerBand.TEXTRMSGS1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRMSGS1)
height = 0.1667
left = 6.3854
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "9.99%"
text = {||this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rMsgs"].value})}
endwith
this.reportGroup.footerBand.TEXTRAUTO1 = new TEXT(this.reportGroup.footerBand)
with (this.reportGroup.footerBand.TEXTRAUTO1)
height = 0.1667
left = 7.0625
top = 0.0938
width = 0.6
variableHeight = true
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "9.99%"
text = {||this.parent.parent.agAverage({||this.parent.STREAMSOURCE1.rowset.fields["rAuto"].value})}
endwith
this.firstPageTemplate = this.form.pagetemplate1
this.form.pagetemplate1.nextPageTemplate = this.form.pagetemplate1
this.form.pagetemplate1.streamframe1.streamSource = this.form.streamsource1
this.form.streamsource1.rowset = this.form.rptstats4emp1.rowset
function HEADERBAND_onRender
this.parent.nSum = 0
this.parent.nCnt = 0
return
function TEXTRTIMEAVG1_canRender
local x
x = (this.parent.parent.nSum / this.parent.parent.nCnt)
this.text = '00:' + str(x, 2, 0, '0')
return true
function TEXTRTIMEAVG1_onRender
local x
x = substr(this.text(),4,2)
this.parent.parent.parent.parent.reportGroup.nSum += val(x)
this.parent.parent.parent.parent.reportGroup.nCnt ++
return
function form_render
if type( "this.runOnce" ) # "L"
this.runOnce = true
if type( "this.reportViewer" ) == "O"
// we are being called from a reportViewer
// check to see if the reportViewer's form has
// a params array:
if type( "this.reportViewer.form.params" ) == "O"
// set params array:
this.params = this.reportViewer.form.params
// set the main title
this.PAGETEMPLATE1.TEXT2.text := this.params["Title"]
endif
endif
if type( "this.params" ) == "O" and this.params.isKey( "Details" )
this.STREAMSOURCE1.detailBand.visible := this.params[ "Details" ]
endif
endif // this.runOnce
return super::render()
endclass
function Num2HM( i )
// converts number to hhh:mm:ss
local h, m, s
h = int( i / 3600 )
m = int((i - h * 3600) / 60)
s = i - m * 60 - h * 3600
return str(h, 3, 0, ' ') + ':' + str(m, 2, 0, '0')
function Num2MS( i )
// converts number to hhh:mm:ss
local h, m, s
h = int( i / 3600 )
m = int((i - h * 3600) / 60)
s = i - m * 60 - h * 3600
return str(m, 2, 0, '0') + ':' + str(s, 2, 0, '0')
--------------050605030808080703000909--
|
|
|
