If you're using Remedy's ODBC driver, you'll need to create a join form that contains both HPD:Help Desk and HPD:Worklog and link on the incident fields. If you're using an ODBC driver to the database you just need to create a left outer join link from Incident on HPD:Help Desk to Incident on HPD:Worklog.
Ben Cantatore Remedy Administrator Avon (914) 935-2946 David Levenseller <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 11/29/2007 04:16 PM Please respond to [email protected] To [email protected] cc 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"
