Re: [U2] Reporting Tools

We create a lot of delimited flat files at a Unix level. Then we ftp them to the windows side of the network. The ftp process generates an email to the user with a link to the file we just put on the LAN.   The users can then open it up using the email link in Excel and do  what they want.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Lettau
Sent: Friday, February 28, 2014 8:29 AM
To: U2 Users List
Subject: Re: [U2] Reporting Tools

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.
How many rows are in this 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:22 AM
To: U2 Users List
Subject: [U2] Reporting Tools

I'm looking for feedback from those in any industry about your report needs with U2 and what tools you use to solve them.  In short, Entrinsik has serious inroads in the academic community and Informer is a reasonably good and inexpensive tool for most reports.

However, we are running into issues with some users like to write large reports.  Large, by out standards, are reports with 200+ columns in the output.

Are others writing reports with this many output fields?  If so, are you ever running up against limits in the sentence size (U_SENTLEN)?  Our limit is about 9700 chars and we have some reports hitting this limit.
I'm having a hard time explaining to some VP types that the database can't handle this size report...

Any feedback is welcome.

--
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

------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this email in error,
please immediately notify the sender by e-mail at the address shown. 
This email transmission may contain confidential information.  This
information is intended only for the use of the individual(s) or entity to
whom it is intended even if addressed incorrectly.  Please delete it from
your files if you are not the intended recipient.  Thank you for your
compliance.  Copyright (c) 2014 Cigna
==============================================================================

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users