Sorry for the Off Topic nature but I need to contact an intermediate or advanced VB programmer to fix an invoice printing problem.
It seems that the system prints the wrong record. I am doing other stuff for the customer and my VB skills are not current.
With the correct record displayed on the screen and pressing the 'print invoice' button the record that had been placed on the disk last is printing. The record may even be from a different customer but it still prints that one. Like I say a small project but the customer still needs it fixed. Please contact me off list at [EMAIL PROTECTED] with and estimate.
Thanks,
Brian M.
At 12:57 PM 10/24/2003, Dan Goldberg wrote:
It looks like you need to change where these calculate to the detail section
instead of F2 and F1. Currently they only set to calculate the sum of one
detail item per breakpoint.
14: CURRENCY : F2 : mlabct = sum of mlabint
15: CURRENCY : F2 : mmatct = sum of mmatint
16: CURRENCY : F2 : mtot = mlabct+mmatct
17: CURRENCY : F1 : mlabac = sum of mlabint
18: CURRENCY : F1 : mmatac = sum of mmatint
Dan Goldberg
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kyle
Sent: Friday, October 24, 2003 8:31 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Reports
Ok. I'm still have problems with my reports. I've listed my variables below.
I am resetting mlabac,mmatac,mactot,ylabac,ymatac,yactot at the F1
breakpoint
I am resetting mlabct,mmatct,mtot,ylabct,ymatct,ytot at the F2 breakpoint
My total at the F1 breakpoint is always the same as the last F1.
I have tried resetting the other variables used to compute the above. I
have tried using separate variables to compute both areas. This worked
fine in my RB 4.5++ and before. Please tell me what I am doing wrong.
Thanks in advance. Kyle.
1: TEXT : PH : FISCOF = FISOFF IN ACCOUNT WHERE ACCTNO = ACCTNO
2: TEXT : PH : fiscbox = boxno in account where acctno = acctno
3: TEXT : PH : ACTNAM = ACCTNA IN ACCOUNT WHERE ACCTNO = ACCTNO
4: TEXT : F2 : rodes = wdescrp2 in worder where ctrlno = ctrlno
5: TEXT : F2 : descrp = actdesc in activity where actcode=wactcode
6: TEXT : D : cord = COORD from worder where ctrlno=ctrlno
7: TEXT : F2 : ccord = COORDNAM from coord where .cord = coord
8: DOUBLE : D : mlab =
(ifeq(major,210,mtdlab+mtdadj,(ifeq(major,220,mtdlab+mtdadj,mtdlab))))
9: DOUBLE : D : mmat =
(ifeq(major,210,mtdmat,(ifeq(major,220,mtdmat,mtdmat+mtdadj))))
10: DOUBLE : D : cmlabint = ((nint(100*mlab))/100)
11: DOUBLE : D : cmmatint = ((nint(100*mmat))/100)
12: CURRENCY : D : mlabint = cmlabint
13: CURRENCY : D : mmatint = cmmatint
14: CURRENCY : F2 : mlabct = sum of mlabint
15: CURRENCY : F2 : mmatct = sum of mmatint
16: CURRENCY : F2 : mtot = mlabct+mmatct
17: CURRENCY : F1 : mlabac = sum of mlabint
18: CURRENCY : F1 : mmatac = sum of mmatint
19: CURRENCY : F1 : mactot = mlabac+mmatac
20: CURRENCY : RF : mlabtot = sum of mlabint
21: CURRENCY : RF : mmattot = sum of mmatint
22: CURRENCY : RF : gmtot = mlabtot+mmattot
23: CURRENCY : D : ylab =
(ifeq(major,210,ytdlab+ytdadj,(ifeq(major,220,ytdlab+ytdadj,ytdlab))))
24: CURRENCY : D : ymat =
(ifeq(major,210,ytdmat,(ifeq(major,220,ytdmat,ytdmat+ytdadj))))
25: DOUBLE : D : cylabint = ((nint(100*ylab))/100)
26: DOUBLE : D : cymatint = ((nint(100*ymat))/100)
27: CURRENCY : D : ylabint = cylabint
28: CURRENCY : D : ymatint = cymatint
29: CURRENCY : F2 : ylabct = sum of ylabint
30: CURRENCY : F2 : ymatct = sum of ymatint
31: CURRENCY : F2 : ytot = ylabct+ymatct
32: CURRENCY : F1 : ylabac = sum of ylabint
33: CURRENCY : F1 : ymatac = sum of ymatint
34: CURRENCY : F1 : yactot = ylabac+ymatac
35: CURRENCY : RF : ylabtot = sum of ylabint
36: CURRENCY : RF : ymattot = sum of ymatint
37: CURRENCY : RF : gytot = ylabtot+ymattot
[EMAIL PROTECTED]
