I have a report that uses a stored procedure in the main report and uses regular database tables in the subreport. The data returned from the stored procedure reports information from the month-end database (a cutoff point from the previous month's numbers) while the subreport reports information from the live database. This report gets run everyday to show the changes in numbers from the live database. Obviously the numbers from the month-end database remainds static until the next month's cutoff database is created.
My problem is that everyday when I run the report, the data needs to refresh from both the stored procedure in the main report and the live database tables in the subreport. How can I leave the data returned from the stored procedure static or as is without refreshing the stored procedure returned data and just have the subreport data refresh itself? The stored procedure really puts a strain on the database and I would like to cut-out the time to process the report as well. Does anyone have any ideas?