Crystal Reports Main Report - Subreport Link for recursive

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Main Report - Subreport Link for recursive
	<< Prev Page of 2

Author	Message
Crystal_forum Newbie Joined: 16 Mar 2009 Location: United States Online Status: Offline Posts: 16	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

Crystal_forum Newbie Joined: 16 Mar 2009 Location: United States Online Status: Offline Posts: 16	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

Crystal_forum Newbie Joined: 16 Mar 2009 Location: United States Online Status: Offline Posts: 16	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

<< Prev Page of 2

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.