Post reply

Reset parameter value to NULL

  • October 10, 2014 at 5:32 am

    #311663

    Hi,

    I am working on a report which has a combination of dropdownlist and user entered text parameters. As per the requirement, the values in the user entered text based parameters are defaulted to NULL.

    At present, once the NULL values are replaced by a different value, the new value still stays on the report after the report is viewed.

    Is it possible to reset the default value to NULL after user clicks on the View report ? I have tried many things but cannot find a way to do this.

    Please find a screenshot of the report to give a better idea - The parameters - DUNS, COMPANY NAME and SHARED ALIAS should reset back to NULL after the report is first run.

    Any suggestions and advice would be appreciated.

    Thanks.

  • October 14, 2014 at 2:25 am

    #1752133

    pwalter83 (10/10/2014)

    Hi,

    I am working on a report which has a combination of dropdownlist and user entered text parameters. As per the requirement, the values in the user entered text based parameters are defaulted to NULL.

    At present, once the NULL values are replaced by a different value, the new value still stays on the report after the report is viewed.

    Is it possible to reset the default value to NULL after user clicks on the View report ? I have tried many things but cannot find a way to do this.

    Please find a screenshot of the report to give a better idea - I want the DUNS, COMPANY NAME and SHARED ALIAS to reset back to NULL after the report is first run.

    Any suggestions and advice would be appreciated.

    Thanks.

    Could anybody please give any suggestions ?

    Thanks.

  • October 14, 2014 at 11:27 am

    #1752281

    I'm not aware of anyway to do this. SSRS doesn't really give you control over the parameters when using Report Manager.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply