Send parameter of multiple values type in URL for SSRS report

(0) Share

Report

Posted on by truc binh

Hi community,

Does anyone know how to send parameter of multiple values type in URL for the SSRS reports?

I have tried to include parameter multiple times like this "p:param=value1&p:param=value2" but it keeps showing error "The report cannot be displayed. (rsReportParameterTypeMismatch)".

Please share if you know how to do this or is this a bug?

Thanks,

Binh.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hi @trucbinh

Try using like this https://url.com&param1=3&param2=2008

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
truc binh 61 on at

Like (0)

Report

Hi @rampprakash ,

I can send the parameter of single value successfully. But I am getting the error when sending the parameters of multiple values, and this is the SSRS report in Dataverse.

Binh.

Was this reply helpful? Yes No
truc binh 61 on at

Like (0)

Report

Hi @rampprakash ,

I can send the parameter of single value successfully. But I am getting the error when sending the parameters of multiple values, and this is the SSRS report in Dataverse.

Binh.

Was this reply helpful? Yes No
Drmo84 5 on at

Like (0)

Report

Hi @trucbinh
I see you are (or at least were) experiencing some problems with passing multiple values to single parameter. I have the same problem.
I'm trying to work this out, but every site/blog with instructions (even MS learn) on how to do it, says to just post a parameter and value multiple times, but it does not work. The syntax is supposed to be paramname1=somedata&paramname1=someotherdata, but that does not work. Even for a single value, you have to use p:paramname1=somedata.
Did you figured it out and are prepared sharing on how to do it? 🙂

Was this reply helpful? Yes No
truc binh 61 on at

Like (0)

Report

Hi @Drmo84 ,

You can try with p:parameter=value1,value2,value3. I am running successfully with this.

Binh.

Was this reply helpful? Yes No
Drmo84 5 on at

Like (0)

Report

Hi @trucbinh
How is your parameter defined? Mine is text with "Allow multiple values".
How is the parameter used? I have tried filtering in FetchXML query with it:
<filter>
<condition attribute="fx_orderlineid" operator="in" value="@orderlineid">
</condition>
</filter>

Also tried using it as a filter in Dataset with no luck.
When I pass it in URL like you advised, I get an error:
The report query contains invalid FetchXML. Contact your Microsoft Dynamics 365 administrator.

I'm trying to pass multiple GUIDs into report for filtering. Main thing that I noticed is that I can only pass it as a single value, but then the report sees it as a single value and does not filter correctly (does not show any data) until I manually split it into two values in the parameter.
This:
To this (working):

Any help would be appreciated.

Was this reply helpful? Yes No
truc binh 61 on at

Like (2)

Report
Oh, I am sorry for not mentioning the report part. This is just my workaround solution.
I set this parameter as a text parameter.

1. For optimized version, I apply directly to the fetchxml query:
- Then in my dataset, I declared the list of parameters with each value like this:

=IIF(Parameters!DocumentStatus.Value = "-1", 100000004, IIF(Split(Parameters!DocumentStatus.Value, ",").Length >= 1, CInt(Split(Parameters!DocumentStatus.Value, ",").GetValue(0)), -1))

- and in the fetchxml:

<condition attribute="statuscode" operator="in"> <value>@StatusCode1</value> <value>@StatusCode2</value> <value>@StatusCode3</value> <value>@StatusCode4</value> <value>@StatusCode5</value> <value>@StatusCode6</value> </condition>

2. If you don't have a large amount of data, you can apply to the filter option of your dataset because the data will be queried using the fetchxml, then these filter conditions will be applied to the result.
Expression:
=CStr(Fields!schema_name_field.Value)
Value:
=IIF(Parameters!ParameterList.Value = "-1", CStr(Fields!schema_name_field.Value), Split(Parameters!ParameterList.Value, ","))

Was this reply helpful? Yes No