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