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.
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.