Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Prompt Users for a Variable in SSRS Expand / Collapse
Author
Message
Posted Thursday, May 22, 2014 11:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:52 AM
Points: 4, Visits: 80
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.
Post #1573714
Posted Thursday, May 22, 2014 11:57 AM This worked for the OP Answer marked as solution
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:24 AM
Points: 1,264, Visits: 3,555
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. Get your answers faster.
Post #1573721
Posted Thursday, May 22, 2014 1:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:52 AM
Points: 4, Visits: 80
It worked!! Thank you so much for your assistance.
Post #1573745
Posted Saturday, May 24, 2014 7:20 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 709, Visits: 4,520
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.
Post #1574350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse