question

Lior-4074 avatar image
0 Votes"
Lior-4074 asked LiorRozani-5715 commented

RDL subreport filter

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,",")

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered LiorRozani-5715 commented

Hi @Lior-4074,

Not sure if you mean that you want the report like this:

75292-screenshot-2021-03-08-154330.jpg

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






· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

may I know how's the issue going on now?

0 Votes 0 ·

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.)


76021-untitled.png


0 Votes 0 ·
untitled.png (20.3 KiB)

Hi @Lior-4074,

As you described, I think that the value should be like =Parameters!Country.Label

76272-screenshot-2021-03-10-163819.jpg
76273-screenshot-2021-03-10-163903.jpg

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



0 Votes 0 ·

i tried it but still not working

0 Votes 0 ·

@Zoehui-MSFT can you please update if you can assist?

0 Votes 0 ·

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?

0 Votes 0 ·
Show more comments