Edit a Query in a Print Template

Topic Level: Advanced Report Design

The Data tab is where the queries used in the report can be seen and manipulated. On this tab, advanced database users can create, modify and import/export a data view.

The templates that are in the Properties folder must be based on a query of the Properties table. Similarly, the templates in the Contacts folder must be based on a query of the Contacts table and Enquiries templates must be based on a query of the Enquiries table.

When you save a print template, the following are saved in the file:

•	The Data View that defines the query of the database.

•	The Design layout that defines how the data is presented.

•	The Default Print Range for printing records (as defined in the Print Templates Manager or in the template itself).

The Data View tab

Each query in the data view has its own toolbar:

Here is what each of the icons represents:

	Preview the results returned by the query.
	Database tables used in the query.
	Database fields selected in the query.
	Calculated fields in the query.
	Groups applied in the query.
	Filters applied in the query.
	Sorting applied in the query.
	The join between this query and another.
	The SQL for this query.(NB. Do not edit the SQL directly as this will restrict what you can do in this template's Data View in future)

To add a new field to a query:

•	Select the fields icon on the relevant query.

•	Double click the field you want in the top panel (fields already selected are shown in the bottom panel).

To add a new query to the Data view:

•	Select New from the File menu. You can use either the query wizard or the query designer.