Running Stored Procedures on a Report Services Model

I am designing an SQL Report Server Model, to replace a table that was used as a cut down version of the main database to report from. So the report will use the model to report from not the cut down database.

I was wondering if there was quick and easy way to take the Stored procedures, that were used for 100+ report on the cut down and point them on the new model.

Thanks

A SQL Server reporting services (SSRS) model is likely not a direct replacement for your Table.

A Model is used so that end users can write their own reports using a friendly report writer rather than writing complex sql statements (your existing stored procedures.) The model works on underlying tables but it doesn't ETL data from them into a separate storage area. If there were reasons to use the cut down table going back to the source data with your model may do more harm than good.

You can't run stored procedures against a reporting model; you can write SSRS reports that call stored procedures though so you could reuse your existing code and just deliver it via SSRS reports.