locked
Parameter default and manual inputs RRS feed

  • Question

  • Hello

    Is it possible in SSRS to have Parameter which will be default to some value but also allow user to input value if he wants to change it to something else.

    I have Time parameter in my report and it is default to SystemTime, but user wants it to be changed when needed , he doesnt want a drop down of values ..but be able to change it to another time.

    Paraemter format is HH:MM

    Best Regards,



    Friday, December 11, 2015 1:55 PM

Answers

  • Hello

    Is it possible in SSRS to have Parameter which will be default to some value but also allow user to input value if he wants to change it to something else.

    Hi Pragati,

    According to your description, you want to know if we can input some value to instead of default value in a SQL Server Reporting Services report parameter, right?

    Yes, this can be done in SSRS report. For SSRS parameter, if we add available values for the parameter, then it will display as a drop down list when viewing report. And we cannot add other value manually. If we do not add available values to parameter, then it will display a text box when viewing report. Then we can change the default value to other value.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by Charlie Liao Monday, January 4, 2016 9:43 AM
    • Marked as answer by Charlie Liao Tuesday, January 5, 2016 9:30 AM
    Monday, December 14, 2015 7:47 AM