Client Information Services (CIS) Report Builder

There are several Report Builders that have been designed for Client Information Services. The Report Builders are pre-designed reports that allow the user to quickly develop the necessary reports. Since these Report Builders are pre-designed, the user does not need to enter SQL code. The SQL is automatically generated by the Report Builder.

 

Navigating To

There are several links on the e-Services Home page that will open the CIS Report Builder:

• Admissions. Under the Admissions heading is a Report Builder link.
  
  
• Honors Program. Under the Honors Program heading is a Report Builder link.

Using the Report Builder

1. Select the Filter Criteria.
   
   
   • Select any of the Checkboxes that appear on this page. Please be aware that some checkboxes, such as App Completed and App Incomplete, are mutually exclusive.
     
     Note: The list of filters is available in the System Registry - Admission Values | Prospective Info Report | Info Filters (DB Fields).
     
     
     
   • Click the Continue button when you have completed your selections.
     
     
     

2. Select the Values for the Filter Criteria.

   • Menus of criteria appear on screen 2, based on the filters you checked in step 1. You may select multiple values from each criteria list by holding down the Ctrl key and clicking the items.
     
     Suggestion: Please keep in mind that the more filter and values you select, the longer your report will take to assemble.
     
     
     
   • When you have completed your selections, click the Continue button.
     
     
     

3. Select Info Clusters (Columns) to Display on Report.

   • On screen 3, you should see a list of the filters that you selected. Under the list are the Information Clusters available to display on your report.
     
     
     
   • Click the checkboxes corresponding to the columns you wish to display on your report. Each column contains multiple pieces of information. Please refer to the matrix below to see the data displayed in each column.
     
     
     

Contact Info	Demographics	Academic	High School	Activities and Interests	Application Info	Admission Decision Info	Financial Aid (Private)
Name Address Phone E-mail Last Contact	Race Religion Citizen Gender Legacy	GPA SAT/ACT HS Rank Acad Index Merit Index	DPU Counselor HS Name HS Contact/Phone	Majors Career Source Athletics	Started Date App Type Deadline School Entrance Year	DPU Decision DPU Dec Date Notification Date Stu Decision Stu Dec Date	Filed Fafsa Packaging Notified Date

 

4. Viewing the Report.

   • The results of the report are displayed based on the filter criteria and columns you selected. Review the report to confirm that the information you requested is on the report. If you have any questions, please contact the Admission Office x4006.
     
     
     

5. Saving SQL Statements.

   The SQL statement that produces the report is displayed in the HTML code. You can save the report by copying and pasting the SQL statement into the Reports Engine.
   

   • On your browser menu bar, click View | Source.
     
     
     
   • Scroll through the HTML code until you see the beginning of the SQL Statement, "SELECT . . ."
     
     
     
   • Highlight the SQL Statement.
     
     
     
   • On your editor's menu bar, click Edit | Copy
     
     
     
   • In your browser, navigate to the Reports Engine. <https://www.depauw.edu/e/reports/>
     
     Note: See SQL Editor Form.
     
     
     
   • Click the Add Report link in the upper right corner of the reports list.
     
     
     
   • Select an access level for the report - individual or department.
     
     
     
   • Enter a report name and description.
     
     
     
   • If you selected department-level access, select the departments that will have access.
     
     
     
   • Select a folder for the report to be linked.
     
     
     
   • Enter the Connection for the report.
     
     
     
   • Paste the SQL Statement into the text area box.
     
     
     
   • Save the SQL Statement by clicking the Save SQL button.
     
     
     
   • You can now run the report by clicking the name of the report in the Report Engine reports list.

 

Related Items

Report Engine Overview