Hi, I was wondering if any of u faced a problem like me.... I have report with a parameter that has no available values but only default values... But when I select default value from a query ..I c only values field not label field....This is causing a trouble as I am passing integer value to my dataset but I want to show the text value to the users. Is there any way to overcome this. Thanks! AkkiAkki

Hi There Just put your default value dataset to your available values and you can put label as well as value field In default value the only option available is Value field I hope this will helps Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote asHelpful" if you find it helpful

hi, I thought that way..But The user does not want to select the value from drop down ....He just wants the parameter get populated by default.. Thanks! AkkiAkki

Hi There, To display the parameter labels in the report at runtime, we must set available values for the parameter. Once the available values are set, the parameter will be selectable. This is by design. To work around the issue, you can set the parameter visibility to Hidden and then add a textbox in the report footer or the top of report body to display the parameter name and the expected parameter labels. If you have any questions, please feel free to ask. Regards, Mike Yin

Hi There What you could do bring the label field and value field and just put label field as a value so that user can see that. When user choose the value (Label)then you can translate back to your value field based on label value and passed to your details dataset Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote asHelpful" if you find it helpful

Hi There, To display the parameter labels in the report at runtime, we must set available values for the parameter. Once the available values are set, the parameter will be selectable. This is by design. To work around the issue, you can set the parameter visibility to Hidden and then add a textbox in the report footer or the top of report body to display the parameter name and the expected parameter labels. If you have any questions, please feel free to ask. Regards, Mike Yin

Hi Syed Qazafi Anium, Is that possible to display parameter default value and user cannot change the value. E.g. Value should look like this Parameter Name --- Parameter value in Label which cannot be editable.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi There Yes you just go to the paramter and choose specify value and click add and you can add one value and label and now go to your default value and choose that value as default value this value will not be editable Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote asHelpful" if you find it helpful

HI Syed Qazafi Anjum, I already tried the same, but it is editable.user can change value on that, i want to display value under Label, this value comes under text box and hence editable....Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi There This will not be editable please follow these steps create a parameter go to avialable value tab first and add put something on label say test put something in value say 1 go to default value tab choose sepcify value again and add value please put one(1) there( I am doing this all in SSRS 2008) please make sure you add first available value if you just specify default value then it will be ditable when you come to run mode it will be a combo box which is not editable Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote asHelpful" if you find it helpful

HI Syed Qazafi Anjum, It will come under combo box, i want it to be display in Label and non editable....I do have idea of combo box display, i need to display in label.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi Mike, I do not want to display it on the footer, just want to show value where the parameter are displayed in report as a label. What i belive this is not possible in SSRS. Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/