When you click OK to close the Query by Model Dialog, DataEase displays the Layout Options dialog shown below. This dialog is used to:
Choose a predefined layout for a document.
Change the layout of an existing document
The layout you choose determines how fields are arranged on a document. The Layout Options dialog also lets you display multiple records vertically or horizontally, as well as row numbers, field labels, scroll bars, and other user interface enhancements.
Note: The layout options dialog is not used with a menu.
Field Layout tells DataEase how to arrange the fields on a new document. When you close the dialog, DataEase automatically copies the table columns to the document according to the layout you select. Each Field Layout is illustrated in the Record Layout Preview in the Layout Options dialog.
Record Layout Preview tells DataEase how many records to display horizontally and vertically. By default, DataEase displays one record at a time.
Use the plus and minus buttons to the right of the Preview to indicate the number of records that appear from top to bottom. The buttons below the Preview change the number of records that appear from left to right. The Double plus (++) Sign button simultaneously adds a record horizontally and vertically to your layout.
You can use the Layout Options dialog to change the layout of a document. You can choose Original Form, Field/Line, Movie Credits, Custom, Table, or Table Across. When you create a new layout, DataEase deletes all non-database objects (including background images, buttons, and Object Styles).
If you add or subtract Form or Field objects without requesting a different layout, DataEase displays a dialog asking if you want to create a new layout or merge/transfer your changes into the existing layout. Choose either the Merge or Transfer option (Transfer is generally recommended) to avoid losing the images, buttons, and styles already incorporated into the document.
Choose File>>New>>Form. DataEase displays the New Document dialog.
Choose a Style Sheet and a table and click OK. DataEase displays the Layout Options dialog.
Choose the Custom Field Layout and Record Layout. Choose the Appearance options, corresponding to the items that you want to include in your layout.
Click OK. DataEase displays a form with a blank layout.
Select the Field tool from the Object palette. Position the field icon on the layout and click the mouse. DataEase displays the Field Definition dialog.
Choose a field from the Field Name list. DataEase displays the field characteristics box in the dialog.
Repeat steps 5 and 6 for each field you want to include.
Continue designing the layout of the form, creating any additional objects you want to include.
Choose File>>Save As. Name the new form and click OK.
Choose File>>New>>Report. DataEase displays the New Document dialog.
Click on the Query By Model button in the New Document dialog. DataEase displays the Query By Model dialog.
Double-click the table columns you want to use as fields in the report.
Using the Query By Model dialog, you can add tables, select some or all columns from each table, select specific records, as well as Group, Sort and Summarize the report data.
After you complete your selections, click OK. DataEase displays the Layout Options dialog. Choose the Field and Record Layout that you want and click OK. DataEase automatically creates the report with the selected layout and displays the report in a new window in Designer View.
If you want to run the report and view the data, switch to User View. DataEase displays the Print dialog box.
If you want to view the data, choose Window as the Print destination and click OK. DataEase displays the report data according to the specification of the Query By Model and Layout Options dialogs.