Embedded Files
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.
Creating an Ad Hoc Filter Guide
Creating an Ad Hoc Filter Guide
The Ad Hoc Reporting module allows a user to create and run queries for various types of data in Campus. The queries and may be exported out of Campus or used to filter canned reports throughout the product.
Main Menu > Reporting > Ad Hoc Reporting
3. Click Filter Designer
4. Click Filter Type: Query Wizard.
5. Click Data Type:
• Student
• Census/Staff
• Course/Section
6. Click Create.
7. Enter the Query Name of the Ad Hoc filter to know what data is being included.
8. Add Short Description and Long Description, optional.
9. Select Categories & Fields. There is a search option to limit the number of fields displayed.
10. All fields: Click the + symbol to the left of the field type to expand the selection. Click on the field to move it to Selected Fields column.
11. Click Save or Save & Test to review data generated by the selected fields, if selections are complete, exit or,
12. Click Next.
13. Define specific constraints use the drop-down to select the Operator and/or Value to the filters on the fields shown.
• For example, to EXCLUDE students who are not in the 3rd grade, use the operator “=” so that only students who have a grade level of 03 will only show in the filter.
14. Click Save or Save & Test to review data generated by the selected fields, if selections are complete, exit or,
15. Click Next.
16. Uncheck the OutpuSeq, If you do not want the data in a field to appear on the report, optional.
17. You can change the order of the fields by entering a Seq sequence number, optional.
18. Enter a Sort number, to sort data based on the number entered, optional.
• For example, below, the data will sort by student last name, student first name and grade since a sort preference of 1, 2, and 3 was entered in the Sort column for the filter.
19. Select the Direction of data for selected sort fields, optional.
20. Enter Column Header, to update field name displayed, optional.
21. Select Alignment, to align text for left, right or center, optional.
22. Select Formatting, to select formatting for Zero Pad, Space Fill, Uppercase or Lowercase, optional.
23. Click Save and Save & Test to review data generated by the selected fields, if selections are complete, exit or,
24. Click Next.
25. Select Group by for selected field, optional.
26. Select Group order for selected field, optional.
27. Select Aggregate/Sub Total buy for selected field, optional.
28. Select Aggregate Type of Record Count, Distinct Count, MIN, MAX, SUM, or AVG for selected field, optional.
29. Click Save and Save & Test and Exit.
Data Export Wizard
The Data Export tool allows users to view the results of Ad hoc filters created using the steps in multiple report formats and files.
1. Select an Ad hoc filter from the Saved Filters window.
2. Select the desired format of the exported Ad hoc filter by clicking the appropriate radio button in the Pick an Export Format area.
3. Select the Export button.
Ad Hoc Reporting Videos
Ad Hoc Reporting Videos
Understand Ad hoc Filter and Report Creation - Whiteboard Video
Adhoc_Whiteboard.mp4Please go to Incident IQ to submit an Ad-Hoc Assistance Request.
1. Select New Ticket, then select Report Issue (Software/ Applications)
2. Select Infinite Campus District Edition SIS
3. Select Ad hoc Reporting
4. Select Ad hoc Assistance Request Form
5. Complete Form and click Submit
Page updated
Report abuse