Laure, How about XML?
You can take the output of a LIST/SORT and add TOXML at the end to generate XML. Then print to a HOLD file (&HOLD&), pick it up and import into MS-Excel. MS-Excel will import XML in a number of forms, including as a sort-able list. It you setup a schema at both ends, then you should be able to get the exact format that you want. Getting info into MS-Excel has always been an issue - careful use of the XML in U2 and MS-Excel may hold the key... Mmmm, worthy of an article... Cheers, David Murray .learn and do .excel and share -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Tuesday, February 12, 2008 7:32 PM To: [email protected] 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/
