Connecting ARS Remedy to MS Access
Posted on 2006-04-21
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