Louie,
import the report on universe into excel and either run a macro to stip
out the headings or suppress them
jak
----- Original Message -----
From: "IT-Laure Hansen" <[EMAIL PROTECTED]>
To: <u2-users@listserver.u2ug.org>
Sent: Wednesday, February 13, 2008 11:32 AM
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: u2-users@listserver.u2ug.org
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/