Parameter Creation Crystal XI R2

[pungigis]

I have a field type that contains the following

Eopgray
Eopgrays
Eopbgry

Etc… it is a (nchar(8), null), I am trying to create a parameter but its not working, I have tried several things and can't get it, any ideas???? When I do as is I get an array error.

 

[pungigis]

Ok, got it to stop throwing the error by putting,
{?Company Name}[1] in {Transactions.CampaignName} HOWEVER not it takes FOREVER to run, is there a way to do this better and possibly speed up the performance???

 

[lbass]

Your formula is searching for the first letter of the parameter in any position of the campaignname. You might be better off using something like this:

{Transactions.CampaignName} like {?Company Name}+"*"

Instruct users to enter the first few letters of the name. If you don't have your report formatted to be case insensitive, then use a SQL expression {%Name} to make the CampaignName Upper Case:

{fn ucase(Transactions.CampaignName)}

...and then use this in the selection formula:

{%Name} like ucase({?Company Name})+"*"

-LB