Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: use dataset multiple times Post Reply Post New Topic
Author Message
PaunchoVilla
Newbie
Newbie
Avatar

Joined: 01 Mar 2011
Online Status: Offline
Posts: 1
Quote PaunchoVilla Replybullet Topic: use dataset multiple times
    Posted: 01 Mar 2011 at 10:21am
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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 03 Mar 2011 at 3:45am
If you can change the stored procedure to provide the data in a format like this, you could do this without subreports
 
WeekEnding
District
State
Branch
MembershipType (this will be something like New, Changed, PercentNew)
Memberships
YTD_Memberships
LevelDeep
 
You can then group by Membership Type to get the format you're looking for.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.