Hi
I am passing a id from main report to sub report. Based on this id i display a field in the sub report. The field can have multiple values.
The issue i am having is in the sub report only 1 value is displayed.

I might be missing some link

Below is what i am trying to achieve , name can return multiple values and i am passing the id.

select name from ism.active_ingredient where id in
(select active_ingredient_id from ism.prod_acting where product_id in
(select child_member_product_id from ism.product_tree where parent_member_product_id='8816846'))

I have the tables and links as per the above sql and below is what i have done.
{PRODUCT_TREE.PARENT_MEMBER_PRODUCT_ID} = {?Pm-@product_id}

Thanks in advance