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"
