question

siera_gld avatar image
siera_gld asked

SSRS Input Paramater Limits

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
ssrsparameters
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
what version and service pack of reporting services? It seems that this was a problem at one point in RS 2005 but was fixed in a service pack
0 Likes 0 ·
siera_gld avatar image siera_gld commented ·
it is SP 3 with latest patches installed (last week)
0 Likes 0 ·
Doug Lane avatar image Doug Lane commented ·
Through which interface is the parameter getting passed -- through Report Manager, ReportViewer control on an ASP.NET site, web service, etc.?
0 Likes 0 ·
siera_gld avatar image siera_gld commented ·
Sorry - SQL 2005 SP 3
0 Likes 0 ·
siera_gld avatar image siera_gld commented ·
Native SSRS Report Manager is the user interface
0 Likes 0 ·

1 Answer

·
Doug Lane avatar image
Doug Lane answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.