Resetting records.

2009-11-12 Thread Alexander Straph
Hello.

Trying to find out if there is a run process out there that resets a record.  
Now, I know that the command PERFORM-ACTION-APPLY simply commits a record to 
the database, but wondering if there is a similar command that reverts a record 
to its original state.  Kind of like pressing F5 to refresh a record.  The 
client wants a function to revert the record to its previous state or to load 
updated information from the form.

Thanks.



  __
Connect with friends from any web browser - no download required. Try the new 
Yahoo! Canada Messenger for the Web BETA at 
http://ca.messenger.yahoo.com/webmessengerpromo.php

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Difference in APP-Management and APP-Support for ITSM 6.3 and 7.0

2009-11-09 Thread Alexander Straph
Hello.

Can anyone tell me the difference between APP-Management and APP-Support?  In 
6.3, the APP-Management permission would give you access to the Remedy 
Management Console, whereas APP-Support would only have the Support Console.  
(And what is the difference between these two consoles anyway)

And I think that these permissions are outdated in 7.0 but not sure, can anyone 
elaborate?

Sorry for the dumb questions but my mind has just been stalled (must be the 
weather) and would like a quick answer.

Thanks.


  __
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Complicated Crystal Report

2009-10-29 Thread Alexander Straph
To all Crystal Report Developers out there.

I have been tasked to create what appears to be a very complicated report for a 
client using 7.0.

They want to display a crystal report of a single Change Record.  However, the 
problem is that they want this report to display the following:

1) information of the assets of the attached to the change (not just the info 
on the association record, they are looking for the product categorization of 
these assets)
2) all of the worklogs attached to the change
3) all of the approvers attached to this change
4) all of the tasks attached to this change.

I know that there are join forms between Change-Association, Change-Worklog, 
and Change-Approver.  I haven't been able to find the one for Change-Task but I 
think its there.

Initially, I was thinking of combining the four joins into one join form 
containing a few fields from each of the other 4.  But this poses a problem 
trying to group the entries.  I know that Change ID will likely have to be 
the main group, but how to split all the association, worklog, approver, and 
task data into their own subgroups?  Does anyone else have an alternate 
approach rather than the superjoin?

As for trying to add information regarding Asset Categorization, I figure 
adding the categorization fields to the CHG:Association form and having 
workflow populate may do the trick, then bringing those fields into the 
Change-Association Join, unless anyone has a better idea on how to do this.


  __
Make your browsing faster, safer, and easier with the new Internet Explorer® 8. 
Optimized for Yahoo! Get it Now for Free! at 
http://downloads.yahoo.com/ca/internetexplorer/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Date To Text

2009-10-19 Thread Alexander Straph
Hello.

What is the best way to convert Date to Text?  I'm trying to save timestamps on 
character fields for processing later.  I know that Date is stored as an 
integer but is there a function in which I could save the text form of the date?

Thanks


  __
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your 
favourite sites. Download it now
http://ca.toolbar.yahoo.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Crystal Reports compatibility for AR 6.3

2009-10-16 Thread Alexander Straph
I am trying to create some reports on an AR 6.3 server.  From what I have been 
told, you need Crystal Reports 9 for this to work.  We are in the process of 
trying to obtain Crystal Reports 9 but I have been told that it will take some 
time.  One option is that we would be looking for a 6.3 evaluation version for 
us to use in the short term until we can obtain an actual copy of version 9.  
Does anyone know where to get this?  The Business Objects website only has the 
newest versions of Crystal reports.

This brings me to my next question: I was wondering if newer versions of 
Crystal will work with 6.3, and what is the availability of those versions?  
I'm not sure if just going with Crystal 2008 is the right way to go.

Thanks.

Alex.


  __
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Real to Integer Comparisons

2009-10-09 Thread Alexander Straph
Hi.

The client has a set up where they have a field called SequenceNumber.  This 
field is a decimal number set to a precision of 2.

The reason for this is because they have subsequence numbers, that is it goes 
like 1, 2, 3, 3.1, 3.2, 3.3, 4.

The entries are being grouped by whole number, that is 3, 3.1, 3.2, 3.3 would 
belong to one group.  But how to check for such numbers?

One idea that I floated was to use the TRUNC function to get the numbers to 
round down.  Then compare the sequence numbers against the truncated number, if 
they are between the truncated number and the number + 1, then that is a record 
that you're looking for.

The problem that I have is that such a comparison is likely to trigger a type 
mismatch error.  Comparing a real to an integer is not supported in any ARS, is 
it (I'm using 6.3)?

Anybody got any ideas on how to do this?


  __
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are


Field 112 and ARS 6.3, how does it work?

2009-09-30 Thread Alexander Straph
Is there any way to include multiple groups on field 112 to restrict access to 
entries on a system with ARS 6.3?  I know 7.0 allowed you to put multiple 
groups in but I have tried with 6.3 without much success.

Thanks.


  __
Looking for the perfect gift? Give the gift of Flickr! 

http://www.flickr.com/gift/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are