Forum Discussion
Helper IVAssistance Required in Paginated Report/SSRS Report
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: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
2 Replies
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 solutionSSRS 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_9980400hi 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,
