Post reply

SSRS - Split with parameter value from expression is not working properly when calling sub-report

  • October 13, 2011 at 3:47 am

    #250075

    Hi,

    I want to pass Multiple-values to the parameter of a sub-report. If i use hard-coded string in Split then it works fine.

    Now in the split function, if i use String parameter/field/textbox in which i am generating values from a dataset function in the calling report and use that parameter as a value of parameter for sub-report then it gives following error

    "An error occurred while executing the subreport ‘subreport1’: One or more parameters required to run the report have not been specified. Preview complete"

    Split accepts "Expression as string". so this mean i can use parameter/variable here.

    Then where is the error.

    Any suggestion?

    Thanks.

  • October 17, 2011 at 5:05 am

    #1395234

    Additional Double quotes in the generated string was creating problem.

    Thanks everyone for viewing.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply