Agreed, you can also use the Suppress functionality to tidy the report where no information is returned.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: 30 October 2009 5:30 AM To: [email protected] Subject: Re: Complicated Crystal Report I think you will find using sub-reports in Crystal will be your best friend for this type of reporting. Print the details of the change record first and then use a sub-report for each section:worklogs, approvers, tasks, assets, etc... On Fri, Oct 30, 2009 at 8:19 AM, Alexander Straph <[email protected]> wrote: > To all Crystal Report Developers out there. > > I have been tasked to create what appears to be a very complicated report for a client using 7.0. > > They want to display a crystal report of a single Change Record. However, the problem is that they want this report to display the following: > > 1) information of the assets of the attached to the change (not just the info on the association record, they are looking for the product categorization of these assets) > 2) all of the worklogs attached to the change > 3) all of the approvers attached to this change > 4) all of the tasks attached to this change. > > I know that there are join forms between Change-Association, Change-Worklog, and Change-Approver. I haven't been able to find the one for Change-Task but I think its there. > > Initially, I was thinking of combining the four joins into one join form containing a few fields from each of the other 4. But this poses a problem trying to "group" the entries. I know that Change ID will likely have to be the "main" group, but how to split all the association, worklog, approver, and task data into their own "subgroups"? Does anyone else have an alternate approach rather than the "superjoin"? > > As for trying to add information regarding Asset Categorization, I figure adding the categorization fields to the CHG:Association form and having workflow populate may do the trick, then bringing those fields into the Change-Association Join, unless anyone has a better idea on how to do this. > > > __________________________________________________________________ > Make your browsing faster, safer, and easier with the new Internet Explorer® 8. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/ > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
