Contents

...

The image below is an example of the kind of report you can run in the CCC Report Center. This report shows the results of looking up student applications submitted in a specific date range.

Making XAP Applications Available in Reporting

It is expected that if you have any legacy XAP-based student applications they have been imported into your Student Information System (SIS) and are available for reporting. XAP-based student applications have their own unique Data Dictionary and application data download process. Contact the CCC Tech Center to request Data Dictionary and/or download process information if necessary.

Accessing the CCC Report Center

You can access the CCC Report Center data for your college in two different environments: Pilot and Production.

• The Pilot environment allows you to experiment with CCC Report Center functionality in a test environment while you learn to use the tool.

• The Production environment allows you to report on live data for submitted student applications and school information.

        Note:

...

Terms of Use and Support

The OpenCCCApply Pilot environment is meant to be a carbon copy of the Production environment to allow colleges to stage changes in their configurations and test implementations prior to an update or product roll-out. While the Pilot environment is a clone of Production, it is not actively monitored for errors and issues in the same way that the Production environment is. Thus, there is no support team in place to respond to Pilot environment issues. For those colleges currently implementing OpenCCCApply, reporting issues to your project team may not be effective.

Our recommendation is that college staff personnel use the CCCTechnology.info support site to communicate issues, ask questions, and request assistance. CCCTC support staff review incoming posts and endeavor to respond within 48 hours to issues posted about the Pilot environment. Depending on the nature of the issue, resolution time will vary; however the intent is to provide updates on progress towards implementation every 24 hours.

Logging In to the CCC Report Center

1. Navigate to the URL provided by your IT staff for either the Pilot or Production environment.

2. At the login screen, enter your college credentials for the username and password.

3. Click the Sign In button.

Setting up CCC Report Center Users

A designated person (or persons) at your school will have been configured by the CCCTC as a user with "add authority," and will be able to add other CCC Report Center users. The person with "add authority" for your school will use the following steps to add CCC Report Center users (these steps are also documented in the Administrator guide):

1. Log in to the Administrator.

2. Select CCC Report Center from the Select an Application drop-down list.

3. Select your college from the Select a College drop-down list to display the Users tab.

4. Click the Users tab to select it and to display the User fields.

5. Enter a unique EPPN in the EPPN field for a new user.

6. Select Data Use Only from the Authorization Type drop-down list to assign the new user the ability to use CCC Report Center reporting functionality. OR, select Add User Authority from the Authorization Type drop-down list to assign the new user the ability to use CCC Report Center reporting functionality AND the ability to add other CCC Report Center users.

7. Select your college's MIS code from the Authorized MIS Code drop-down list. If you are setting up a user for a District instead of an individual college, then you will select the District MIS code. District MIS codes end in '0'. District-level users can access and report on data for all the colleges in the district.

Logging in to the CCC Report Center

Once your CCC Report Center user account is set up and you have the CCC Report Center URLs for your college's Pilot and Production environments, use the following steps to log in:

1. Navigate to the URL for your CCC Report Center in a web browser of your choice.

2. Enter your college user ID and password and click Login to display the CCC Report Center home page.

        Note:

The CCC Report Center is configured for single-sign on, which means that the user ID and password you use to access your college accounts are the same as those you use to log in to the CCC Report Center.

CCC Report Center Home Page

The CCC Report Center Home page displays the following items:

• A Getting Started section (with links to JasperReports community resources) and links to recently-viewed items

• Resources options for defining data sources, structuring data sources, Ad Hoc Views, Reports, and Dashboards

• Links across the top of the CCC Report Center to the Library, View, and Create features

        Note:

It is expected that most CCC Report Center users will use the Ad Hoc Views, Reports, and Dashboards resources.

CCC Report Center Navigation

When you log in to the CCC Report Center, the title bar across the page includes your user ID, a Help link, a Log Out link, and a search bar.

• Click the Help link to open the Introduction page for the JasperReports Server help web site in a new browser window.

• Click the Log Out link to log out of the CCC Report Center.

• Enter search text in the search bar and press the Enter key or click the Lookup icon to display search results.

Wherever you are located in the CCC Report Center, you can always click the Home icon to return to the CCC Report Center Home page.

Terms of Use and Support

The OpenCCCApply Pilot environment is meant to be a carbon copy of the Production environment to allow colleges to stage changes in their configurations and test implementations prior to an update or product roll-out. While the Pilot environment is a clone of Production, it is not actively monitored for errors and issues in the same way that the Production environment is. Thus, there is no support team in place to respond to Pilot environment issues. For those colleges currently implementing OpenCCCApply, reporting issues to your project team may not be effective.

Our recommendation is that college staff personnel use the CCCTechnology.info support site to communicate issues, ask questions, and request assistance. CCCTC support staff review incoming posts and endeavor to respond within 48 hours to issues posted about the Pilot environment. Depending on the nature of the issue, resolution time will vary; however the intent is to provide updates on progress towards implementation every 24 hours.

