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"
Re: Creating a Crystal Report to display Work Info in ARS and ITSM 7
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: arslist@ARSLIST.ORG 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"
Re: Creating a Crystal Report to display Work Info in ARS and ITSM 7
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)" 11/29/2007 04:16 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG 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"
Re: Creating a Crystal Report to display Work Info in ARS and ITSM 7
Hi David, The easiest way is to use a sub-report within Crystal that links on the Help Desk Request ID. I built a report that includes all of the details -- SLAs, Relationships, Work Info, etc with separate sub reports for each of the other details. Then I replaced the out of box report (Print on HPD:Help Desk form) with my new one. HTH Cheers Katie Hutton -Original Message- From: David Levenseller [mailto:[EMAIL PROTECTED] Sent: Friday, 30 November 2007 10:17 a.m. 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"
Re: Creating a Crystal Report to display Work Info in ARS and ITSM 7
Hello David. From my point of view, either sub-report or a join form could do the trick. But it depends what you are facing. Like your case, you may consider HPD:Help Desk and Incident Work info are directly linked by the incident id. So you can insert a sub report in your report easily. You may find a existing example right in your installed OTB reports. OTOH, I would suggest using join form when anyone want to show the related solution database information in a problem investigation ticket. Because there's a associate form between problem investigation and solution db. You need to deal with 3 forms in the crystal designer. So I prefer creating a join form something like (A join B) join C, put fields you need together in the same form then create a Crystal Report file against the join form. Hope this could help a little bit. DJHuang On Dec 1, 2007 3:41 AM, Katie Hutton <[EMAIL PROTECTED]> wrote: > Hi David, > > The easiest way is to use a sub-report within Crystal that links on the > Help > Desk Request ID. I built a report that includes all of the details -- > SLAs, > Relationships, Work Info, etc with separate sub reports for each of the > other details. Then I replaced the out of box report (Print on HPD:Help > Desk form) with my new one. > > HTH > > Cheers > Katie Hutton > > -Original Message- > From: David Levenseller [mailto:[EMAIL PROTECTED] > Sent: Friday, 30 November 2007 10:17 a.m. > 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" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
