Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Heena_9980400
Helper IV
Helper IV

Assistance Required in Paginated Report/SSRS Report

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

 

Heena_9980400_0-1737815957868.png

 

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

 

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @Heena_9980400 ,

 

Thanks for reaching out to us.

If possible, use abbreviations or codes for parameter values to reduce their length.

Here are some detailed strategies to shorten parameter values in your SSRS report:

1. Use Abbreviations or Codes
Instead of using full names or descriptions, use abbreviations or codes. For example, use "NY" instead of "New York" or "Q1" instead of "Quarter 1".
2. Numeric or Alphanumeric Codes
Assign numeric or alphanumeric codes to your parameters. For instance, instead of passing "High", "Medium", and "Low", you could use "H", "M", and "L".
3. Mapping Tables
Use a mapping table in your database to convert long parameter values into shorter codes. For example, you could have a table that maps "New York" to "NY", "California" to "CA", etc.
4. Truncate Unnecessary Characters
Remove any unnecessary characters or spaces from your parameter values. For example, instead of "Product Category: Electronics", use "Electronics".
5. Use Indexes
If your parameters are based on a list of items, use their index positions instead of full names. For example, if you have a list of departments, use their index numbers (1, 2, 3) instead of their names.

 

 

Or simplify your report design to minimize the number of parameters needed.

 

In addition, try adding an IF condition to filter the data that exceeds the limit in advance.

 

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi @v-stephen-msft ,

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,

Heena_9980400
Helper IV
Helper IV

Hello Everyone,

Can anyone please help me out here.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.