×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to Join Remedy tables using Crystal

How to Join Remedy tables using Crystal

How to Join Remedy tables using Crystal

(OP)
Hi,
Does anyone know if you can join Remedy 5.0 tables?
I'm using the  ODBC that came with the AR Remedy system.
I'm trying to join the Help_desk and the help desk audit log on incident_number using crystal reports 10.  I get an error that says column found in multiple tables. (of course that's why I want to join)

Thanks
James

RE: How to Join Remedy tables using Crystal

You cannot join Remedy tables together in Crystal and have it pull data.  You'll need to create join forms in Remedy between the sources you need combined and run reports from those join forms.

RE: How to Join Remedy tables using Crystal

Actually, you CAN join tables, but the results are hella slow.

The way to do it is to define more than one ODBC to the Remedy system.  You can add/join tables from different data sources in Crystal, and let Crystal handle the data merge.  

Just be aware that. it. is. NOT. fast.

Getting a good choke hold on the data helps...  This is not too bad if you're pulling a small set of records.  I wound up adding a parameter that will let me pick developer names and that is the main constraint we use against the Remedy tables.    Well, that and status.

This will NOT work (or work well at all) through the user tool.  I _did_ get it to work on MY machine through this kind of join, but when I tried to make the report available system wide, nobody else could get it to run even after replicating my multiple ODBC DSN trick.

Be aware, you can probably get a MUCH better response using the correct ODBC driver for your database.  You would have to do time conversion, but it's not hard.  I can float you those formulas, if you are interested.  Again, the best trick to speed reports up is to control the data / what records you bring back.  You should be able to construct a query that brings back ONLY the records you want -- in 99% of the cases.

Yell if you want to try the other ODBC method.

--
Marc Visconte
CSC
Lead RMS Developer
Crystal Reports

RE: How to Join Remedy tables using Crystal

I do it 2 ways, one just creating a join form and report off that, which is how Remedy would tell you to do it. But thats a  
pain. So what I have done like stated above is just using the native odbc driver to my database and query the view directly. You will end up having to do some leg work converting integers to strings, but you can start to post these to the server for other developers to use.

There is no speed issues with hitting the DB directly. Just get with your DBA and configure odbc and off you go, the view names are pretty darn close to the form names. One not that yo u will have to do some joining in order to get status history information to the records you are pulling, if that is what you need.

-Willy Lipford

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close