Rebecca,
Hum. Not a Remedy Developer on that server huh? (Been there, hated
it.. :)
I normally do not suggest this approach as it can be a "long way
round the barn", but it can work under the conditions you are forced to
work with.
I see your options as these:
1) Either go to those who are Remedy Developers on that server and give
them a case of Beer (or whatever beverage they desire) and get them to help
you out.
OR,
2) Don't use the Remedy User tool. (There are other "clients", so use
them.)
A) Write a JavaAPI based servlet/web application and let your users use it
to do the reporting.
(Since you described your work as "setting up a reporting system" This
may be your best bet with out the help of a Remedy Developer on that
server.)
B) If a command line interface is acceptable then I would suggest an
ARSPerl script.
C) If a command line interface is not acceptable then go to VBA (from
Excel) and use some of the VBA --> C API (COM module?) that is available.
D) You mentioned a Crystal Reports function. Why not use that (ODBC)
client?
The root problem is that the macro language is just not very
flexible. [Not to mention that Macros are in a mode of "do not use them"
because the vender has replaced the functionality with other constructs and
is very unlikely to continue to support it for much longer. ] What your
trying to do really does require some "client side programming". In ARS
programming constructs most closely maps to fields. (AKA: a programming
variable = ARS field) If you can not add new variables then you can not do
much in the way of programming at the client level in the User tool.
However there are other client environments that will allow you to make
variables and use true programming constructs. :)
Oh, Why did I not think of this sooner....
3) If you do have Remedy Developer writes on a different server.... (and
you are a Remedy Developer) then see if you can get a def file from the
application. (Again, see those who do have admin writes on the server in
question.) Then build a set of forms that do the reporting you want without
altering the existing application. Then beg/borrow and plead for the admins
to import your forms. :) That way you ask "them" to do two things (Export,
then later import) and your "reporting application" should be "stand alone"
and not interfere with their application.
3.a) If you get really tricky, then you might be able to "hack" your def
file and point the objects at the other server too. Maybe... then your
users can use your ARS server and application to get data from the "other
server". Your users will need access to the "other server" and the account
names and passwords will need to match. However those details should be
possible. [Assuming that you can alter the objects on your server to point
at a server that you do not have admin access on. I think that is possible.
Hum....]
Hope that helps. (some)
Good luck.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS=Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
"Rebecca Hammond"
MARSH.COM> cc:
Sent by: "Action Subject: Re: "Last Full Month" query options in Remedy?
Request System
discussion
list(ARSList)"
ORG>
12/31/2002 07:08
AM
Please respond to
arslist
Matt/Joel,
Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I
have access to the server (for this project, I'm just setting up a
reporting system, and since the Remedy applications are owned by a
different division of the company (read - politics), I'm forced to come up
with solutions that don't actually involve remedy development). That's why
I was hoping there was some sort of query syntax that I could actually use
within the Remedy User tool?
Thanks,
Rebecca
On Mon, 30 Dec 2002 14:15:25 -0800, ARSLIST
wrote:
>Rebecca,
>Here's an all-ARS approach:
>
>1. Use two temp fields: $mm$ and $yy$
>
>2. In a Link or filter:
> If $Month$ = "January"
> Then $mm$= 13
> $yy$= ($year$ - 1)
> Else $mm$= $month$
> $yy$= $year$
>
>2. Report Start-date = ($mm$-1) / 1 / $yy$
> End-date = $month / 1 / $year$
>
>HTH,
>Joel
>
>QMX Support Services, Inc.
>Joel D. Sender,
>Director of Western Operations
>
>
>
>
>-----Original Message-----
>From: owner-arslist@arslist.org [mailto:owner-arslist@arslist.org]On
>Behalf Of Rebecca Hammond
>Sent: Monday, December 30, 2002 9:32 AM
>To: ARSLIST@ARSLIST.ORG
>Cc: Rebecca Hammond
>Subject: "Last Full Month" query options in Remedy?
>
>
>Hi listers,
>
>Here is my dilemna - I need to run a query in Remedy that returns records
>with a Create Date that falls in the Last Full Month (exactly like the
>Crystal Reports function of the same name). This means, although today is
>the 30th of Dec., the query would only return records created between 11/1
>and 11/30. Also, I don't (i.e. can't) hard-code dates into this query,
nor
>do I want the end-user to type them in. Ideally, I'd like to do this
>through the Client tool (advanced search), and unfortunately, I don't have
>development rights to the schemas I'm working with, so I can't construct
>any workflow to do anything like this.
>
>Any suggestions?
>
>Thanks,
>Rebecca Hammond
>
>
>
>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS
>THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
>eMail to support@arslist.org
>
>
>You may control your subscription options, including UNSUBSCRIBE,and
ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please
send eMail to support@arslist.org
Matt/Joel,
Thanks for the replies...both options would absolutely do the trick, but
unfortunately, I have no access to Remedy as an Administrator, nor do I
have access to the server (for this project, I'm just setting up a
reporting system, and since the Remedy applications are owned by a
different division of the company (read - politics), I'm forced to come up
with solutions that don't actually involve remedy development). That's why
I was hoping there was some sort of query syntax that I could actually use
within the Remedy User tool?
Thanks,
Rebecca
You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send
eMail to support@arslist.org
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org
Previous Topic
Index