Creating Basic Reports Using the Wizard

Basic reports can be customized using the Basic Custom Report wizard, allowing you to specify the columns, grouping, sorting, and selection criteria.

To create a basic custom report using the wizard, do the following:

1. Open Dashboard, click Applications on the navigation panel, and then click Run a report under Reports.
2. Select a group in the My Reports or Shared Library section on the navigation panel.
3. Click New > Basic > Use the Wizard in the Report group on the Home tab.
4. Select a report type from the list. The report type determines the available fields.
5. Select the fields you want to appear as columns in the report. Explain the components to add, remove, and reorder columns.

Component		Description
Assign		Adds the selected available field to the Report columns list.
Assign All		Adds all available fields to the Report columns list.
Unassign		Removes the selected field from the Report columns list.
Unassign All		Removes all fields from the Report columns list.
Move up/Move down		Allows you to determine the order in which the columns will display in the report.
Move top/Move bottom		Moves the selected field to the top or bottom of the Report columns list, allowing you to position a field as the first or last column in the report.

6. Click Next.
7. Select the fields by which to group identical values in the report. Only the fields selected as columns on the previous window that can be grouped display in the Selected fields list. Explain the components to add, remove, and reorder groupings.

Component		Description
Assign		Adds the selected field to the grouping list.
Unassign		Removes the selected field from the grouping list.
Move up/Move down		Allows you to determine the order in which groups will display in the report.
Move top/Move bottom		Moves a selected grouping to the top or bottom of the list.

8. Click Next to continue to the next window of the wizard.

Note: To return to the previous window, click on the wizard's toolbar.

9. If desired, select the subtotal and the sorting options for the fields in the report. If there are no non-grouped fields after the Grouping window displays, the Subtotal and Sorting window does not display. Explain the components to subtotal and sort values.

Component		Description
Subtotal		Generates a subtotal for a numeric field, if selected, for the grouping.
Sort		Sorts field values according to your selection, Ascending, Descending, or None. Click inside the Sort column to display the sorting options.
Hide Duplicate		Hides duplicate values (available if a field is not grouped and is sorted).
Move up/Move down		Determines the order in which fields will display in the report.
Move top/Move bottom		Moves the selected field to the top or bottom of the Selected fields grid.

10. Click Next.
11. Enter your report filtering criteria by clicking in the blank line that is provided. You can edit existing criteria by clicking a cell in the grid and entering new criteria. To remove a line of criteria, select the line and press Delete on your keyboard or click .

Tip: To view the parentheses columns and the And/Or columns, click Advanced. Click Simple to show fewer options.

Explain the components of the window.

Component	Description
(	Click in the ( column to insert an open-parenthesis before a set of filtering criteria, if needed. Criteria in parentheses is grouped and evaluated first, and then combined with any other filtering criteria to be evaluated. If you need to nest criteria groups, you can click up to three times to insert up to three opening parentheses. Note: The ) column displays only in the Advanced view.
Field Name	Select the field that is evaluated to determine items included in or excluded from the display.
Operator	Select the method used to compare the value to the field. Note: The Between operator filters alphanumeric values, such as client ID-sub ID, as text. For example, for clients IDs 1, 2, 10, and 100, filtering between 1 and 100 only returns results for client IDs 1, 10, and 100. Client ID 2 is not included in the results unless you expand the range to 1 and 200. To include specific clients, we suggest using the In list, Contains, or Like operator when filtering alphanumeric values.
Value	Enter or select the value(s) for comparison. The value may be a number or text, depending on the type of field being evaluated. Date values. If you change the start date for a Date value, you may first need to change the end date to a later date. Or you can delete and reenter the Date row. Client values. For standard reports, when one of the following client-related field names is selected in the Filters grid, you can easily look up clients in the Value column. Client Client ID ClientID.Sub ID Client Sub ID Client name To search for a client, do the following: Click the Select text range button beside the Value field. Enter text for the starting value to display the top search results. As you type, you will see matching items from the most recent search results, with the first matching item highlighted and listed first in the list. You can do the following to select an item: Press Enter to select the highlighted item in the list. Move from the text box to select the highlighted item in the list. For example, press Tab, or select another field or button. Click a record in the list. Enter an ending value. Click OK
)	Click in the ) column to insert a close-parenthesis after a set of filtering criteria, if needed. The number of closing parentheses must match the number of opening parentheses. You can click up to three times to insert up to three closing parentheses. Note: The ) column displays only in the Advanced view.
And/Or	Select AND to indicate data must meet the preceding and the following criteria. Select OR to indicate data can meet either the preceding or the following criteria. Notes: The And/Or column displays only in the Advanced view. The OR connector may return more results than you expect, particularly if All is selected as one of the connected values. Data that meets either line of criteria will be included in the results. For example, if you filter a specific date range in one line and All staff in another line, the report will include results for all staff, regardless if the data is in the selected date range.

Explain the process of creating criteria lines.

1. Click in the ( column to enter an opening parenthesis, if needed. Click repeatedly to add up to three opening parentheses.

Note: If you do not see the ( column, click Advanced.

2. Click in the Field Name column to select a field from the list.
3. Click in the Operator column to select an operator from the list.

Note: The Between operator filters alphanumeric values, such as client ID-sub ID, as text. For example, for clients IDs 1, 2, 10, and 100, filtering between 1 and 100 only returns results for client IDs 1, 10, and 100. Client ID 2 is not included in the results unless you expand the range to 1 and 200. To include specific clients, we suggest using the In list, Contains, or Like operator when filtering alphanumeric values.

4. Click in the Value column to enter the value used by the operator in relation to the field.
5. Click in the ) column to enter up to three closing parentheses, if needed. You must use a closing parenthesis for every opening parenthesis used.
6. If there are additional criteria lines, click in the And/Or column to select AND or OR, depending on the relationship between the lines.

Notes:

• The And/Or column displays only in the Advanced view.
• The OR connector may return more results than you expect, particularly if All is selected as one of the connected values. Data that meets either line of criteria will be included in the results. For example, if you filter a specific date range in one line and All staff in another line, the report will includes results for all staff, regardless if the data is in the selected date range.
7. Repeat these steps for any additional criteria lines. You can enter up to 15 lines.
12. Click Next.
13. Enter a unique name for the report in the box provided.
14. Enter a description of the report in the box provided.
15. Select whether you want to modify the report design, preview the report, or save the report and close the wizard.
16. Click Finish.