Welcome to MSDN Blogs Sign in | Join | Help

SYSK 203: Mind That Label Length in SQL Reporting Services

Another possible (but unconfirmed) bug in SQL 2005 Reporting Services:

 

If you have a SSRS report parameter that is multi-value and of one of the labels in the “available values” list exceeds 25 characters, the dropdown list with values for this parameter will be positioned in such a way that the end user won’t be able to see and thus select the first item. 

 

This problem does not exist when viewing this report from Visual Studio, but is easily seen after deploying the report to SSRS web server.

 

So, for now, you may want to trim your parameter labels to 25 characters. If you’re doing filtering based on the full name instead of some sort of id, you can use the value field to store the full parameter label.

 

Published Friday, September 22, 2006 6:50 AM by irenak

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# SYSK 219: Solution for SQL Reporting Services Problem Described in SYSK 203

Wednesday, October 18, 2006 9:50 AM by AppDev: Something You Should Know by Irena Kennedy

In http://blogs.msdn.com/irenak/archive/2006/09/22/766164.aspx post, the following problem was described:

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker