I would like to create a report that is based on a single dataset, but with action items that lead to delineated sub-reports.

I have a jpg of my report but can't see how to post it here.

I have a pie chart based on a dataset. Under the chart I have 5 text boxes with the words "Day, Week, Month, Quarter, Year" (in blue underlined font). When the user clicks a "link" I want a sub-report with appropriate table to appear displaying the information for the period that the user selected.

Setting the action is not a problem. Not fetching from the database again is. How can I get this done? How can I use a single shared dataset between all reports and prevent the dataset from re-fetching from the database?

Thank you, Doug