Hi Folks... I though I would post this - for others who might find themselves in a similar position.
Here is quick and easy way to pass parameters to Crystal reports. 1) Create your own console and add the following fields: - Server Name - Form Name - Default View - Report Name - Query - Selected IDs 2) Create your Crystal Report and store it in the Remedy form called Report 3) Create an active link that executes an Open Window Action. 4) Use Sample Data in the Open Window Action and use the fields shown in item 1) as variables that are passed to Crystal. 5) In the active link qualification use the External command to pass the Query field value to Crystal Reports. 6) In the User Tool create queries that you need by using the Advanced Query Line - then copying this qualification to the Query field. 7) For this to work - make sure that you select Query Override in the Open Window Command. Whatever query you pass will act as though you selected the form and placed the query in the Advanced Query line... I tried this and it appears to work ... Note: I am using the Developer Studio to do this. This feature was available from 6.3 and up, but it was a bit more complex to execute. On Sep 17, 6:55 am, Elry <elryal...@gmail.com> wrote: > 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 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"
