Let me put in a good word for Cedarville Download which I have been
using for years to export stuff into all sorts of flat files. Works
great and it free.
http://www.cedarville.edu/Offices/Information-Technology/FTP-Site.aspx
dale kelley wrote:
We generate an annual GASB depreciation report that became too big for
paper. We simply began
putting those same print lines into an export record with the column
spaces replaced by "," 's and named it as ".CSV". You need a
programmer to do this but you can generate almost any size excel file
and there are products like Nebula XL that apply excel formatting.
Would save the email recipient any manipulation.
Dale
On 02/28/2014 02:31 PM, Jeff Lettau wrote:
Without knowing exactly what you are doing, why not take a look at
ODBC and linking an excel sheet to your database and use the
powerpivot to create your report?
If you are really doing a ETL you need a tool or a programmer.
I've pulled over 300k worth of records without an issue. Although the
record set was not 200 columns, but I'd bet you could get down to
under 50 then do calculations in excel, then pivot the data to the
report.
Please note that my email address has changed. Beginning immediately
my new address is jeff.let...@soundunited.com . Use this new address
for all communications.
Jeffrey Lettau | ERP Systems Manager | O 410.358.3600 | D
410.764.5242 | 5601 Metro Drive | Baltimore MD 21215 |
www.soundunited.com
Polk Audio - WWW.POLKAUDIO.COM
Definitive Technologies - WWW.DEFINITIVETECH.COM
BOOM Movement - WWW.BOOMMOVEMENT.COM
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey
Butera
Sent: Friday, February 28, 2014 9:42 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Reporting Tools
On 2/28/14, 9:29 AM, Jeff Lettau wrote:
In the past I've made dictionary names that are very short to save
characters. But my real reason for responding is I can't help but
wonder what you need 200+ columns for? My first instinct when
hearing this is that a report is not what you need.
To be clear - this is not MY choice of report, I'm trying to explain
that they are using a "report" as a poor person's ETL tool to dump
vast amount of data to Excel and manipulate offline. But I though I'd
ask the question anyway.
How many rows are in this report?
Perhaps 10,000 - 30,000
--
Jeffrey Butera, PhD
Associate Director for Application and Web Services Information
Technology Hampshire College
413-559-5556
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
________________________________
Disclaimer: This email may contain confidential and/or privileged
information. It is intended only for the person or persons to whom it
is addressed. Any unauthorized review, use, or distribution is
prohibited. If you are not the intended recipient, please contact the
sender by reply email or telephone and destroy all copies of the
original message.
Please consider the environment before printing this email.
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users