[Download-List] Having Problems with BREAK.ON and FOOTING.ON
A. J. McCabe
ajmccabe at niagara.edu
Fri Aug 17 11:08:04 EDT 2012
I got it to work...
DOWNLOAD PERBENCS DETAIL N12.PBC.HRP.LFM.NAME N12.PBC.BENE.ID.DESC N12.PBC.EMPLYE.ANNUAL.COST N12.PBC.EMPLYR.ANNUAL.COST N12.PBC.ANNUAL.BENE.COST \
HEADING FIELD.LABELS \
BREAK.SUP N12.PBC.HRP.LFM.NAME \
FOOTING.ON N12.PBC.HRP.LFM.NAME LITERAL "Employee Total "LITERAL "-----------" TOTAL N12.PBC.EMPLYE.ANNUAL.COST TOTAL N12.PBC.EMPLYR.ANNUAL.COST TOTAL N12.PBC.ANNUAL.BENE.COST \
FOOTING.ON FINAL LITERAL "GRAND TOTAL" LITERAL "-----------" TOTAL N12.PBC.EMPLYE.ANNUAL.COST TOTAL N12.PBC.EMPLYR.ANNUAL.COST TOTAL N12.PBC.ANNUAL.BENE.COST
Thanks everyone for your suggestions.
A. J. McCabe
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Topal, Alan
Sent: Friday, August 17, 2012 10:52 AM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Having Problems with BREAK.ON and FOOTING.ON
I think adding FOOTING.ON N12.PBC.HRP.LFM.NAME LITERAL '' would change the dup to a blank line.
Or you could change FOOTING.ON FINAL to FOOTING.ON N12.PBC.HRP.LFM.NAME and then add FOOTING.ON FINAL LITERAL '' to the end.
-Alan
*********************************************
Alan Topal
Programmer
University Applications Development
University at Albany, State University of NY
518-437-4546
*********************************************
From: download-list-bounces at cedarville.edu<mailto:download-list-bounces at cedarville.edu> [mailto:download-list-bounces at cedarville.edu]<mailto:[mailto:download-list-bounces at cedarville.edu]> On Behalf Of A. J. McCabe
Sent: Friday, August 17, 2012 10:29 AM
To: Cedarville DOWNLOAD Users
Subject: [Download-List] Having Problems with BREAK.ON and FOOTING.ON
Good Morning.
I have a Download that seems to be adding another line to my file.
Here is the download statement:
DOWNLOAD PERBENCS BREAK.ON N12.PBC.HRP.LFM.NAME N12.PBC.BENE.ID.DESC N12.PBC.EMPLYE.ANNUAL.COST N12.PBC.EMPLYR.ANNUAL.COST N12.PBC.ANNUAL.BENE.COST HEADING FIELD.LABELS FOOTING.ON FINAL LITERAL 'TOTAL COSTS' LITERAL '' TOTAL N12.PBC.EMPLYE.ANNUAL.COST TOTAL N12.PBC.EMPLYR.ANNUAL.COST TOTAL N12.PBC.ANNUAL.BENE.COST
And here are the results:
"Employee}Name","Benefit","Employee}Annual}Cost","Emplyr}Annual}Cost","Annual}Benefit}Costs"
"Smith, Charlie Sue","NUF1 Nuflex Medical - Part A",2400.00,0.00,$2400.00
"Smith, Charlie Sue","C315 Cafeteria Cash Credit Non-Fac",0.00,315.00,$315.00
"Smith, Charlie Sue","BL07 Basic Group Life $100,000",180.48,11.52,$192.00
"Smith, Charlie Sue","F06 TIAA-CREF RA NON-FACULTY",2750.46,7334.56,$10085.02
"Smith, Charlie Sue","LTDN Group LTD Non-Faculty",225.96,121.68,$347.64
"Smith, Charlie Sue","LTN1 Supplemental LTD Non Faculty",0.00,0.00,$0.00
"Smith, Charlie Sue","SU02 Supplemental Life - $50,000",181.20,0.00,$181.20
"Smith, Charlie Sue","SURV Survivor Benefit",0.00,0.00,$0.00
"Smith, Charlie Sue","SSC4 Supp Life Spous/Child $20/$4K",74.88,0.00,$74.88
"Smith, Charlie Sue","ACCH Supp. AD&D Child $2,500",1.92,0.00,$1.92
"Smith, Charlie Sue","ACEM Supp. AD&D Employee $25,000",9.00,0.00,$9.00
"Smith, Charlie Sue","ACSP Supp. AD&D Spouse $25,000",10.20,0.00,$10.20
"Smith, Charlie Sue","AD07 Basic AD&D $100,000",0.00,24.00,$24.00
"Smith, Charlie Sue","HNF HRA POS 226 Non-Fac Family",0.00,1200.00,$1200.00
"Smith, Charlie Sue","BN08 226 Non-Fac Family GE $43,150",1415.00,12732.04,$14147.04
"Smith, Charlie Sue","BN08 226 Non-Fac Family GE $43,150",1415.00,12732.04,$14147.04
"TOTAL COSTS","",7249.10,21738.80,$28987.90
Notice that the last two lines before the break are the same.
I have looked at the data - and there are no duplicates. The last two lines will change based on how the records are sorted.
Any help would be appreciated.
Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20120817/107a49cb/attachment.html>
More information about the download-list
mailing list