Another approach: Base your crystal report on your launching form, which must be a database form. Have a field on this form called "tickets assigned to:". Your CR will have "tickets assigned to:" as a sub-report link. Then base your sub-report on the form you want to pull your data from. Your active link will give an error message if there is no value in "tickets assigned to:", and will save (commit) the entry before launching the Crystal Report.
The trouble with this approach is that the report you really want is a sub-report, and you can't have sub-sub-reports. ---- Original message ---- >Date: Mon, 24 Jul 2006 09:12:35 -0400 >From: Frank Caruso <[EMAIL PROTECTED]> >Subject: Re: Crystal parameters reports >To: arslist@ARSLIST.ORG > > ** Create the parameter in Crystal. Go to the > Section Expert for the Detail section and create a > formula to use for Suppressing a row. Use the > parameter in the formula. Save the report and link > into your ALink (or add to Report form). Run the > report from the user tool and you should see a > Crystal prompt. > > Now, this will filter down based on your parameter > but the entire record set will be read into memory. > > On 7/24/06, Rusconi, Ignacio (I.) > <[EMAIL PROTECTED]> wrote: > > I wanted to run from an active link but I want > Remdy/Crystal to ask the user for a parameter. > > For example: I want all tickets assigned > to somebody. > > I want Remedy/Crystal to ask: > > tickets assigned to: XXXXXX (user enter > a username.) > > Thanks you! > > -----Original Message----- > From: Action Request System discussion > list(ARSList) [mailto:[EMAIL PROTECTED] On > Behalf Of Michiel Beijen > Sent: Monday, July 24, 2006 4:10 AM > To: arslist@ARSLIST.ORG > Subject: Re: Crystal parameters reports > > Ignacio, > > This depends, do you want to run the report from > an active link or > from the ITSM Report Console? > > As you might know, if you want to run a Crystal > Report from Remedy it > will override the already existing query in > Cristal. You can pass the > selection criteria in the Query Override in the > Open Window active > link or if you want to run the report from the > Report Console, store > the qualification in the Report form. > > Kind regards, > > Michiel > > On 7/21/06, Rusconi, Ignacio (I.) > <[EMAIL PROTECTED]> wrote: > > ** > > > > > > Please could you indicate if there is > anyway to give Crystal a > > parameter when you open the report via remedy > > I know there is the item Create > Parameter but only can be used If > > you execute the report with Crystal > > > > I mean I wanna get for example all the > tickets open by "a" (take > > this as an example. I know I can QRY this with > QRY tool Remedy) > > > > but this filter I wanted to be done over > the Crystal report embedded > > in Remedy > > > > > > Remedy 5.01 > > Crystal 9-1 > > Sql 2000 > > > > Thanks in advance > > > > > > > > Ignacio G. Rusconi > > Data Base Administrator > > > > Ford Argentina-TeleTech > > > > :.4756-9367.: > > > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > Web. http://pacheco.ba.ford.com/pl/9898 > > > > ¿Sentiste un Ford últimamente? > > > > STRICTLY CONFIDENTIAL. The contents of this > e-mail and any attachments are > > strictly confidential and property of Ford > Argentina S.C.A. They may not be > > used or disclosed by someone who is not a named > recipient. If you have > > received this e-mail in error please notify the > sender by replying to this > > email inserting the word "Misdirected" as the > message and delete the present > > message. __20060125_______________________This > posting was > > submitted with HTML in it___ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > > -- > Frank Caruso > Specific Integration, Inc. > Senior Remedy Engineer > www.specificintegration.com > 703-376-1249 __20060125_______________________This > posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org