Accessing, Working With, and Running Reports

Accessing Standard Reports

There are three ways to access all Making XAP Applications Available in Reporting

It is expected that if you have any legacy XAP-based student applications they have been imported into your Student Information System (SIS) and are available for reporting. XAP-based student applications have their own unique Data Dictionary and application data download process. Contact the CCC Tech Center to request Data Dictionary and/or download process information if necessary.

Accessing the CCC Report Center

You can access the CCC Report Center data for your college in two different environments: Pilot and Production.

• The Pilot environment allows you to experiment with CCC Report Center functionality in a test environment while you learn to use the tool.

• The Production environment allows you to report on live data for submitted student applications and school information.

Logging In

1. Navigate to the URL provided by your IT staff for either the Pilot or Production environment.

2. At the login screen, enter your college credentials for the username and password.

3. Click the Sign In button.
   

User Setup

A designated person (or persons) at your school will have been configured by the CCCTC as a user with "add authority," and will be able to add other CCC Report Center users. The person with "add authority" for your school will use the following steps to add CCC Report Center users (these steps are also documented in the Administrator guide):

1. Log in to the Administrator.

2. Select CCC Report Center from the Select an Application drop-down list.

3. Select your college from the Select a College drop-down list to display the Users tab.

4. Click the Users tab to select it and to display the User fields.

5. Enter a unique EPPN in the EPPN field for a new user.

6. Select Data Use Only from the Authorization Type drop-down list to assign the new user the ability to use CCC Report Center reporting functionality. OR, select Add User Authority from the Authorization Type drop-down list to assign the new user the ability to use CCC Report Center reporting functionality AND the ability to add other CCC Report Center users.

7. Select your college's MIS code from the Authorized MIS Code drop-down list. If you are setting up a user for a District instead of an individual college, then you will select the District MIS code. District MIS codes end in '0'. District-level users can access and report on data for all the colleges in the district.       

...

Using the CCC Report Center

The Home Page

The CCC Report Center Home page displays the following items:

• A Getting Started section (with links to JasperReports community resources) and links to recently-viewed items

• Resources options for defining data sources, structuring data sources, Ad Hoc Views, Reports, and Dashboards

• Links across the top of the CCC Report Center to the Library, View, and Create features

Navigation

When you log in to the CCC Report Center, the title bar across the page includes your user ID, a Help link, a Log Out link, and a search bar.

• Click the Help link to open the Introduction page for the JasperReports Server help web site in a new browser window.

• Click the Log Out link to log out of the CCC Report Center.

• Enter search text in the search bar and press the Enter key or click the Lookup icon to display search results.

Public & College Folders

Reports: Running, Customizing & Scheduling

Accessing Reports

There are three ways to access the reports in the CCC Report Center:

• Library link

• View -> Repository link

• Search bar

...

...

Working with Reports and Their Views in the Public and College Report Folders

For the purposes of this "Quick Start" guide, it is assumed you are accessing reports by clicking View -> Repository to view the Public and college reports.college reports.

Understanding Reports and

...

Views

...

In order to create a report you must first create a View, and then create a report from it. A Report View is a kind of "report designer" that defines the type of report and the format, layout, data, groupings, and filters to be applied when the report is generated.

Once a report is created, it can be run immediately, run in the background, scheduled, or included on a dashboard. Reports can be scheduled to run at any interval you define. Scheduled reports can also be distributed via e-mail to specified recipients.

Public Reports

Public reports include ready-to-use standard reports that have already been created for you, along with their corresponding Views. For example, in the image above, the Summary Reports subfolder is followed by a Summary Views subfolder. Each report in the Summary Reports subfolder has a matching View in the Summary Views subfolder.

...

• Keep your Views organized in folders that have the word "View" in their name to make the Views easier to find

• Keep your reports organized in folders that have the word "Reports" in their name to make the reports easier to find

• Use the same name for the View as you do for its corresponding report but include "View" or "Report" in its name to further help with organization

• If you change a View, you will need to create a report from it in order to see the changes in report form

• If you want to keep the original View when making changes, use the Save As button to save the View with a different name and then make your changes (and use the Description field in the Save As dialog box to add information)

• Public reports and their Views cannot be edited or deleted (though in some reports you may have the option to filter out certain data from the displayed results)

• Only copy a report's View if you need to edit or customize it; otherwise, always run a Public report from the Public folder in the Repository

• When copying or customizing an existing View, add the word "Report" or "View" onto the end of the new name to keep the report/View distinction clear

Running a Public Report

When you first log in to the CCC Report Center, you will find a number of pre-defined standard reports in the Public folder. You can run any of these reports. A public report that is associated with submitted student applications will display data only for applications submitted to your college. Most of the Public reports have filters that restrict the output to a subset of your college's submitted student applications.

...

1. Click the Public folder to expand it and display the sub-folders that contain standard reports.

