You should be able to point the Crystal report to HPD:Search-Worklog. This is the join between HPD:Help Desk and HPD:Worklog and should have the fields needed to report from both. If not you can add them to this join.
Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Levenseller Sent: Thursday, November 29, 2007 4:17 PM To: [email protected] Subject: Creating a Crystal Report to display Work Info in ARS and ITSM 7 I'm trying to create a Crystal Report (ver 10) that will display some of the incident information (incident #, submitter, Arrival Date, ..) and also the Work Info Detailed Description. I can get it to display the fields from the HPD:Help Desk or the HPD:Worklog separately but not if I join them in the same report. I know I'm missing something that is probably right in front of my face but I just can't see it. Any suggestions? Thank you very much, David Levenseller [EMAIL PROTECTED] ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

