Bruce, I just reread the post and I realized that I misunderstood what you're trying to achieve. Ok, I'd use this solution, hopefully someone else has a better suggestion as I think this solution is a bit clumsy. I can't think of a way to directly pass what parameters the user is using to the report, however, I think you could store that information in another form in a character field. Then in a subreport display the information from that character field.
Ben Cantatore Remedy Administrator Avon (914) 935-2946 Dwayne Martin <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 12/10/2007 10:17 AM Please respond to [email protected] To [email protected] cc Subject Re: How can I display User parameters on Crystal Report We have a control panel with a single record. The parameters we want to display and select records by are usually date ranges. So we have the begin and end dates as input fields on the control panel. Since the end date is actually midnite at the beginning of the day, we also have an "Actual end date" field. When we click on the "Report" button an active links adds 86400 (the number of seconds in a day) to the display end date to get the actual end date, then saves the record, to put it into the database. It then it launches a CR based on the control panel, with the secondary form data as a sub-report, with records selected by control panel begin date and actual end date. This can be limiting because you might want to include yet another form as the sub-report to the secondary form, and you can't have sub-sub-reports. So you can create a join form with your control panel and your secondary form and base your CR on that, then have your tertiary form as the sub-report. If this sounds confusing feel free to write me offline. Dwayne Martin James Madison University ---- Original message ---- >Date: Mon, 10 Dec 2007 09:30:24 -0500 >From: "Wilson, Bruce B" <[EMAIL PROTECTED]> >Subject: How can I display User parameters on Crystal Report >To: [email protected] > > ** > > I would like to know if there is a way to pass > parameters (for example the parameters the user > selected on a dialog window) to a Crystal Report and > have them displayed on the Crystal Report called > from Remedy. > > > > Having fought the gritty never-ending battle to > produce Crystal Reports that don't fail when called > from Remedy or after migration require massaging, I > am starting to wonder if I would be better off using > SQL Server Reporting Services as a replacement for > Crystal Reports technology. > > Too long I find myself hanging on to what seems to > be counter-productive "rapid application > development" tools. > > > > Realizing I can't [currently] just pass parameters > to a Crystal Report and have them displayed really > paints a good picture for me of how inadequate it > is. > > > > > > Does anyone have any success stories they'd like to > share using Reporting Services and how difficult to > transition to the technology? > > I am using SQL Server 2005. > > > > Thank you, > > Bruce Wilson > > Norfolk Southern Corporation > > C&S Remedy Administrator > > > > __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ 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"
