Choose particular value in dropdown parameter - parameter refreshes!

  • I have an odd one here. I have a parameter that has a list of values that are filtered according to 1 previous parameter and there's a language option in there too. When I choose one particular value in the parameter, the drop down list refreshes itself, making me unable to choose it.


    Removed the filter.

    Moved it to be the last parameter in case the parameter after it was triggering refresh.

    Removed the language parameter.

    The only thing that appears unique about this value is that it is the longest at 51 characters, yet even if I cut it to 49 characters (length of the next longest), I still see this issue.

    Anyone have experice with something like this or have some ideas on what I can check?

  • Never had that problem, but I wonder is it the label that is 51 characters or the value?


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • In this case the value is 51 characters. The label was actually a bit less. I'll admit, I was being a bit lazy when building this report and am filtering on some names. But the names are distinct.

  • Viewing 3 posts - 1 through 3 (of 3 total)

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