The Reports/Admin Menu provides a wide variety of reports and lists, useful for managing, reviewing, editing and analyzing data.

The Reports/Admin Menu has two parts.

Part I - Report Criteria. Part I of the screen allows you to select critera for running reports.  You may select a date range, an activity name, a school name, or other criteria.  Once you have selected the criteria, click the button to APPLY.

Reports/Admin Menu - Part I

Part II - Menu of Reports and Editing Screens. Part II, found in the lower part of the screen, has buttons for running a variety of available reports or editing screens.  Whatever criteria you selected in Part I will be applied to the report(s) you run.

Part II of the Reports menu

Some recommended reports for analyzing and presenting data include the following.

Some recommended reports for managing and reviewing data include the following.

 


 

Custom Reports

If you don't find exactly the report or criteria you want/need, you can explore the following custom reporting options and/or you may email This email address is being protected from spambots. You need JavaScript enabled to view it. for advice or assistance in getting the data you want.

Custom Criteria for Part I: Report Criteria:

One of the options is to write customized criteria in the custom criteria box.  This allows you to write criteria using fields other than those on this screen, or to write criteria that use "or" statements.  If you ever want to write a report using customized criteria, you can email This email address is being protected from spambots. You need JavaScript enabled to view it. for assistance.  Or, if you are familiar with SQL language or comfortable learning how to write these statements, you can experiment and write your own criteria.  For example, you could write the following criteria:

(EmplName='ABC Software' or EmplName='XYZ Software') Finds records where the employer name is ABC Software or XYZ Software
CityOfResidence='Mill Valley' Finds records where the City of Residence is Mill Valley.  Useful if you data enter this information and if, for example, you want to know how many students from a regional school live in a particular community.
Left(ParticipantName,1) = 'A' Finds records where the participant name begins with A. This, and the next example, can be useful if you are working on editing and reviewing records and want to look at a few at a time.
Left(ParticipantName,1) between 'A' and 'D' Finds records where the participant name is between A and D.
CreatedDate='4/21/2010' Finds records where the date the record was created is 4/21/2010
IndustryCluster='Health Care' Finds records where the industry cluster is Health Care
TypeOfPay='Paid' Finds records where the placement is employer paid, based on the Type of Pay checkboxes on the Placement Screen
TypeOfPay='Unpaid' Finds records where the placement is unpaid, based on the Type of Pay checkboxes on the Placement Screen
TypeOfPay='Sponsored' Finds records where the placement wage is subsdized or sponsored, such as YouthWorks or ARRA programs, based on the Type of Pay checkboxes on the Placement Screen
(SchoolProgram='Mill Valley High School' or NameActivity='Mill Valley School to Career') Finds records where the school is Mill Valley High School or the Activity Name is Mill Valley School to Career. (Notice that "OR" statements should be in parentheses.)
NOTE: You can find field names by looking at the DATABASE FIELD List in this website or by looking at the field name is the custom reports.

Custom Reports in Part II: Reports

One of the sections on the list of reports provides a custom-report routine. There are two types of custom reports. One will provide a list, based on fields that you check off on the list of fields. The other will provide a count, also based on fields that you check off on the list of fields. Custom reports can be saved and run again. The image below shows the custom report screen for creating a list.  You can check the fields you want; sort by any field; and add "Where" criteria to select certain records.  If you don't want to sort or select particular records, you can leave "PlanID" and "PlanID greater than 0" on the screen.  A similar screen allows you to create a count of records for any subgroups, such as a count by employer name or a count by activity name.

Check the Database Field List in this website to learn more about the field names used on these screens.