School of the Osage » Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Ad Hoc Basics ======
[[https://kb.infinitecampus.com/help/8ffa013|Ad Hoc Reporting]]

Audience: Person(s) responsible for creating custom reports and have the ability to filter, display and report specific database information based on defined criteria.

Skills:
  * Create queries of data matching user-defined criteria 
  * Create static lists of students
  * Share queries with other users 
  * Build custom reports

On-Demand Training 
Course(s):
  * [[https://university.infinitecampus.com/learn/course/20646/ad-hoc-reporting-basics?generated_by=28615&hash=b585502732550187c331c6ce082f910dd88120b5|Ad Hoc Reporting Basics]] – (0:31)

===== Filter Designer =====
[[https://kb.infinitecampus.com/help/1350754|Filter Designer]]

Topics:
  * Query Wizard
    * Field Selection
    * Filter Parameters
    * Output Formatting
  * Selection Editor
  * Filter by Calendar
  * Share and manage filters


===== Data Export =====
[[https://kb.infinitecampus.com/help/data-export|Data Export]]

Topics:
  * Extract data from Ad Hoc queries into multiple formats


 
===== Data Viewer =====
[[https://kb.infinitecampus.com/help/data-viewer|Data Viewer]]

Topics:
  * Create reports
  * Combine and filter Data Viewer reports with Ad Hoc Filters
  * Copy a report

===== Additional Resources =====

Campus Community:
  * [[https://kb.infinitecampus.com/help/ad-hoc-reporting|Ad Hoc Overview]]
  * [[https://kb.infinitecampus.com/help/understand-ad-hoc-filters-video|Video: Understand Ad Hoc]]
  * [[https://kb.infinitecampus.com/help/query-wizard|Query Wizard]]
    * [[https://kb.infinitecampus.com/help/query-wizard#QueryWizard-FilterOperators|Filter Operators]]
    * [[https://kb.infinitecampus.com/help/query-wizard#QueryWizard-OutputFormatting|Output Formatting]]
  * [[https://kb.infinitecampus.com/help/selection-editor|Selection Editor]]
  * [[https://kb.infinitecampus.com/help/student-filter-fields-for-ad-hoc-reporting|Student Filter Fields]]
  * [[https://kb.infinitecampus.com/help/course-section-filter-fields-for-ad-hoc-reporting|Course-Section Filter Fields]]
  * [[https://kb.infinitecampus.com/help/census-staff-filter-fields-for-ad-hoc-reporting|Census-Staff Filter Fields]]


===== Ad Hoc FAQ =====
==== Can I share filters with other users without allowing them to make changes to the filter? ====
Yes. If users are assigned only READ rights to the User Group Filters tool right, then they will only be able to view filters that are shared with them via user groups.

Knowledge Base: 
  * [[https://kb.infinitecampus.com/help/tool-rights-ad-hoc-reporting|Tool Rights (Ad Hoc Reporting)]]
==== Can I share Data Viewer reports that I’ve built with other users? ====
No. Data Viewer reports cannot be shared with other users via user groups. If you need a report to be shared with other users, it is recommended to build this report through the Filter Designer.

Knowledge Base: 
  * [[https://kb.infinitecampus.com/help/data-viewer|Data Viewer]]
  * [[https://kb.infinitecampus.com/help/1350754|Filter Designer]]
==== How do I know what fields to use for my report? ====
Consider where the data is stored in Infinite Campus. Usually, the field will follow that logical chain the same way. The search features are helpful as well. As is the Student Filter Fields resource on Campus Community.

Knowledge Base: 
  * [[https://kb.infinitecampus.com/help/student-filter-fields-for-ad-hoc-reporting|Student Filter Fields]]
  * [[https://kb.infinitecampus.com/help/course-section-filter-fields-for-ad-hoc-reporting|Course-Section Filter Fields]]
  * [[https://kb.infinitecampus.com/help/census-staff-filter-fields-for-ad-hoc-reporting|Census-Staff Filter Fields]]

===== Self-Guided Practice Activities =====

Task:  Create and test a Query Wizard report that includes all active students and their birth dates at Harrison High. 
Corresponding Video Lessons
  * Ad Hoc Reporting: Filter Designer – Query Wizard Overview (2:19) 
  * Ad Hoc Reporting: Query Wizard – Field Selection (1:55) 
  * Ad Hoc Reporting: Query Wizard – Save & Test (1:13) 

Task:  Open the Ad Hoc report that you created, using the Data Export Tool and generate the report in CSV format. 
Corresponding Video Lesson
  * Ad Hoc Reporting: Data Export (1:19)