Multiple Reports on a Single Shared Dataset?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Multiple Reports on a Single Shared Dataset?

Multiple Reports on a Single Shared Dataset?

Rate Topic

Display Mode

Topic Options

Author

Message

duggram

Posted Tuesday, January 11, 2011 8:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 11, 2011 11:43 AM
Points: 3, Visits: 18

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

Post #1045932

« Prev Topic | Next Topic »

Permissions