Is there any way to use a dataset from a report multiple times without having to re-run the query each time?
For example I have a dataset with the following columns:
WeekEnding
District
State
Branch
NewMemberships
ChangedMemberships
TotalMembershipActivity
YTD_NewMemberships
YTD_ChangedMemberships
YTD_TotalMembershipActivity
LevelDeep
I have 3 different reports from this required formatted as below:
-------
New Memberships
District Week1 Week2 Week3 YTD_Ranking
Northern 12 4 3 19
Western 10 6 0 16
...
--------
-------
Changed Memberships
District Week1 Week2 Week3 YTD_Ranking
Western 20 14 0 34
Eastern 15 16 2 33
...
--------
-------
% New Memberships
District Week1 Week2 Week3 YTD_Ranking
Western 50% 13% 0% 58%
Eastern 17% 46% 19% 33%
...
--------
Question 1: Is there a simple way to get all these different result sets in one sub-report without having to re-run the query for each one?
My problem is I have 70+ subreports over about 30-35 stored procs and while each stored proc only takes a few seconds to run in query analyzer my report takes about 30-40 min to run in business objects.
Thanks