I have a user that places a comma split value into an input paramater the paramater is varchar(8000) and each item in the paramater is 7 characters + the comma = 8. SSRS is limiting the input to 99 items (100) which would equate to 800 characters. does anyone know how to increase the number of items? Is this a limitation in SSRS because the T-SQL statement should allow 400 items as the user wants
I'm using 2008 R2, and if I pass a parameter an 8000-character string, a text box with the expression "=Len(Parameters!ReportParameter1.Value)" shows 8000 in the previewed report. Like KenJ, I'm curious what version of RS you're using.