What about writing a standard BASIC report that would prepare CSV lines for the subtotals (DET-SUPP).
Many reports I create offer S=Screen, P=Printer and/or D=Download output choices. Same lines, different destination. I'll re-iterate one of TonyG's suggestions with creating and eventually exporting a CSV. Unless you are using WRITESEQ, having a large CSV 'record' inside a program may encroach on some speed and/or handling problems. Tony's suggestion was to have PRINTER ON and under the Hold and Suppress option, 'print' each row instead of X<-1> appending. When you are complete, manage the &HOLD& record accordingly. I use this method when the resulting CSV (or EDI as well) record may be over 100,000 rows. Otherwise X<-1> works acceptably. Actual mileage may differ. My 1 cent Mark Johnson ----- Original Message ----- From: "IT-Laure Hansen" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, February 12, 2008 7:32 PM Subject: RE: [U2] Excel downloads > Hi Louie, > > You are correct, it does - however I am dealing among others with a set > of files that contain about 85000 individual records: too much for Excel > in the first place, and also, updating the MITS data source takes simply > too much time, especially when adding break/sort fields. A simple > Universe report using DET-SUP takes a couple of minutes to run. The > equivalent using MITS Reports with a data source update to grab the > latest data literally takes hours. So, I am looking for a solution that > allows me to do the equivalent of a LIST DET-SUP in Universe, and > convert the output into true Excel. > > Thanks, > > Laure Hansen, > City of Redwood City > Information Technology > 1017 Middlefield Road > Redwood City, CA 94063 > Tel 650-780-7087 > Cell 650-207-3235 > Fax 650-556-9204 > [EMAIL PROTECTED] > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel > Sent: Tuesday, February 12, 2008 3:36 PM > To: [email protected] > Subject: Re: [U2] Excel downloads > > Laure, > > MITS Reports does export detail-suppressed information to an Excel > spreadsheet. > Just > > - click on column heading, then > - click Display Totals, then > - add a break on the field you want totaled. > - click the Suppress Details tab > - export to Excel > > > Louie Bergsagel > North Coast Electric > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
