Can you use a user-function with a ParamArray as the argument? I tried but when i preview my report, it gives me the big dreaded error box and says The expression contains undefined function call CsvList().
Here is my function def:
and here is my call to the function:
Here is my function def:
Public
Function
CsvList(
ParamArray
items
As
String
())
As
String
Return
Join((From s
In
items Where
Not
String
.IsNullOrEmpty(Trim(s))
Select
s).ToArray,
", "
)
End
Function
and here is my call to the function:
= my_reports.General.CsvList(
Fields.Firm,
Fields.Name1,
Fields.Name2,
Fields.Address,
Fields.AptType +
" "
+ Fields.AptNum,
Fields.City,
Fields.State,
Fields.Zip,
"PH: "
+ Fields.Phone,
"FX: "
+ Fields.Fax,
"RSN: "
+ Fields.Reason
)