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
LVL 1
alikat538Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

alikat538Author Commented:
Update:
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 :)
0
alikat538Author Commented:
Figured out how to use the Remedy reports --- not great, but it gets the job done.  Requesting to be closed
0
GranModCommented:
Closed, 300 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.