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

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 620105 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/9/2010 12:28:43 AM
Access Restriction Public


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.