Multiple string paramters

[ridhirao22]

Hi,

Using CR2008 and I found this solution exactly what I am looking for and wanted to try but couldn't figure how I could correct my formula.

I get the error when I try the solution suggest in this forum when I create the @delimit. "The remaining text does not appear to be part of the formula"

http://stackoverflow.com/a/10105692

Create a Custom Function (named 'Delimit') with this text:
// Delimit()
// enclose each value in array in **, returning an array
Function (Stringvar Array params)

Split("*" + Join(params, "*,*") + "*", ",")

Modify the report's record-selection formula:
If {?Customer Name}<>"ALL" Then
{TABLE.CUSTOMER_NAME} LIKE Delimit({?Customer Name})
Else
True

Thanks in advance,
RR

 

[Charliy]

Are you trying to use Delimit as a formula instead of a function? The fact that you referred to "@delimit" makes me think that's the issue.

 

[ridhirao22]

I cannot even save the Formula Delimit. I get the error when I am save the custom function code in the delimit formula.
Thank you the reply, Charliy

 

[Charliy]

That's because you're trying to save it as a formula instead of a function.

Click on the "Formula Workshop" button.
You'll see a line that says "Report Custom Functions" - Right Click on it and select "New"
You be prompted for a function name - enter "Delimit", then click "Use Editor"
put the code for Delimit in the text box that appears (delete the default text)
Save it, now Delimit is a function you can use in your report.

 

[ridhirao22]

Thank you again Charily. This really worked.