Do you want to pass a table to the procedure, or just the name as hilfy asked?
if you want the procedure to be run every time you change the page, you are looking at a subreport as CR only 'fetches' the data once per report (subreport are called repeatedly and so the data is fetched each time)
if you are fetching large amounts of data for each subreport and you have a lot of pages to your report, your report is going to run really slow.
a better solution (i would think) is to create your stored proc so that you return all the data that you will need for the report all at once. If you need 'different' data for a certain input....since you know the input, return the input and the data for it. Then have CR split up the data and create the pages, so that it 'looks' like it is going out to database repeatedly, but is actually only 'really' calling the stored proc 1 time.