Re: [U2] Reporting Tools

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 [email protected] . 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: [email protected] 
>> [mailto:[email protected]] On Behalf Of jeffrey 
>> Butera
>> Sent: Friday, February 28, 2014 9:42 AM
>> To: [email protected]
>> 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
>> [email protected]
>> 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
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>

-- 
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users