Code Comments
Programming Forum and web based access to our favorite programming groups.I know I'm doing something simple wrong; I want to get group headers
and footers on my report, but I'm getting all headers and footers on
every detail transaction. The help in report formatter is >as usual<
not adequate. The key for the file being reported is in category then
vendor order. I want vendor totals within each category, but instead
I'm getting totals on every transaction. Here is the source code: what
am I doing wrong?
Grady
Report REPORT,AT(500,1600,7000,9000),PRE(RPT),F
ONT('Arial',10,,),THOUS
HEADER,AT(500,500,7000,1104),USE(?unnamed)
STRING('Report Date:'),AT(5292,73)
END
CategoryBreak BREAK(APT:IRSCATEGORY)
HEADER,AT(0,0,,1000)
STRING(@s1),AT(6677,104),USE(APT:IRSCATE
GORY),#ORIG(APT:IRSCATEGORY)
LINE,AT(52,271,6531,0),USE(?Line2),COLOR(COLOR:Black),#ORIG(?Line2)
STRING(@s40),AT(42,42),USE(API:DESC),#OR
IG(API:DESC)
END
FOOTER,AT(0,0)
STRING(@n11.2- ),AT(4406,188),SUM(l:FinalTotal),RESET(C
ategoryBreak),USE(l:Ca
tegoryTotal),RIGHT(2),TALLY(CategoryBrea
k),
|
#ORIG(l:CategoryTotal)
STRING('Category
Total'),AT(354,250),USE(?String27),TRN,#ORIG(?String27)
END
VendorBreak BREAK(APT:VESNAME),USE(?unnamed:7)
HEADER,AT(0,0,,1000)
STRING(@s10),AT(6021,52),USE(APT:VESNAME
),#ORIG(APT:VESNAME)
LINE,AT(479,313,6281,0),USE(?Line1),COLOR(COLOR:Black)
STRING('Vendor''s'),AT(2760,375),USE(?unnamed:6),TRN
STRING('Trans.'),AT(4594,375),TRN
END
TransDetail DETAIL,USE(?unnamed:4)
STRING(@d2),AT(1938,31),USE(APT:I_TRN_DA
TE),RIGHT(1)
STRING(@s20),AT(2760,31,1521,208),USE(AP
T:INVOICE_NUM)
END
FOOTER,AT(0,0),USE(?unnamed:2)
STRING(@n11.2- ),AT(4344,83),SUM(l:CategoryTotal),RESET
(VendorBreak),USE(l:Ve
ndorTotal),RIGHT(2),TALLY(TransDetail),
|
#ORIG(l:VendorTotal)
STRING('Vendor
Total:'),AT(365,188),USE(?String28),TRN,#ORIG(?String28)
END
END
END
FOOTER,AT(500,10600,7000,396),USE(?MyFooter)
END
Totals DETAIL,USE(?Total)
STRING('Final
Total:'),AT(417,156),USE(?String30),TRN,#ORIG(?String30)
STRING(@n11.2- ),AT(4354,177),USE(l:FinalTotal),DECIMAL
(12),#ORIG(l:FinalTota
l)
END
END
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.