Parameters (group before selection?)

[pokerace]

C10 ODBC

Is there a way to set up a parameter so that a group of fileds can be chosen as one parameter choice instead of individual fields?

For example, if I have a table with the following fields (to make this simple)

ABC1
ABC2
ABC3
DEF1
DEF2
DEF3
XYZ1
XYZ2
XYZ3

I want to set a parameter so that instead of having to select every field individually, the report runner can just select a group, say everything beginning with ABC for example. Can that be done with Crystal 10?

 

[synapsevampire]

Hmmm, not really...

However if you know that you want just the 1st 3 characters of a the parameter, you can do so by using the following in the reocrd selection formula:

{table.field} like left({table.field},3) + "*"

So perhaps you have a second parameter that states match exactly, or first 3 characters, as in:

if MyLookup = "1st 3" then
{table.field} like left({?MyParm},3) + "*"
else
{table.field} = {?MyParm}

-k