I have created a report that uses 5 subreports and am running into some
difficulties with execution caching. I have enabled caching on each of the
subreports as well as the master report.
Caching works as expected when I run each of the subreports independently.
However, running the master report causes the subreports to ignore their
cache settings and requery the database.

* Is this behavior by design?
* Is there a workaround?

This issue is causing my master report to be too slow for use and I would
very much appreciate some insight.

- Adil -

Hi Adil,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I understood you would like to know how to make
subreport cached. If I have misunderstood your concern, please feel free to
point it out.

Yes, as you have noticed. Even you have set cache in subreport, it will not
use the cache when querying the main report. This is a by design feature.
If you want to cache the subreport in main-report, you should set cache in
main-report and there will be a cache for subreport accordingly.

Hope it helps.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.