Connecting ARS Remedy to MS Access

Posted on 2006-04-21
Last Modified: 2008-01-09
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
Question by:alikat538
    LVL 1

    Author Comment

    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 :)
    LVL 1

    Author Comment

    Figured out how to use the Remedy reports --- not great, but it gets the job done.  Requesting to be closed

    Accepted Solution

    Closed, 300 points refunded.
    The Experts Exchange
    Community Support Moderator of all Ages

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now