Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Linking parameters between main and sub-report Post Reply Post New Topic
Author Message
avallone
Newbie
Newbie


Joined: 08 Oct 2012
Location: United States
Online Status: Offline
Posts: 6
Quote avallone Replybullet Topic: Linking parameters between main and sub-report
    Posted: 08 Oct 2012 at 6:25am

I am using Crystal Reports for Net 4.0.

 

My Main report and my sub-report and based on two different stored procedure. They both use the same parameter SubmissionControlId. The value of SubmissionControlId is not passed back to main report only to the sub-report. I want to link the values so that whatever value is passed to SubmissionControlId in the main report is also used when the sub-report stored procedure is called.

 

I cannot get the syntax correct. I think I need to use shared variables but I’m not sure how.

 

 

Bob Avallone
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 09 Oct 2012 at 10:26am
If these are parameters, you're not going to use shared variables.  Instead, in the report design you need to go to the Subreport Link and do the following:
 
- In the top, select the SubmissionControlId parameter from the main report.
- In the bottom, turn off "Select data in subreport based on field:".  To the left of that, drop down the list of Subreport Parameters and select the one for the SubmissionControlID.
 
This will link the parameter from the main report to the parameter in the subreport.
 
-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.016 seconds.