Re: [U2] Reporting Tools

"McGowan, Ian" <[email protected]> Mon, 3 Mar 2014 17:43:58 -0800
Newsgroups gmane.comp.db.u2.general
Message-ID <9EBB4A84F18B154E923E779F972E88E3BBB7EF3DB0@33mbs001.botw.ad.bankofthewest.com>
If I have a "recall" (our terminology for a canned query) like this:



RECALL.SHELL                 Info-Trieve Shell                    03 Mar 2014

BOTW_DEV2                                                            17:38:03





    Command Name MARKETING.REP

                 Modified:   ( bytes)

                 Compiled:   ( bytes) by root



    SELECT PARAMETER

    BY MRKT.NAME

    WITH @ID = "10*]"~

    LIST PARAMETER

    UATB.MRKT.NAME

    UATB.MRKT.OFFICE



ATB  Edit  Copy  Mail  New  Run  Search  Width  Quit


I get an excel spreadsheet as an attachment like this, limited only by what excel can handle.  I've used a variety of formats over the years, but have come back to doing tab-delimited, but naming the file *.xls - that seems to be the most likely to not get mangled in transit and still open in a variety of spreadsheet programs and versions.


NAME

OFFICE

3RD PARTY SERVICER

1

AB HUSSMAN PROGRAM

4

ACCURAY, INC. PROGRAM

6






-----Original Message-----
From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Wjhonson
Sent: Monday, March 03, 2014 1:42 PM
To: [email protected]<mailto:[email protected]>
Subject: Re: [U2] Reporting Tools



Ian you don't happen to have an example of what this code *does* do you?

________________________________

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.


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