Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duggram
Starting Member
2 Posts |
 Posted - 2011-01-11 : 10:11:37
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-11 : 11:32:33
|
| you can. bring data grouped by relevant fields (Day, Week, Month, Quarter, Year) in dataset with additional field category to denote the grouping level. then for all the subreports apply a filter on this field to show only relevant data (ie. Category = 'Day' for day based report,etc)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Multiple reports on single shared dataset?