Ad Hoc Reporting

Data stored within Campus can be used to define, design, display, and report information needed for instruction, reports, and communications. Ad Hoc Reporting tools provide users with the ability to filter, display and report specific database information based on defined criteria. Ad Hoc filters can also be used in conjunction with many reports throughout Campus to further filter results to a specific set of data or students.

For more help on Ad Hoc Reports please visit Campus Community for videos, instructions, and hands-on labs.
- Direct Link to Ad Hoc Reporting: https://kb.infinitecampus.com/help/ad-hoc-reporting
Visit our Campus Support page for details on accessing Campus Community.

1 Components to the Ad hoc Reporting Tool
2 Filters
3 Reports

Components to the Ad hoc Reporting Tool

Tool/Article	Description

Tool/Article	Description
Batch Queue	The Batch Queue tool generates large, system-intense reports. It helps prevent report time-out errors and/or system performance issues. General system usage can continue while complex reports are generated in the background within the Batch Queue.
Data Export	The Data Export tool enables viewing results from Ad hoc filters applied to any school and calendar data within your state in various report formats. Any Ad hoc filters established through the Filter Designer can be utilized to generate a report with this tool.
Data Viewer	The Data Viewer is a user-friendly report-building tool that allows users to drag and drop fields into a real-time view of the report as it is being built.
Letter Builder	The Letter Builder tool allows users to combine Ad hoc filters with letters designed in the Letter Designer tool to generate specific letters based on a filtered dataset (such as a select set of staff or students).
Letter Designer	The Letter Designer allows you to create custom letters using a WYSIWYG editor. Once created, letter designs can be combined with filters and generated into targeted letters via the Letter Builder tool.
Filter Designer	The Filter Designer allows you to select nearly any data elements within the product and filter school and calendar data using these elements to view and report a select data set. These filters can then be saved and used to filter functionality throughout Campus.
Manage State Ad hoc Filters	Ad hoc filter publishing allows State Edition users to create and maintain Ad hoc filters that are automatically published to districts connected to the State Edition via DIS. This functionality lets you publish filters to connected districts, unpublish or remove State filters, and revise and republish filters back to districts as necessary. District users also have the ability to export Ad hoc filters into a file that can be imported into State Edition.
Pivot Designer	The Pivot Designer tool allows you to analyze, interpret, and visually present crossed-referenced data in easy-to-understand charts and graphs.

Filters

What is a filter? In terms of data reporting, a filter is simply a tool that narrows down a large set of data into a smaller, more manageable set. For example, consider a birthday report you would like to generate based on all students in your school. You could easily create this by grabbing the student name and date of birth when creating your report. But suppose you wanted to limit your results to the month of August? This is where you would use a filter. By limiting your results to the month of August, you have ‘filtered’ your data set to just the information that you need.

Filters can be this simple, but they can also get much more complex, depending on the type of report you are trying to generate.

Reports

After you have created one or more filters, you can create a report based on this filter. A report is simply a set of data that is formatted in a useful way, such as a spreadsheet or PDF document that can be organized however you wish. In addition, there are many reports already built-in to Infinite Campus that can utilize ad hoc filters you create.

Pages in this section include: