Pass multiple comma delimited values to subreport procedure
Posted on 2010-11-30
I have a sub-report with a procedure that has an id (string) parameter.
It can take multiple ids which are comma delimited ie ‘123,346,789’
If I run the sub report as its own report with the id = ‘123,346,789’ it returns the three values I need
If I pass one id (123) to the sub report from the main report it works fine.
However if I try to return more than one value (‘123,346’) to the sub report, it blows up with the error
“Function stp_ReturnID has too many arguments specified”
How do I get it the subreport to recognize the multiple comma delimited values?