Re: Crystal Reports with ARS

[Frank Caruso]

** Remedy is basically passing Crystal a Record Set of data. You can prompt for a Crustal parameter and use it in the Selection criteria,however, it won't alter the result set. As mentioned in the last post, try and produce the desired set of data from Remedy first. Or, you can prompt for a parameter, but instead of using it in the Selection criteria of the report you could use it in Suppressing\Showing Detail sections that meet your criteria. I would opt for producing the correct record set from the User tool.

On 9/22/06, Dwayne Martin <[EMAIL PROTECTED]> wrote:

Hi Shafqat,

Try working your selection into the Qualification of the Open
Window action of the Active Link, eg:

'Assigned To' = $Assigned To$

The second "$Assigned To$" refers to the field on the local
form, and can be some other field besides "Assigned To".

Dwayne Martin
James Madison University

---- Original message ----
>Date: Fri, 22 Sep 2006 01:27:08 -0700
>From: Shafqat Ayaz < [EMAIL PROTECTED]>
>Subject: Crystal Reports with ARS
>To: arslist@ARSLIST.ORG
>
>   **
>   Hi Gang
>
>   I have written a Crystal Report, it is a very basic
>   report that runs on the HelpDesk form. The problem I
>   am having is this
>   The report is supposed to take a parameter of the
>   Assigned To name and then fetch all records for that
>   user, now when I run this report from within
>   Crystal, it works fine, but when I run it from an
>   A/L within a form, for example press a button to run
>   the report, the report comes back and asks for the
>   user name and then totally ignores it! it just
>   fetches all the record on the database. I have tried
>   all options for example Embedded, Local, and
>   Reporting Form, all do the same.
>   Environment is Oracle 9.2 ARS 5.1 Crystal Reports
>   V10
>   Any help greatly appreciated.
>
>   thanks
>
>   shafqat
>
>   Shafqat Ayaz
>
>
>
>     ------------------------------------------------
>
>   Get your email and more, right on the new Yahoo.com
>   __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

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___