Post reply

Prompt Users for a Variable in SSRS

  • May 22, 2014 at 11:50 am

    #307636

    I am building a SSRS report (my first report) that will pull all records from a single table. Before the data is populated in the report I would like to have SSRS prompt the users for an item number. Do I add the functionality in the stored procedure the report calls? Or, can a text parameter field be added directly in SSRS to filter just the data?

    Thanks!

    Edit: Attempted to change the post name.

  • May 22, 2014 at 11:57 am

    #1715813

    You can create a report parameter then pass that parameter directly to the dataset when called. Or you can create a report parameter then pass that parameter to the procedure that creates the dataset. They are very similar.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • May 22, 2014 at 1:00 pm

    #1715834

    It worked!! Thank you so much for your assistance.

  • May 24, 2014 at 7:20 pm

    #1716352

    I know this is closed, but it's better to pass the parameter to the stored procedure and filter there. Otherwise, you can send a lot of data to the SSRS server which then discards the data according to the filters you set. Sometimes that's not an option though.

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

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