This page will walk users through the New Report Wizard and demonstrate how to create a new report from start to finish.
In the main menu, click the Create New Report icon.
There are several types of reports, the most common being an Advanced Report.
Note: This page will focus on building an Advanced Report. For information on the other types of reports, see Report Types.
The Report Wizard will open. The Report Wizard has five tabs: Names, Categories, Sorts, Filters and Layout. The Name and Categories tab must be completed while the other tabs are optional.
Click on the below links for details:
Name Tab
In the Name Tab, enter a report name and click on the folder where the report will be saved.
The report name can be up to 255 characters long. The following special characters may not be used: ? : / \ * “ < >
The report's description appears at the bottom of the main menu when it is selected. The description text may also be used to search for a report.
Note: You cannot create a report inside a folder that is read-only (lock Icon)
Categories Tab
In the Categories Tab, select the data categories that you would like to access to on the report. It is important to understand two terms: Data Category and Data Field.
Data Category - A data category is a data object that has several attributes. For example, Students is a category; each student has an id, a major, an advisor, etc.
Data Field - A data field is a single attribute within a category. For example, Students.ID is the numeric value that identifies a specific student.
To add a data category, either drag and drop it to the 'Category Name' column, use the Add button, or double-click the category.
To search for a specific data category or folder, type its name into the Search box.
To see what data fields are in a data category, click on a data category and then click the information button.
Check the 'Suppress Duplicates' box to compress any repeated records from that category.
To remove a data category, click the delete button.
Sorts Tab
In the Sorts Tab, specify which data fields will be used to determine the order of data on the report.
To sort by a data field, either drag and drop it to the 'Sort By' column, use the
Add button, or double-click the field.
You can sort each data field in ascending (A-Z, 0-9) or descending (Z-A, 9-0) order.
Use the Move Item Up and Move Item Down icons to indicate the sort priority.
To remove a sort, click the Delete icon.
Note: Sorts are not mandatory in order to create a report. Sorts allow for more complex organization of a report. but do not bar the report wizard from continuing if left blank.
Filters Tab
In the Filters Tab, create statements that will be used to filter the data when you run a report.
There is no limit to the number of filters that can be defined. Filters can be numeric (up to eight decimal places) or alphanumeric.
To filter a Data Field, either drag and drop it to the ‘Filter By’ column, use the button or double-click it.
Use the Move Item Up and Move Item Down icons to indicate the filter priority.
To remove a filter, click the Delete icon.
Set the operator (equal to, less than, one of, etc...) by selecting it from the Operator dropdown.
Set the filter value by either entering it manually or selecting a value from the dropdown. If the Data Field is a date, the calendar and function buttons can be used to select a value.
Choose AND With Next Filter to require that the selected filter and the one below it both evaluate to true. Choose OR With Next Filter to require that either or both be true.
Check Group With Next Filter to group the filters. Filters can be nested indefinitely by using the following keyboard shortcuts while a filter is selected:
Ctrl + [ adds an open-parenthesis before the selected filter.
Ctrl + ] adds a close-parenthesis after the selected filter.
Ctrl + Shift + [ removes an open-parenthesis from before the selected filter.
Ctrl + Shift + ] removes a close-parenthesis from after the selected filter.
Check Prompt for Value to prompt the user for a new filter value at the time the report is executed.
Note: Like Sorts, Filters add complexity to a report, but their completion is not mandatory.
Important: If a filter is chosen, the above fields must be completed or the report will not execute.
Layout Tab
In the Layout tab, select the Data Fields that will appear on the report. For each Data Field chosen, the report will automatically create a column header and place the Data Field in the detail section. Additionally, subtotals, grand totals, and a page header/footer can be created.
Display Data
To place a Data Field on the report, either drag and drop it to the Data Field column, use the Add button, or double-click the field.
Use the Move Item Up and Move Item Down arrows to indicate the order the Data Fields should appear on the report. The Data Field at the top will appear on the report as the left-most column.
The Summary Function column is used to make subtotals and grand totals. See Subtotals and Grand Totals for more information.
To remove a Data Field, click the Delete icon.
Using the Summarize By box, you can display subtotals, grand totals, or headers for the values of a Data Field.
Subtotals and Grand Totals
To display subtotals, check the box of the category you want subtotals for in the Summarize By box. Then, for each Data Field you want totaled, select a Summary Function (see below).
To display grand totals, check the Grand Total box. Then for each Data Field you want totaled, select a Summary Function (see below).
Summary Functions
Sum: Totals the all of the data in the Data Field.
Count: Returns the number of rows in the Data Field.
Average: Takes the mean of the data in the Data Field.
Minimum: Displays the lowest value in the Data Field.
Maximum: Displays the highest value in the Data Field.
Data Headers
A checkbox will appear in the Summarize By box for each Data Category in the Sorts tab. To display a header for each value of a Data Field, click on the associated Data Category in the Summarize By box. Click the Data Category name next to the checkbox, and the will appear.
To include a Header, check the Include Header at the beginning checkbox. In order to select the text that will appear as the header value, use the Header dropdown to select a Data Field or use the Formula Editor icon to create a formula.
Use the Summarize by each unique dropdown to specify if the header should repeat based on a specific field or fields within a Category.
Check the Include Total at the end checkbox to have a subtotal created for this Category.
To see the report in the Report Designer, click Finish.
The Report Designer will display the report like this.
Note: For information on the toolbar and all its features, see Using the Toolbar.
Next Article: Grouping Basics