SQLTeam.com | Weblogs | Forums

Using selection criteria with stored procedure


#1

I need to create a report based on a stored procedure that manipulates data from multiple tables. The selection criteria should be part of the stored procedure so that I can limit the records going to the report but I am not sure if I can do this using SSRS? If someone can point me in the right direction it would be greatly appreciated.


#2

You can have parameters in the report, and pass those parameters to the stored procedure which then can be used in a WHERE clause to limit the number of records.

For example, you can have a parameter called MAXRECORDS in the report, and the query in the stored procedure can be designed to return the top MAXRECORDS records.