Refresh report without accessing database

I have a need to refresh a report after applying a filter on the data that is displayed, without accessing the database.

The following example is a simplified version of the functionality I'm trying to accomplish. The first report displays Sales & Projection data for all products. On clicking a particular product in the header, the second report displays just that product and the total metrics. I have created an rdl file for both the reports and based on the parameters passed, it displays one or several products. My concern is that the report is having to access the AS cube every time a product is clicked. In the real report, it's taking minutes to get the data. Is there way I can get the report to refresh to apply the filter without accessing the database again? Thanks in advance...

Report-1

Product

A

B

C

Total

Sales

100

200

300

600

Projection

200

200

300

700

Total

300

400

600

1300

Report-2

A

Total

Sales

100

600

Projection

200

700

Total

300

1300

I assume you have the reports set to execute live. In this case, changing parameters effectively causes RS to throw away the original report and start from scratch when you change parameter values. You may want to consider using the Cached option, this will allow RS to use the same report snapshot for a given set of query parameters and minimize the # of calls you make to the underlying AS database.|||

exactly what I needed... Thanks John.