multi value parameter not passing in sub report parameter list

hello all,

I have two report , first is main report which is matrix and have one parameter User_ids which is multi value selection

and my second report is basic chart of user_wise performance 

Now, my main report (matrix ) works fine for Multiple selection of users and i have putted one textbox on main report chart which has action properties set for chart report 

when user click on chart button it must goes to chart with user selected in main report 

Now , i have used expression for parameter to send it like ..

=join(parameter!user_id!value,",") which pass selected value to chart 

and when i am selecting single user it passing that value to chart parameter list but , when it is more than one user it errors with conversion failed when converting the nvarchar value '121,128' to data type int.

but my chart also works when passing 121,128 in user parameter in preview of report .

please , tell me why this is happening ?

July 29th, 2015 3:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics