Users can create a custom report by combining rows of data from different ad hoc reports into a single new report. The rows of data used for the custom report may come from different data sources such as student, assessment, staff or finance.
Creating a Custom Report
- First build an ad hoc report containing at least one piece of the data desired for the custom report.
![](https://i1.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/Fall-Enrollment-by-Grade-1024x458.png?resize=1024%2C458)
- From the “Report Options” box, click Custom Report to On
![](https://i1.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/Custom-Report-Adhoc.png?resize=248%2C818&ssl=1)
- The “Add” button to the left of each row of data, is now displayed.
![](https://i2.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/Add-Button-Custom-Reports-1024x224.png?resize=1024%2C224)
- Select the “Add” button to move/copy a single row of data to the custom report
- “User Report Wizard” box will display with the row in the Report Preview
![](https://i2.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/User-Report-Wizard-Box_V2.png?resize=284%2C353)
Follow the steps below to insert the row of data into a custom report.
- Step 1 – Is this a new or existing custom report?
- If New, provide a Report Name
- As you type the report name, it will appear in the Report Preview below
- If Existing, select the report in the drop-down box
- Click ‘Next’
- If New, provide a Report Name
![](https://i2.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/New-Custom-Report.png?resize=270%2C329)
- Step 2 – Are you adding this row to a new or existing Column in the custom report?
- If New, provide a Column Label which will be the title for the column
- As you type the Column Label, it will appear in the Report Preview below
- If Existing, select the appropriate Column for the row to be inserted. (Use this to add the same type of data to an existing column, i.e. all of the grade level rows.)
- Click ‘Next’
- If New, provide a Column Label which will be the title for the column
![](https://i2.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/User-Report-Column-Label.png?resize=278%2C343)
- Step 3 – Row title will default to the row selected from the adhoc report, but it may be relabeled at this time, if desired.
- Default
- Relabeled
- As you type the Row Title, it will appear in the Report Preview below
- Default
![](https://i0.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/Row-Title-Custom-Report.png?resize=327%2C406)
- Click ‘Submit’
- Step 4 – Close Wizard to add another row of data from the existing ad hoc or Go to report to view the report created with the wizard so far.
![](https://i0.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/Report-Created-Custom-Report-Wizard.png?resize=187%2C251)
Continue to add additional rows of data to the custom report from this adhoc report or create another ad-hoc report.
NOTE: Rows can come from different ad hoc data sources.
Example: Use student to determine counts of students, use staff, to obtain counts of staff, and/or use finance to pull amounts.
Accessing My Custom Reports
The custom reports created will be located in “My Custom Reports” (black menu bar)
![](https://i1.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/My-Custom-Reports-Tab-V2-1024x285.png?resize=802%2C223)
From the My Custom Reports center, open the report by clicking on the hyperlinked title
![](https://i1.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/11/Custom-Report-Example-1024x450.png?resize=1024%2C450)
- Edit the report
- Be sure to click ‘Save’ at top once changes are made
- Tools drop-down
- Export to Excel
- Bookmark
- Heatmap On
- Select a Focus List to run the report with and click ‘Submit’