Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

9.11 Linking to Subreport Parameters

Linking to Subreport Parameters

If the subreport has parameter fields in it, when the user refreshes the report they are prompted to enter values for the subreport parameters. If you don’t want the user to be prompted to enter a parameter value, you can link a field from the main report to the subreport parameter. This automatically populates the subreport parameter field with a value from the main report without prompting the user.

To link a field from the main report to a subreport parameter, right-click on the subreport in design mode and select Change Subreport Links. This opens the Subreport Links dialog box previously shown in Figure 9-4. In the Available Fields list, double-click the field from the main report that holds the value you want to pass to the subreport parameter. This adds the field to the Fields To Link To list on the right.

When you move a field to the Fields To Link To list, Crystal Reports’ default behavior is to automatically create a matching parameter in the subreport which is passed the value from the main report. If you look in the bottom left hand corner of the dialog box you’ll see that there is a parameter...

Get UNLIMITED Crystal Reports Online Training!

Click Here To Start Your Training!

1500+ Tutorial Pages

Complete Crystal Reports Online Training with over 1,500 pages of better than book quality Crystal Reports tutorials.

Step-by-step Online Videos

Learn at your own pace from the comfort of your home! Pause, rewind and watch online training videos anytime!

Online Community

Members-only community where you can post and answer questions. The community is checked on a regular basis by best selling Crystal Reports book author Brian Bischof to help answer your questions.

Cut & Paste Source Code

Save time with simple cut and paste source code you can use right now in your next report!

Click Here To Start Your Training!