Assistance Required in Paginated Report/SSRS Report

[Heena_9980400]

Hi Team,

I hope this email finds you well. I am reaching out for your assistance in resolving an issue I am encountering with a paginated report.

The report is designed such that after selecting multiple parameters, clicking on the Reject column record redirects to a child report.

However, an error is displayed:

"The report parameter list exceeds the limit of 2040 characters, needs to reduce the selected values for Zone 1, 2, 3 WO# dropdown."

I need assistance in ensuring that even after selecting "Select All" for the parameters, the report does not exceed the character limit and continues to function without errors.

I have also attached the expression used to achieve the functionality for your reference:

=IIF(LEN(Globals!ReportServerUrl +"?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " &Join(Parameters!parshiftinclude.Value,",") & "&moduleky= " & Fields!MODULE_DIM_KY.Value & " &pruntype= " &Join(Parameters!paruntype.Value,",") & "&Zone1Wo= " & Join(Parameters!Zone1Wo.Value,"&Zone1Wo="))<=2083, "javascript&colon;void(window.open('"+ Globals!ReportServerUrl +"?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " &Join(Parameters!parshiftinclude.Value,",") & "  &moduleky= " & Fields!MODULE_DIM_KY.Value & "&pruntype= " &Join(Parameters!paruntype.Value,",") & "&Zone1Wo= " &Join(Parameters!Zone1Wo.Value,"&Zone1Wo=") & "'))", "") '  --- Max URL limit accepted by IE browser is 2083 char

Looking forward to your assistance!

Thanks & Regards,

Heena Kousar

[Anonymous]

Hi,@Heena_9980400 .I am glad to help you.

It looks like you're experiencing a problem with URL parameters that are too long!

I found documentation on this, and unfortunately it's a known limitation.

Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

Here are my suggestions
1. Minimize the number of parameters selected, especially those with a high character count.
2. Use short names: Use shorter names for parameters to reduce the length of the URL.
I hope the following issue will be helpful to you.

Solved: Re: Cannot view report on powerbi report server wi... - Microsoft Fabric Community

3. It seems that modifying the configuration file is also a good solution

SSRS report - Invalid URI: The Uri string is too long. - Microsoft Q&A
Resolving the Maximum Request Length Exceeded Exception in SSRS - MSSQLTips.com
If you need to modify SSRS related configuration files, please make a backup beforehand to avoid losing important files.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Heena_9980400]

hi @Anonymous ,

The suggested solution is not working. Are there any alternatives I can try? Instead of navigating to the child report through that link, is it possible to achieve the same functionality within the current report, like using a drill-down feature or any other approach?

Looking forward to your suggestions!

Best regards,