SQL Server Home
SSRS 2008 displays parameter value instead of label after SP2
as By Design
11/9/2010 12:28:43 AM
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.
SQL Server 2008 SP2 CTP
Win2003 Enterprise Server (SP2)
Operating System Language
Steps to Reproduce
Displays value (SP2)
Display label, as previously and BOL,
to post a comment.
Please enter a comment.
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.
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.
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.
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.
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?
to post a workaround.
Please enter a workaround.
© 2014 Microsoft