Unit 12. Reports (IV).


The Toolbox

 

To define what information should appear in the report, and in what format it should be, the same controls can be used as in a form although some controls for example the command buttons are more appropriate for a form.

In the Toolbox we have a button for each type of control that can be added to the report.

If the Toolbox does not appear click on the button on the toolbar.

When we want to change various controls of the same type we can block the control by double clicking on it (a dark line will appear around it). As from this moment you can create all the controls of this type that you want without having to double click on the corresponding button every time. To remove the block we click on the button.

The box contains the following types of controls:

The Label serves to visualize a fixed text, text that we type directly into the control or in its Caption property.

The Text box is used mostly to present a data stored in a source field of the report. This type of textbox is called an Dependant textbox because it depends on the data from one field. Textboxes can also be independant, to present the results of a calculation for example. In the Control source property we have the field of the table that is associated (when it is dependant) or the formula of thr calculation when we want it to present the result of this calculation, in this last case we need to preceed the formula with a = sign.

The Options group is used to present a limited combination of alternatives. It is usually used more for forms, for more detail revise the forms unit.

The Alternate button is usually used to represent a Yes/No type field, if the field contains the Yes value the button will appear depressed.

The Option button is usually used to represent a Yes/No type field, if the field contains the Yes value the button will appear like this , if not it will appear like this.

The Verification box is usually used to represent a Yes/No type field. If the field contains the Yes value the box will appear like this , if not it will appear like this .

Combo box , Listbox , Options group , Command button and Tab control . These are usually used more in forms, for more detail revise unit 11.

Image control to insert images into the report, this image will not change when changing the record.

Unbound object frame is used to insert controls like a Word document, a graphic, etc... They will be controls that do not change when changing a record.

Bound object frame is to insert an image or an object that will change from one record to another.

Page break , is used to force a new page even if you have not reached the end of the page.

We can also create a subform . A subreport is a report that is inserted into another. The primary report is called the principal report , and the report within the principal report is called the subreport. A report/subreport combination is often called a hierarchical report, principal/detail report or principal/secondary report.

Line to add a line to the report.

Rectangle to add a rectangle to the report.

And finally we can add more complex controls with the button.

We see that the management of controls in reports is identical to the controls of a form., if you have any doubt about how to add a control, how to move it, copy it, change its size, how to adjust its size, or aligning the various controls revise the previous unit.



 

Page. 12.4

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.