is there an option to set multi values as parameter for subreport? and if so, how? i want to pass as a filter multi countries values =Join(Parameters!Country.Value,",")
is there an option to set multi values as parameter for subreport? and if so, how? i want to pass as a filter multi countries values =Join(Parameters!Country.Value,",")
Hi @Lior-4074,
Not sure if you mean that you want the report like this:

If you want design like this, you may refer the blog and the add-a-subreport-and-parameters-report-builder-and-ssrs
I did some research online, you may also refer this.
If I misunderstand your need, please incorrect me and give more detail message such as the design sample and the result you want.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
let me clarify my question
as you can see below, i need to pass a parameter value (red arrow)
i tried to use this expression: =iif(Parameters!Country.Count = Parameters!CountryCount.Value, Nothing, Join(Parameters!Country.Value,","))
but im receiving an error when im try to run the report (Error: Subreport could not be shown.)

Hi @Lior-4074,
As you described, I think that the value should be like =Parameters!Country.Label


Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November
Please make sure that the main report and the subreport has the same parameter. May I know the error message of the report? And do you want your report rendered as shown in my picture?
6 people are following this question.