How to pass multiple value for a postgres function in SSRS

Question

I have created a report which is using postgres sql function and there are parameters for start date, end date and physician name. I am trying to pass multiple value for physician name and it is not working for me:

This is how I am calling the function in ssrs

select * from public.zcus_fn_profee_charges_all_physicians_table(?,?,?);

and this is what I am using for the query parameter for physician name:

=Join(Parameters!Parameter3.Value, ",")

Can anyone tell me how to pass multiple values for the last parameter if that's possible ?

Thanks,

Ali.

Answer 1

Hi @Ali Ahad,

I'm not familiar with postgres sql, here is a same thread you may take a reference to.

SSRS multi value parameter - can't get it to work

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.