O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Subreports

If you are placing subreports inside your report, they are usually joined to the report. This means that the subreport only displays data that refers to the main report’s corresponding record. You can use the subreport’s control element’s properties Link Master Fields and Link Child Fields to define the relationship between the main report and the subreport. You can only create such a link if the main report’s and subreport’s Record Source is a query or a view, respectively.

If you defined a stored procedure as the main report’s Record Source, you can manually create the relationship between main report and subreport yourself using the report properties. The wizard for defining the relationship does not work.

If the subreport’s

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required