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.


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:



Department of Accountability & Other Support Services
Division of Information Management