When I had to do something like this, here's what I did. I'm sure there
are better ways. I created an "Advanced Search" form that could do a
key word search across all ticket types, so I was searching one form
from another.
Put a hidden character field on the form. For each field that's not
$NULL$, put "'FIELD1' LIKE ("%" + $FIELD1$ +"%") AND " into the
character field.
Basically, your run if is FIELD1' != $NULL$, and do a set fields to the
hidden field. Repeat this for all your searchable fields, setting them
all to increasing execution order numbers.
The final active link can strip out that final "AND " thusly:
LEFT($Search Criteria$, LENGTH($Search Criteria$) - 4)
You can push the results to run your report, or display them on a table
on the form.
Like I said, I'm sure someone has a better way, but this worked for me.
Chris Moore
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, August 03, 2007 1:15 PM
To: [email protected]
Subject: Re: Report on Results (UNCLASSIFIED)
Thanks for the response.
The problem is that I don't know what the qualification is. The users
may use
the advanced search bar, or type directly into the fields. Is there some
way to
pull the qualification used to get the current results?
Thanks again
Les Ganton
> Classification: UNCLASSIFIED
> Caveats: NONE
>
> Typically, this is done with an Open Window (Report) active link, and
> you can pass the search criteria to the "Qualification" line for the
> report.
>
> Note: Often when I try this method, the report generation will produce
> an error, "Error occurred while generating report." But this is a
local
> issue with my ARS and Crystal versions. Your mileage may vary.
>
>
> Michael W. Luttmann
> Sr. Remedy Developer
> Fort Carson DOIM
>
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Friday, August 03, 2007 8:02 AM
> To: [email protected]
> Subject: Report on Results
>
> Hey folks,
> Hopefully this is an easy question.
>
> I have a form. Users open the form in search, enter criteria directly
> into the fields, hit search and get a bunch of results.
>
> I want to add a Crystal Report to the report form, call it from a
button
> on the search form and somehow send the same search criteria to the
> report that the users entered.
>
> Is this possible? Perhaps a secret run process command that is not
> documented in clear site?
>
> Thanks
>
> Les Ganton
>
>
________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where
> the Answers Are"
> Classification: UNCLASSIFIED
> Caveats: NONE
>
>
________________________________________________________________________
_______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the
> Answers Are"
>
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
