...
The Base Criteria tab includes all foundation selection options for a report. Base criteria includes report options for major work flow stage, job status, division, region, and region/division. Making a selection for the base criteria is effectively selecting the pool of jobs to be searched.
Selecting a major work flow stage such as pre-administration, administration, construction, or maintenance will automatically select its minor stages. Individual minor work flow stages can be selected or de-selected by clicking the required stage name.
| Info |
|---|
...
| Selection of too many options may result in too many, too few, or no results on the report. |
The Groups tab is divided into five sections:
...
Procedures
Selecting Base Criteria
| Info |
|---|
...
| Multiple selections can be made. If no ticks are present, the entire database will be searched. |
- From the Major Work Flow Stage group, select the required stages.
- From the Job Status group, select the required job status.
- From the Division group, select the required divisions.
- From the Region group, select the required regions.
- From the Region/Division group, select the required region/divisions.
...
The Field Criteria tab is used to select specific field criteria that will be used for report record selection. As the Standard Criteria dialog is based on an already established report, some criteria may already appear in the Required Criteria list.
...
| Info |
|---|
| Selection of too many options may result in too many, too few, or no results on the report. |
The Field Criteria tab is divided into four sections:
- Groups: Displays the available field criteria groups.
- Fields: Displays the fields available for a selected group.
- Required Criteria: Selected criteria that MUST be satisfied by the report results. Though multiple fields can be used as criteria, a particular field can only added to the Required Criteria list once. Required criteria is an AND operator.
| Info | ||
|---|---|---|
|
...
| If you add House Type = A and House Type = B, there will be no results returned because there will be no records that have more than one house type allocated. The records returned for the criteria in this panel must match each of the fields listed. To search for records that have House Type A or House Type B, these must be added in the Optional Criteria by Group list. |
- Optional Criteria by Group: Selected criteria that may be satisfied by the report results. Up to ten optional criteria groups can be selected. Optional criteria is an OR operator, meaning that the records returned could have any of the criteria listed.
...
| Info | ||
|---|---|---|
| ||
| If you want to see all the records that have been allocated to Administrator A and Administrator B, these can be entered as Optional Criteria Group 1 and Optional Criteria Group 2. Records that have Administrator A or Administrator B allocated will be considered in the results. |
...
| Tip |
|---|
If using Optional Criteria By Group, more than one should be created. If there is only one selection, users should place that criteria in the Required Criteria list. |
Procedures
Adding Criteria To A Report
| Tip |
|---|
...
Default criteria in the Required Criteria list can be modified by double-clicking on an item. |
- From the Groups list, select the required criteria group. The Fields list will be updated.
- From the Fields list, select the required criteria.
- Select the Required Criteria or Optional Criteria By Group list to which the criteria will be allocated.
- Click
. The Field Criteria dialog will be displayed. The tab displayed is determined by the data type of the selected field (Boolean, Number, Currency, Data, Time, String, or List).- Select the field criteria option(s).
- Click OK. The Field Criteria dialog will close and the new item of criteria will be displayed in the chosen list.
...
The Groups tab is used to identify the way in which the printed report will be grouped. Groups are further sub-headings within a report (for example, a report may display grouped headings based on regions (e.g., east, west, north, south) or the work flow stage (i.e., pre-administration, administration, construction, maintenance)). The default report groups for the selected report are automatically displayed in the Report Groups list.
The Groups tab is divided into three sections:
...
- From the Groups list, select the required field group. The Fields list will be updated.
- From the Fields list, select the required field to group on.
- Click . The Report Groups list will be updated.
| Info |
|---|
...
| As not all field content is suitable to be used as a group, the Fields list may display less data than was available on the Field Criteria dialog. |
Standard Criteria Dialog - Sort Tab
The Sort tab is used to identify the way in which the records on the printed report will be sorted within each group.
| Info | ||
|---|---|---|
|
...
A report may be based on an alphabetical ordering of the client name or a descending client number. |
Each report includes one or more default sort templates, which can be selected to determine the sort order of the records on the report. These are Client Reference Name, Job Address, and Site Start, Job Address. Any of these can be selected and moved to the Sort Fields list by clicking .
...
Standard Criteria Dialog - Multi Print Tab
| Info |
|---|
...
| The Multi Print tab is only available by printing, instead of previewing, a report. |
Multi print is a feature of Framework ECM reporting that allows a separate report to be printed for each member of a list or entity field.
Multi print provides a quick solution to printing many standard reports with the same criteria for a number of different members at one time, drastically reducing the time taken to select criteria and printing these reports separately.
Procedures
Creating A Multi Print Report
...
The Formulas tab is used to view and edit the properties of the default report formulas. It is used to show or hide specific areas of a report that have formulas attached. Only the value of an existing formula within the report can be edited on this tab.
...
| Info |
|---|
| Formulas are added to a report template via the Template screen |
Procedures
Changing The Value Of A Formula
...
The Advanced tab is used to make specific changes to a selected report. This is useful to record details of the criteria or to give a title based on the report outcome required.
...
| Info | ||
|---|---|---|
| ||
| If a standard administration report is being run to determine outstanding permits, this can be typed into the Title, Description or Notes fields. |
A report based on an existing profile with some modifications can also be saved as a new report. This is particularly useful when such a report will be used regularly, removing the need to enter the same criteria each time the report is printed.
| Info |
|---|
...
| When OK is clicked, any changes to the current report will only be applied to the current preview or print. It will not save any criteria selections. To update the criteria selections for the profile permanently, or to create a new profile based on the current one, use the Save button. |
Report Group
Field | Description |
|---|---|
Type | Type of report. In many reports, this is automatically populated. Example: Work Flow, Production Schedule, Activity, etc. |
Title | Title of the report. |
Description | Description of the report. |
Notes Group
Field | Description |
|---|---|
Special | Free text area for notes regarding the special notes. This text may appear on the resulting report, depending on the report appearance and structure. |
User | Free text area for notes regarding the user notes. This text may appear on the resulting report, depending on the report appearance and structure. |
Base Selection Formula Group
Field | Description |
|---|---|
Base Selection Formula | Add or modify the current Crystal Reports base selection formula. Example: This formula option is used when the report requirements exceed those that can be met by the field criteria available. |