Yet another approach (and you are probably feeling bombarded by now) is to have a contol panel with a single record from which you launch your reports. You have your selection criteria as fields on your control panel. Then base your report on the control panel, with the other form data as a subreport.
Eg, you have the "Assigned To", "Begin Date", "End Date" etc in the control panel. You have a button that launches an active link that first saves the data in the control panel, then launches the report. The problem with this approach is that your "other" form is now in the subreport, and Crystal doesn't allow sub-sub-reports (at least Crystal 9 doesn't, does anybody know about CR 11?). If you need to bring in data from yet a third form you can often create a join between it and the second form. That too gets complicated but it is usually do-able. Dwayne Martin James Madison University ---- Original message ---- >Date: Sun, 24 Sep 2006 18:44:53 -0400 >From: Mark Boyle <[EMAIL PROTECTED]> >Subject: Re: Crystal Reports with ARS >To: [email protected] > >"I haven't done this and it might not be worth the effort, but what if you >were to create a small, hidden form that stored the start/end dates. When >the user enters start/end dates, push the values over, then open your >report. Add a sub-report to your Crystal report to extract those values >and you have the actual date range for displaying." > >The approach suggested by Thad is what I have implemented. This method >allows us some flexibility to display any parm values used in the >qualification passed to each Crystal report. > >regards, Mark > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
