Post reply

SSRS 2008 260 Character URL limit

  • May 4, 2012 at 10:41 am

    #260517

    Is there any workaround or hack to get around this limitation?

    Maybe there's another way I can accomplish the same thing. On a report we have a ton of parameters. How could I send someone to a report and have the parameters fill in with what we specified without using parameter defaults?

    Thanks in advance!

    Kraig

  • May 8, 2012 at 10:31 am

    #1484653

    turner.kraig (5/4/2012)

    Is there any workaround or hack to get around this limitation?

    Maybe there's another way I can accomplish the same thing. On a report we have a ton of parameters. How could I send someone to a report and have the parameters fill in with what we specified without using parameter defaults?

    Thanks in advance!

    Kraig

    You could store the parameter options and concatenate the values that make up the URL.

    Eg

    http://YourReportServer/YourClient/Reports/YourReport.rdl%20YourFirstParameter&YourSecondParameteretc...

    gsc_dba

  • May 8, 2012 at 3:16 pm

    #1484791

    Unless I'm missing something, doing this will give me a url greater than 260 characters.

  • May 9, 2012 at 2:35 am

    #1484927

    turner.kraig (5/8/2012)

    Unless I'm missing something, doing this will give me a url greater than 260 characters.

    My apologies - here is a solution you could try: http://msdn.microsoft.com/en-us/library/ms153563.aspx

    gsc_dba

  • May 10, 2012 at 6:33 pm

    #1486057

    This looks like it might be it. I'll give it a try. Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply