Home Dashboard Directory Help

SSRS 2008 displays parameter value instead of label after SP2 by Mark Yudkin


 as By Design Help for as By Design

Sign in
to vote
Type: Bug
ID: 620105
Opened: 11/9/2010 12:28:43 AM
Access Restriction: Public
User(s) can reproduce this bug


Report parameter defined with list of integral values with meaningful labels. Parameter default is taken from expression using the value of another parameter, or a query using another parameter in the dataset parameters.

Under SSRS 2008 GA and SP1, the value displayed to the user was a drop-down combo, with the labels available for selection, and the default value's label selected after selection of the parameter it depends on.

After application of SP2, the integral value is displayed in an input box.
Sign in to post a comment.
Posted by Mark Yudkin on 5/26/2011 at 11:21 PM
I apologize for the confusion in the reproduction case. I have attached a corrected reproduction - with noth parameters having integer values, that illustrates the issue introduced in SSRS 2008 SP2.
Posted by Microsoft on 5/26/2011 at 6:53 PM
We have investigated the attached project. This issue is by design. Parameter 1 is an integer. Parameter 2 uses parameter 1 as its default value. But the values for parameter 2 are not integers - they are strings ("One", "Two", etc). So the value of parameter 1 will never map to a valid value for parameter 2. The value and label are effectively reversed on parameter 2.
Posted by mary4help on 2/25/2011 at 11:00 AM
I am having the same issue, but with reports that were upgraded from SQL Server 2005 to SQL Server 2008 R2. The parameter labels appear correctly when in Preview mode, but when deployed, the parameter value displayed. The available values were from a query.

I tried to fix by replacing the available values and labels with a list of specified values, but now <Select a Value> is displayed in the deployed report, even though a default is specified.
Posted by Mark Yudkin on 11/24/2010 at 2:33 AM
RDP attached. It shows the case of a parameter (P2) whose default value is dependent on another parameter (P1). Enter 2 for P1 and then tab, P2 will show as 2 (the value) rather than Two (the label). The same issue occurs if P2's default value is "from a query". The problem does not occur if the available values are "from a query" rather than specified.

This problem did not occur prior to installing SQL Server 2008 SP2.
Posted by Microsoft on 11/23/2010 at 6:27 PM
Thank you for your feedback.

However, we are unable to repro the issue with the existing information. Could you provide an RDL without sensitive info and a test data set for this repro?

Thank you.

Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Report1.zip 11/24/2010 909 bytes
ParmNotLabel.zip 5/26/2011 6 KB