Two things. First I tend to agree with the number of columns. Perhaps the 
report is trying to do more than just a couple of things. Consider evaluating 
the various uses of this report and producing more, smaller reports that 
provide only what the needs are.

Second, I'm a programmer so I just program all of my reports. Columns and rows 
are really just one big long string with a variety of delimiters. If you are 
producing reports at TCL then a programmer could make that very easy.

David Laansma
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
"Delivering Products, Services and Innovative Solutions"

-----Original Message-----
[] On Behalf Of Jeff Lettau
Sent: Friday, February 28, 2014 9: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 .  Use this new address for all 

Jeffrey Lettau  |   ERP Systems Manager  | O 410.358.3600  |   D 410.764.5242   
|   5601 Metro Drive   |   Baltimore MD 21215   |
Definitive Technologies - WWW.DEFINITIVETECH.COM BOOM Movement - 

-----Original Message-----
[] 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

U2-Users mailing list


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

Reply via email to