V.9 Large memo field Keyword Search

[jahgardener]

Would like to be able to search for particular words within large text/memo fields using a parameter. I can search for words via a formula, however the ability for end users to add just keyword/keywords via a parameter would be better. Any ideas?

 

[synapsevampire]

You can reference parameters in formulas.

And what is the effect of the search? Are you limiting rows, highlighting the text.

Your post states that you want to do a search only, should the Report just return (text found somewhere)?

You may want to do this on the database side, but that's dependent upon what it is you want to do, which you haven't posted.

-k

 

[jahgardener]

I would like to use the keyword search parameter to limit the report output to items whose summary description contain a word or words entered in a single parameter prompt at the end user side.

The listing of items is vast, unique, and in some cases have decriptions many pages long. There will not be anyway to setup default lists of keywords. I did manage to set up the search for paramenter field called Keyword 1, and parameter called Keyword 2, and setup the record selection to whatever is entered in the Keyword 1 and Keyword 2 parameters. The default in Keyword 2 parameter is an nonexistant word, for situations when only one word is searched.

Since I am new to Crystal - I was wondering if one parameter field could be used to search for 1 or more diverse keywords or keyword strings from within a large text field. Also, how would the Record Selection be handled for a single parameter field with 1 or more keywords entered. (Sorry if this is clear as mud....) Julie

 

[synapsevampire]

It sounds like you're handling it correctly.

You could have an allow multiple values parameter, and parse it out for use by the record selection formula if you'd like, but this will get a bit trickier...

You could create numerous formulas which have something like:

//@choice1
If ubound({?parmlist}) >= 1 then
"%"+{?parmlist}[1]+"%"
else
"Nooooo"

//@choice2
If ubound({?parmlist}) >= 2 then
{?parmlist}[2]
else
"Nooooo"
etc...

Then the record selection formula would contain:

(
If {@Choice1} <> &quot;Nooooo&quot; then
{table.field} like {@choice1}
else
If {@Choice1} = &quot;Nooooo&quot; then
true
)
and
(
If {@Choice2} <> &quot;Nooooo&quot; then
{table.field} like {@choice2}
else
If {@Choice2} = &quot;Nooooo&quot; then
true
)
etc...

-k

 

[synapsevampire]

Ooops, I think I shoulod have used OR's, not AND's.

-k