SSRS 2012 Error: Invalid URI: The Uri string is too long

• pmaceke

  Ten Centuries

  Points: 1018

  More actions

  April 14, 2016 at 1:49 am

  #326440

  I've a main report which passes multi-value parameter to a drill though report.

  On the Text Box Property >> Action >> Go to Report

  I've Specify a Report using an expressions but the issue is when I add parameters. My report has 6 parameters and the first 5 work perfectly and 4 are multi-value parameters using expressions.

  My issue is on the last parameter which has about 165 values and the expression looks like this as the previous 4:

  =Split(Join(Parameters!CONSULTANT.Value,","),",")

  But the moment I add the last one the report fails to execute with the error message:

  An error occurred during local report processing.

  An error occurred during rendering of the report.

  An error occurred during rendering of the report.

  Invalid URI: The Uri string is too long.

  Please assist

• Thom A

  SSC Guru

  Points: 99126

  More actions

  April 20, 2016 at 9:13 am

  #1873382

  "Invalid URI: The Uri string is too long" means that your address is probably over 2,000 characters long!

  This suggests to me that your parameter values are far too long (you said the last one is 165 characters, which is HUGE!)

  You should really look at shortening your parameter values and the issue will resolve itself.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk