Print "QuickReports" opens a column type "Report Editor". It is limited in its flexibility but is fast and simple to use.
Print menu report QuickReport Filemenu
Use the QuickReport feature to:
Produce lists of records.
Create "Break" areas.
Compute Summary Calculations.
Use fonts and styles in the report.
The "QuickReport Editor" produces reports from the current selection of records. Before printing a report, set the current selection of records using the "File Selection" dialog box.
Play Movie: q0_Print.MOV
Play Movie: q1_Print.MOV
Play Movie: q2_Setup.MOV
Adding Breaks, subtotals
Play Movie: q3_Addin.MOV
Hiding the D (data) Row
Play Movie: q4_Hidin.MOV
Play Movie: q5_Hidin.MOV
Page Setup, setting the page and adding titles, page numbers and dates
Play Movie: q6_Page_.MOV
Formulas/Related, making reports smarter
Play Movie: q7_Formu.MOV
Automating reports, adding to DefinedReports
Play Movie: q8_Addin.MOV
Play Movie: q9_Examp.MOV
Play Movie: qA_QR_Su.MOV
When "QuickReports" are created, these items can be specified:
Columns that display fields or formulas
Sort levels and order.
Formats for numeric data.
Font, Font size, and Font style for calculations and data
Page Headers and Footers
A "QuickReport" can be printed:
On the standard printer selected in the chooser.
On a serial printer.
To a graph.
This section describes basic operations used when working with the "QuickReport Editor" to design a report.
Creating a New QuickReport
The "QuickReport Editor" facilitates the creation of columnar reports.
To create a "QuickReport" design follow the steps below.
1. File menu > Print QuickReport
If this step is taken from the splash screen, the "File Selection" dialog box opens. If this step is taken from an Output layout, the "QuickReport Editor" opens, by-passing the "File Selection" dialog box.
The "File Selection" dialog box contains:
File Choice area where the desired file is chosen by highlighting it.
All button selects all records in the chosen file for the report.
Change Selection button opens the "Search Editor".
Sort Current Selection button opens the "Sort Editor".
Status Fields which contains information on the number of total records in the highlighted file, as well as the number of records in the current selection. The records in the current selection are used for the report.
2. Choose the file desired by highlighting it in the "File" area.
3. The status of that file is displayed in the "Status" Field. In file at start up is the total number of records in that file. "Current Selection" is the number of records in the current selection. The current selection is used for the report.
If the current selection needs to be changed, click the "Change Current Selection" button.
4. When the current selection and file are the ones desired, click the "OK" button.
CommerceExpert/WebClerk displays the "QuickReport Editor". If an existing design is displayed, choose: File menu > New to begin a new "QuickReport" design.
The QuickReport Editor
This section describes the main features of the "QuickReport Editor".
The "QuickReport Editor" contains the:
Field Selection area, which lists the fields in the current file.
File Choice Popup menu, used to choose a files. Click and hold the mouse down in the area between the two arrows and a Popup list of file choices appears. To select a file, highlight it and release the mouse.
Sort area, that displays the Sort order assigned to the report. It also contains the <<Add Sort>> marker, used to set Sort levels.
To set a Sort, drag the <<Add Sort>> marker over to the column with the column Header of the field to be Sorted. Let go and the field used in the Sort appears in the "Sort" area.
Report with frame check box, adding a rectangular frame to the report if activated (X).
Various calculations check boxes, used to place summary calculations in the"Break" and "Total" areas of the report.
Column indicators indicating the boundaries between columns of the report.
Auto column width check box, used to request the "QuickReport Editor" to compute a column width based on the maximum length of the contents of the column. This option can be activated for each column individually. This check box does not refer to the entire report.
If "Auto Column Width" is activated, the "QuickReport Editor" computes column widths at the time the report is printed. If "Auto Column Width" is not activated, column widths can be modified by dragging column indicators.
Repeated values check box, is used to request the "QuickReport Editor" to display or hide the values of a column being used as a "Break" column. If repeated values is not activated, the same value is not repeated within a "Break" level.
Right margin marker, indicating the right margin of the report. The right margin marker is meaningful only when no columns have "Auto Column Width" activated. On a 9 inch monitor, the "Quick Report" layout must be scrolled to the right to view the Right margin marker.
Column header, displaying the names of Fields or Formulas added to the report.
Row label bar, showing the different areas of the report: the "Header", "Detail", "Break", and "Total" rows.
Header row, containing the wording that appears in the printed report above the records. The "Quick Report Editor" automatically places field names in the "Header" row, but its contents can be modified.
Detail row, containing information from individual records and is repeated in the printed report for each Break.
Break and Totals rows, displaying summary calculations and any associated labeling. The "Break" row displays summary calculations for each subgroup in the report and the "Totals" row displays summary calculations obtained from all records in the current selection.
Cells, which are the intersection of a row and a column.
Scroll bars, for viewing parts of the "QuickReport" design that extend beyond the area of the "Quick Report" layout.
Selecting Rows, Columns, and Cells
When designing a "QuickReport", rows, columns and cells must be selected in the "QuickReport" layout. A cell is the intersection of a row and a column.
To select a row, click on the "H", "D", "B", or "T" marker on the left of the "QuickReport" Layout. Or click in a row to the right of all columns in the "QuickReport" layout.
To select a column, click above the "Header" row of a column.
To select a cell, click on the cell.
Adding and Modifying Text
Text in the "QuickReport" layout can be modified. Text can be used to label parts of the report. For example, if summary calculations are requested, text can be added to other cells in the "Break" and "Total" rows to label the summary calculations.
Edit the text that the "QuickReport Editor" automatically adds to the "Header" row of the report.
Insert text in empty cells of the "Break" and "Totals" rows.
Insert the value of a "Break" field in the "Break" rows.
Specify font, font size, justification and style for any text that appears in the report.
To add text, follow these steps:
1. Click twice on an empty cell in the "QuickReport" layout.
A text insertion point appears in the cell.
If a label for a summary calculation is desired, select a cell in the same row as the cell containing the "Calculation" icon. Text cannot be entered into the same cell that contains summary calculations.
2. Type the text in the chosen cell.
To modify text, follow these steps:
1. Drag across the text in the cell to be modified.
The selected text is highlighted.
2. Type the new text in the cell.
Specifying Font, Font Size, Justification and Style
While designing the "QuickReport", different fonts, font sizes, justification and styles can be specified. Specifications can be applied to rows, columns or cells in the "QuickReport". They also can be applied to text, data and summary calculations.
If specifications are assigned to the detail row of the report, the results won't be visible until the report is previewed or printed.
To specify a font select the column, row or cell to apply the font. Choose a font from the Font menu.
The font is applied to any text, data or summary calculations that appear in the "Selected" area.
To specify a font size, style or justification select the column, row or cell and choose a font size, style or justification from the Style menu.
The font size, style or justification is applied to any text, data or summary calculations that appear in the "Selected" area.
Adding Columns to the Report
Columns are created by dragging field names from the "Field Selection" box to the "QuickReport" layout. Use the "Cycle" arrows, in the "Field Selection" box, to display field names from other files in the database. It is possible to add fields from related files to the report.
To add a column, drag the name of a field to the right of existing columns in the "QuickReport" layout and release the mouse button.
A column is created for the field, and the field name is placed in both the column "Header" and the cell in the "Header" row.
By default, CommerceExpert/WebClerk prints the field names as column heads at the top of each page, in the "Quick Report".
NOTE: If you use a subfield in a "QuickReport" design, the report lists all values of the subfield for each "Parent" record. Sorts cannot be performed on a subfield.
Columns can be inserted betw