Re: [U2] Reporting Tools

If you're not already, it's a really good idea to consider creating something that will make producing excel files (the number one choice of accounting groups everywhere) from your "reports" easily.  Many years ago we used to physically print a bunch of reports each night, but since creating a tool the users can easily use, almost everything is electronic.

http://www.pickwiki.com/cgi-bin/wiki.pl?DumpRecall shows one way to do it, though it's pretty specific to our needs.  It wouldn't be hard to use this as inspiration for something that works in your own environment.  I'd forgotten about the 150 field limit in unidata, but this comment remembers:

    * We have a list of field names and a select, parse them the hard way
    * and write a tab-seperated file.  This is slower but avoids limitations
    * on the number of columns (of unidata) and the perl module WriteExcel


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of jeffrey Butera
Sent: Monday, March 03, 2014 1:05 PM
To: U2 Users List; [email protected]
Subject: Re: [U2] Reporting Tools

On 3/3/14, 4:01 PM, Daniel McGrath wrote:
> Hi Jeff,
>
> In case you missed it before:
>
> " Does your query use the LIMIT keyword? This is an internally hardcoded limit that was increased, IIRC, in 7.3.6 to 250."
>
> On further checking, here is the issue, along with fix version. I suggest you update to the latest UDT version.
>
> UDT-4284 -> Request for UniQuery hard limit of 150 attributes (in LIST 
> or REFORMAT commands) to be increased
>
>   A change was made to increase this to 250 attributes in 7.3.5. The actual limit has now been added to the report from the LIMIT verb so you can see limitation as "U_ATTRLIST"

Thanks Dan - this helps immensely.


--
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
-----------------------------------------
IMPORTANT NOTICE:   This message is intended only for the addressee
and may contain confidential, privileged information.  If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message.  If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users