Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Access 2010 : Building Reports Based on More Than One Table (part 3) - Working with Subreports

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
1/23/2015 8:38:27 PM

Working with Subreports

When you add a subreport to a report, it’s important to understand what properties the SubReport Wizard sets so that you can modify the SubForm/SubReport control, if needed. You should become familiar with the following properties of a SubForm/SubReport control (see Figure 11).

Figure 11. Properties of the SubForm/SubReport control.


  • Source Object This control specifies the name of the report or other object that’s being displayed within the control.

  • Link Child Fields This control specifies the fields from the child report that link the child report to the master report.

  • Link Master Fields This control specifies the fields from the master report that link the master report to the child report.

  • Can Grow This control determines whether the control can expand vertically to accommodate data in the subreport.

  • Can Shrink This control determines whether the control can shrink to eliminate blank lines when no data is found in the subreport.

Not only should you know how to work with the properties of a SubForm/SubReport object, but you should also be able to easily modify the subreport from within the main report. You can always modify the subreport by selecting it from the list of reports in the Database window. To do this, you select the report you want to modify and then click Design. You can also modify a subreport by selecting its objects directly within the parent report.

You can open a subreport in its own separate Design view window by right-clicking the subreport and selecting Subreport in New Window.

Other -----------------
- Microsoft Access 2010 : Building Powerful Reports - Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Building Powerful Reports - Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Building Powerful Reports - The Anatomy of a Report
- Microsoft Visio 2013 : Adding Sophistication to Your Drawings - Grouping shapes
- Microsoft Visio 2013 : Adding Sophistication to Your Drawings - Inserting fields: the basics
- Microsoft Visio 2013 : Adding Sophistication to Your Drawings - Using shape data
- Microsoft Visio 2013 : Adding Sophistication to Your Drawings - Adding ScreenTips and comments
- Microsoft Visio 2013 : Adding Sophistication to Your Drawings - Positioning shape text
- Automating Windows 7 Installation : Using Windows System Image Manager (part 3) - Creating an Unattended Answer File
- Automating Windows 7 Installation : Using Windows System Image Manager (part 2) - Exploring the Components of an Answer File
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer