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"
