Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

9.16 More Unlinked Examples

Unlinked with a Formula

Formulas are used with unlinked subreports so that information can be passed to the subreport without filtering any data. The benefit of using a formula is that although the subreport isn’t linked, you can still pass information from the main report to the subreport. This information can be displayed on the report or used in the subreport’s formulas.

To create an unlinked formula field, go to the Link tab and select the formula from the main report’s list of available fields. Once the formula has been selected, the frame at the bottom of the dialog box appears and the parameter name is already filled in. Since this is an unlinked report, click on the checkbox labeled, “Select data in subreport based on field”, to deselect it. This causes the linking field dropdown box to become disabled and no linking field will be specified. The parameter field in the bottom left corner of the dialog box still gets created, but it doesn’t get linked to a specific field in the subreport.

When the subreport runs, it can reference the parameter that is created by this dialog box to get the formula’s value from the main report.

Unlinked with Shared Variables


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!