Re: [U2] Reporting Tools

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