Print Page | Close Window

use dataset multiple times

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12465
Printed Date: 18 May 2024 at 4:21pm


Topic: use dataset multiple times
Posted By: PaunchoVilla
Subject: use dataset multiple times
Date 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


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window