Post reply

Multi value parameters max size

  • September 8, 2009 at 9:42 am

    #385324

    --------------------------------------------------------------------------------

    I have a string multi-value parameter in one of my reports, this provides the user with a list of clients name they can select from which is then passed to a Table value function inside the sp.

    in some instance the client name list can be as large as 800 client names, now when this is the case and the user selects "all" and trys to run the report the paramater box blanks out and nothing else happens.

    i get the felling this is because the string parameter maximum limit has been reached within report manager. i am using varchar(max) within my sp but i do belive it is ssrs side that is failing.

    any ideas.

  • September 9, 2009 at 9:52 am

    #1051243

    instead of string use nvarchar(max)

  • September 9, 2009 at 10:04 am

    #1051255

    "i get the felling this is because the string parameter maximum limit has been reached within report manager."

    as stated Nvarchar(max) is being used on the backend sp's the issue i believe is a limitation in the size the string parameter on the front end (report manager) can handle. you cannot choose anything other than "String" datatypes when working with varchars when creating a report.

  • September 9, 2009 at 11:42 am

    #1051320

    yeah... your correct... but i havent tried for around 800 rows... the max i have tried is 294...but if i need to select all the 294 rows i click on select all...and then i pass a NULL to my sproc to handle it

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

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