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.
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???
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:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.