“Subreport”

A “Subreport” shows data related to the data in the main report.
For example, to see the songs from an album, I add a “Subreport” to the “Songs” table.

To add a “Subreport”, you first go to “Design view” in the main report.
Again, we have different ways to add a “Subreport”.
In this example, I use the wizard.
Select the “Wizard” button in the “Ribbon” under the “Design” contextual tab and click the “Subform / Subreport” button.
Click and drag in the main report at the place where you want to insert the “Subreport”.

This opens the first window of the wizard.

In this window, we determine where the data in the “Subreport” is to be retrieved.
From a “Table” / “Query” or a “Form” / “Report”.
I choose the “Songs” table.
In the second window, you determine which fields from the “Report” and the “Subreport” are linked to each other.

If you choose the first option “Select from a list”, then “Access” will determine which fields are eligible.
As an example I choose the “Make My Own” option.
This opens fill boxes where you have the linked fields for the “Report” and the “Subreport” fields.

These fields, of course, would not be shown if you had chosen the “Select from a list” option.

I choose the “albumID” field for both the main report and the “Subreport”.
And click “Next”.
This takes you to the last window of the wizard where, you enter a name for the “Subreport”.
Click the “Finish” button.
See the result in “Report View”:

Multiple “Columns”

When the data in our “Report” does not use the full page width, we can create a “Report” with multiple “Columns”.

To do this, first go to the “Design View”.

In this example I will place the data in two columns.
First, I must know whether the width of my “Report” is wider than the half of the width of my paper or not. Otherwise, the data from the second column will only be partially or not at all printed.
To create a “Report” with three columns, these can not be wider than 1/3 of the width of the paper. But that is something you can do by yourself.

Eventually, you can make use of the ruler.
This button can be found in the “Arrange” contextual tab.

Select the “Page Setup” and click the “Columns” tab.
This opens the “Page Setup” dialog in which the “Columns” tab is selected.
Specify the number of columns in the upper textbox.

You have some other options also.

• “Row Spacing”: allows you to create more white space between records.
• “Column Spacing”: allows you to create more white space between columns.
• “Column Size”: you set this in “Design View”, but you can still customize if you wish.
• ” Same as detail” : default, and will set the same width and height for different columns. If this is unchecked, you can adjust the column width and height in the upper boxes.
• “Column layout”: determines how records be printed, “Down, then Across” or “Across, then Down.”

Click OK.

Choose the “Home” tab, click the “View” button and select “Print Preview”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats