Page N of M ( for example Page of ). The position to specify is either Top of Page (header) or Bottom of Page (footer). Possible alignment, which may be specified are Centre, left, right, inside and outside. Adding and Deleting Report Controls : After a report has been designed, additional report controls may be added or deleted by the same procedure as applicable to forms.
Clicking tool bar icon opens report design tool bar, which contains a set of useful controls. (a) After opening the report in design mode, click Field List button on report design tool bar. This results in opening the field list window. (b) Drag the field into an appropriate section of the report.
The field appears with both label and text box control. The label part gives a constant field heading while the text part provides different values of the field. These two parts are accordingly placed at the appropriate sections of the report. (c) A field control may be deleted by selecting the control and pressing the Delete key.
Conditionally Formatting Report Controls : The conditional formatting of text boxes and combo boxes in reports can be achieved in the same manner, as it applies to Forms. The conditional formatting allows the designer to apply special text formats that depend on the value of field. This facility is a useful tool to draw the attention of user or reader of report to some values of particular interest, such as amounts exceeding certain limit or unexpected balances in some accounts. In order to create a conditional formatting, following steps are required: (a) Open the report in design view.
(b) Select a control and click at format on menu bar, followed by conditional formatting. (c) Provide the necessary conditions for formatting to occur in the same manner as already discussed while applying conditional formatting to design of Forms. (d) The conditional formatting is removed by re-opening the same dialog and clicking at delete button. Grouping Levels and Sorting Order : The purpose of grouping is to organise the information content of a report into