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"
