Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Main Report - Subreport Link for recursive Post Reply Post New Topic
<< Prev Page  of 2
Author Message
Crystal_forum
Newbie
Newbie
Avatar

Joined: 16 Mar 2009
Location: United States
Online Status: Offline
Posts: 16
Quote Crystal_forum Replybullet Posted: 09 Oct 2009 at 1:06pm
Yes I have to limit my sub-report based on Main report's Data.
 
Raj
Cheers
Raj
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Oct 2009 at 1:08pm
What limits exactly?
You said you wanted the main report to run all data rows for all customers then the sub report to run all data rows for all customers, correct?
 
IP IP Logged
Crystal_forum
Newbie
Newbie
Avatar

Joined: 16 Mar 2009
Location: United States
Online Status: Offline
Posts: 16
Quote Crystal_forum Replybullet Posted: 09 Oct 2009 at 1:25pm
No, Not all customers would get printed in Main report.
I have attached different SP's with Main and Sub-reports.
So the Main report might get only 10 out of 100 and I am trying to drive my sub-reports only for those 10 customers only.
 
Thx
Raj
Cheers
Raj
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Oct 2009 at 1:33pm

How are you limiting the data in the main report? Are you using parameterss at runtime or something else?

IP IP Logged
Crystal_forum
Newbie
Newbie
Avatar

Joined: 16 Mar 2009
Location: United States
Online Status: Offline
Posts: 16
Quote Crystal_forum Replybullet Posted: 09 Oct 2009 at 1:42pm
The Stored Procedure attached with Main report is taking some parameters as date range and the do various validations /condions to get the list of customers for the main report.
So the Sub-report should run only for these customers.
 
If no link then I have to repeat the same validation / conditions on Sub-report's SP as well to comeout with the list.
 
Raj
Cheers
Raj
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Oct 2009 at 1:58pm

There is no simple way to do what you want that I know of. If you link it is only going to apply the one customerid that is on the row of data where the sub-report is placed, it is not going to apply an array of all of the id's in the main report. Not sure what the best solution is for that...

Anyone else have thoughts on this?
IP IP Logged
<< Prev Page  of 2
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.