1. Click the subfolder name to display the report options for that report type in the Repository list.

2. Click the report Name link in the Repository list to run the report.

3. If the report you selected prompts you for input (such as the Lookup reports), then you will need to click the OK button to close the Input Controls dialog box that displays prior to running the report.

...

1. You can then save the report or export the report into a variety of file formats.

The following types of standard reports are available in the Public folder:

• Application Reports: These include some common "detail" reports of submitted applications. Many of these reports include Lookup fields that prompt you for your report criteria.

• Summary Reports: These include some commonly-requested summaries, typically including charts and crosstab reports.

• Schools Reports: These allow interactive searches of the School database table used in the CCCApply School fields. You can search (query) the School database table using a variety of different filters. These reports are not unique to any college.

College Reports

The College folder includes the Ad Hoc Components, Organizations, and Themes subfolders. You can create subfolders in the College folder to contain any Public reports and their associated Views that you copy for customization, as well as any Ad Hoc reports that you create from scratch.       

...

Customizing Reports

...

Customizing a Public

...

Report

Some Public reports provide the option to customize the results displayed. You can change the displayed results by removing data, but you cannot add data. For example, in the New Applicant Detail Report, the report includes options to alter the Columns and Group displayed, as well as Filter controls to the right of the report.

You can quickly alter the details displayed by clicking the "x" icon for each of the columns to remove that particular column from the report results. For example, after removing some of the columns, the report might look like the example image below.

If you want to alter a Public report by adding data to it, you must copy the Public report's corresponding View into your college folder where you can modify it and then create a report from it.

...

1. In the Public folder, navigate to the "View Folder" that contains the View you want to change.

2. Copy the View in one of two ways: using the Copy button or the Save As drop-down list option. To Copy the View:

   1. Select the View by clicking the square to the left of the view name. This will make the Copy button on the top of the list active.

1. Click Copy.

2. Navigate to the folder where you store the views for your college and click the Paste button.

now have a copy of the view which you can modify and save as an "Ad Hoc" report.

...

1. Click the View name link to open it in the Ad Hoc editor view.

2. Click the Save icon and select the Save Ad Hoc View As... option.

1. When the Save As dialog box opens, navigate to the college folder (or, as in the example below, navigate to the college folder in your district), enter a revised name in the Data View Name (required): field, enter any revised text in the Data view Description field, and click Save.

1. Open the View you just copied in the college folder so that it displays in the Ad Hoc editor with a list of Fields options from which you can choose from on the left

...

1. side of the window.

1. Click and drag any fields you want to add from the Fields options to the Columns or Rows fields in the Ad Hoc editor view.

2. In the Ad Hoc editor view, click the "x" icon for any fields that you want to remove from the View. From here you can use the Ad Hoc editor controls to further customize the view.

3. When you are done updating the View, click the Save icon again and select the option to Save Ad Hoc View and Create Report from the drop-down list to display the Save Ad Hoc View and Create Report dialog box.

1. Select the Reports folder for your college and click the Save button to save the report. The View the report is based on remains saved in the View folder for the college.

Creating Ad Hoc Views and Reports

...

Creating a New Ad Hoc View and Report

You can create your own custom Ad Hoc reports most easily by copying one of the standard Views from the Public folder and pasting it into your College View folder.

...

1. Select Create -> Ad Hoc View from the CCC Report Center menu bar, or, from the Home page, click the Create link from the Ad Hoc Views resource option to open the Data Chooser dialog box.

1. Click to open the Topics subfolders and then click to select from one of the options: BOG Fee Waiver, Schools, Submitted Applications, or xap_applications. The Table, Chart, and Crosstab buttons become enabled.

2. Click to select Table, Chart, or Crosstab and automatically display a blank New Ad Hoc View. Three panels display along with a Tool Bar.

1. The Data Source Selectionpanel (left) displays data fields available based on the data source (topic or ) you selected. The fields are organized in categories. Click the + to open a field category. You can use the Data Dictionary for the CCCApply application (Standard or International) or BOG Fee Waiver on which you are reporting for more information on each field's details.

2. The Ad Hoc View panel (center) is where you build your view by clicking and dragging items from the Data Selection panel and Measures options onto the canvas. Other tools you can use here include the Ad Hoc Editor Tool bar, the Layout Band (columns and rows fields), and the Canvas Options selector (gears) icon.

3. The Filters panel (right) displays any fields you select to be used as filters and allows you to refine the definition of those filters.

        Note

...

See the "Working with the Ad Hoc Editor" help topic in the online Help for further information.Scheduling Reports

Scheduling Reports

You can schedule a report to run at a specific date and time, including a recurring time frame (every Friday at 9 am. for example). The image below is an example of how you begin this process. When you right-click a report Name, a pop-up menu displays and you can click the Schedule... option to open a Scheduled Jobs window that allows you to configure your scheduled report.

...