Filter a Report

Reports displays the reports available for viewing, printing, and/or exporting by category. All reports, receipts, and form letters provide details on instructional materials approved for and/or tracked by your campus.  You can refine reports, receipts and letters by Filtering and Sorting the data in multiple ways.

Filter a Report

Most reports allow TIPWeb-IM filtering.  Review how to export data into a spreadsheet for non-filterable reports.  There are eight total filters - four sets (Tabs 1, 2, 3, 4) of filters with two criteria per set.  Between each of the desired filter criteria, an AND statement or an OR statement must be selected.

1. Click on Reports.

2. Select the desired report category using the Select Report Category drop down menu.

3. Click on Filter, located on the desired report's row.  This opens the Reports Filters page.

4. Under the Set 1 Tab, select the first filter using the Please Select Report Filter drop down menu(s) and the desired filter criteria data.

   • If applying more than one filter, select the appropriate And/Or setting between the first and second filters.

   • If applying more than two filters, select the appropriate And/Or setting in the Set Box (located on the far right side).  This opens the next Set Tab, allowing the selection of additional filters.

5. Select  Print to launch the report.  Depending on the file format of the report (most commonly a PDF (A file format which provides an electronic image of text or text and graphics which looks like a printed document and can be viewed, printed, and electronically transmitted. To view and/or print a PDF document, the user must have a PDF reader installed on the computer they are using - for example, Adobe® Reader®.)), use the respective file's application controls to view, save, or print the report.

NOTE:

The selected report name is displayed in the top left hand corner of the Filters page.

And/Or Settings:

• AND - combines separate search criteria together by specifying all terms must be present in the record - this narrows a search - since the more terms you join with AND, the fewer results will be returned (Example: Campus Distribution by Title Report filtered to for distributions of a specific ISBN AND a distribution status of LOST - provides a list of any teacher or student with the specific ISBN in the status of LOST on their account)

• OR - separates search criteria by specifying either term may appear in the record -  this expands the search to include each search criteria (Example: Campus Distribution by Title Report filtered to for distribution statuses of PRTL (Partial Paid) OR LOST - provides a list of any teacher or student with either a PRTL or LOST or both statuses on their account)

When printing:

• PDF (A file format which provides an electronic image of text or text and graphics which looks like a printed document and can be viewed, printed, and electronically transmitted. To view and/or print a PDF document, the user must have a PDF reader installed on the computer they are using - for example, Adobe® Reader®.) files, the computer you are using must have a PDF reader installed (such as Adobe® Reader®).  

• RTF (A file format for text documents. Most word processing software supports RTF format. The RTF format is consistent enough from computer to computer to be considered highly portable and acceptable for cross-platform use.) files, the computer you are using must have a word processing application installed (such as MS Word).  

• XLS (Microsoft Office Excel spreadsheet format. XLS files contain rows and columns of cells and each cell can hold a data point.) files, the computer you are using must have MS Excel installed or another spreadsheet application which can open XLS files.