Member_2_789126
asked on
Connecting ARS Remedy to MS Access
I am using ARS Remedy Version 4.05.02
at the end of the day I would like to be able to generate a report on all the tickets I opened for the day. I am having trouble generated reports in remedy (I can do searches but can't get a report view).
If I can't get it to work in Remedy, I'd like to pull the information into MS Access 2003
I believe I have to do something with ODBC or DSN connection? (don't know anything about creating this so I'm not even sure if I am saying it right)
I need someone to walk me through generating a report either in Remedy or MS Access
Also, is there a variable "TODAY" --- date didn't seem to work, when I get this going I want to create a macro to run at the end of the day so I don't want to hard code the date.
Other information --- I am a remedy end-user...don't have access to the server...but I do know the server name if I need it to create a connection.
Thanks in advanced
at the end of the day I would like to be able to generate a report on all the tickets I opened for the day. I am having trouble generated reports in remedy (I can do searches but can't get a report view).
If I can't get it to work in Remedy, I'd like to pull the information into MS Access 2003
I believe I have to do something with ODBC or DSN connection? (don't know anything about creating this so I'm not even sure if I am saying it right)
I need someone to walk me through generating a report either in Remedy or MS Access
Also, is there a variable "TODAY" --- date didn't seem to work, when I get this going I want to create a macro to run at the end of the day so I don't want to hard code the date.
Other information --- I am a remedy end-user...don't have access to the server...but I do know the server name if I need it to create a connection.
Thanks in advanced
ASKER
Figured out how to use the Remedy reports --- not great, but it gets the job done. Requesting to be closed
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I got the DB to connect in MSACCESS and created a query because our remedy DB is pretty large.
The query should be relatively small --- less than 10 records
So then I tried to a query to pull only the first record so that I could see it was actually pulling in the data --- it still doesn't respond. It actually crashes and I have to close Access.
I know it is connected cause it asks for my username / password and the fields are correct on the table.
Help :)