Pass static values to sub report multi value parameter

[former_member205840]

Hi Experts,

We have a report created using Universe as datasource.  A subreport is inserted in this report which is also create using Universe.

In sub report we have a prompt which accepts more than one value (this prompt is an automatic prompt, which was created in one of tables join)

Now we have to pass two static values to this prompt from Main report Eg: 'Manager','Asst Manager'

I tried to create a variable with coma separated in main report and passed to sub report but no luck.

I tried chr(13) to insert a new line character and pass it to sub report prompt no luck

Is there any other way we can pass this static values to sub report prompt ?

Thanks,

Sastry

[DellSC · Accepted solution]

Crystal expects multi-value parameters to be in an array, not a comma-delimited string.  You could try creating a formula that returns these values in an array, but I don't think the return value of a formula can be an array.  If it works, problem solved.  If it doesn't, I can't think of another way to do this.

-Dell

[former_member195446]

Hi

i have the same issue,i have tried with comma delimeter and new line character but i was not able to pass the multi values

can you please  help me how do u resolve this

Thank you,

Prasad