Hi Rod... Thanks buddy.
We will try using subreports. The only other technique I have read about is to create a table that stores the selected report number - then use a join to generate the desired results. I was looking for a cleaner way to do this...and it looks like subreports might do it... Thanks Again. On Sep 16, 10:25 pm, Rod Harris <r...@smapps.com.au> wrote: > I hope I understand what you are trying to do. > > As far as I know you can't pass parameters to crystal as such. You can > allow the crystal report to ask for parameters and you can control the > report by specifying the record selection query in the open window > action.This is fine in most cases. There are some occasions where this > is not sufficient. > > One feature I use to simulate passing parameters from Remedy to > Crystal is the use of subreports. If you place your report inside > another report as a subreport, parameters can be passed to the > subreport from the wrapper report. These paramaters are typically used > to build the record selection query. Using this technique you can get > a lot of control of your report from Remedy. > > In simple terms you can call a crystal report with a qualification > that acts as a parameter. You then use this qualification to construct > the real report qualification inside the subreport. In the subreport > you have access to the paramater as well as a record selection derived > from it. Without doing something like this you can have a tough time > trying to work out what the report is trying to show from the results > returned by its qualification. > > I hope this makes some sense to you. I'm assuming that you know about > crystal subreports. If you don't it's worth learning about them as > they are a very useful feature. > > Rod > > On 17/09/2009, Elry <elryal...@gmail.com> wrote: > > > > > Hi Folks.. > > > Environment: > > > SQL Server 2005 > > Windows Server 2003 > > ARS 7.5.2 > > Crystal Reports XI > > > Issue: > > > How do you pass a a simple parameter like Request ID to a Crystal > > report to ensure that you can generate a fixed report from a Dialog > > form. > > > Any ideas. > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"