Contents

Part 1: Overview

The CCC Report Center is an easy-to-use staff reporting tool with ready-to-use charts, reports, and dashboards that allow colleges to report on submitted CCCApply (Standard, Noncredit and International application data, and CC Promise Grant applications and school information. Users can create and customize your own reports by either starting with one of the standard reports' Views or by creating your own report View from scratch.

About This User Guide

This online document serves as a "Quick Start" guide for the CCC Report Center (“Report Center”). In the CCC Report Center you can:

• Access real-time CCCApply application data for your authorized college or district.

• Run, view and export preconfigured reports that pull real-time submitted and in-progress CCCApply application data, filtered for your college or district.

• Query available data sources, run ad-hoc reports, and export data in multiple formats.

• Schedule to receive recurring reports by email or saved to the cloud or your desktop

About the CCC Report Center

The CCC Report Center is an easy-to-use report generator that provides real-time application data from your CCCApply applications and web services.

The CCC Report Center is powered by TIBCO JasperReports, a Java-based open-source, business Intelligence (BI) tool, providing robust static and interactive reporting, report server, and data analysis capabilities. TIBCO JasperReports allows for advanced reporting usage and provides extensive help that you can access from the Help link.

Data Sources in the Report Center

Create custom Ad Hoc Views from which you can create table (list), crosstab (pivot), and chart reports from the following data sources:

• CCCApply Standard & Noncredit Applications

• CCCApply International Applications

• CC Promise Grant Applications

• National & State Schools & Colleges

• Multiple Measures Placement Service (MMPS)

• Legacy Xap-CCCApply Applications

Ready-to-Use Public Reports

Dozens of ready-to-use report templates are available for each CCCApply application, including your legacy Xap-CCCApply applications*. Below is a sample of the application templates available:

• CCCApply Fraudulent Applications

• In-Progress (Un-submitted) CCCApply Applications

• AB540 Report

• New Applicants Report

• Citizenship & Military Reports

• Special Residency Report

• Dual Enrollment High School & Adult School Reports

• Xap Applications by Date

• Time to Completion Report

• And so many more!

Legacy XAP-CCCApply Application Data

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.

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.

Pilot (Sandbox) & Production Environments

Support & Use

Support is available to authorized Report Center users in our 24/7 online support community CCCTechnology.info - where college and district staff can share ideas, ask questions, and report bugs and issues for all the CCC Technology Center online applications.

Our experienced staff support technicians monitor every incoming post and comment during business hours, Monday - Friday, 7:00am - 4:00pm PST. Incidents, issues, and bugs reported during business hours are reviewed and escalated as needed, and support engineers will respond within 24 hours to critical issues regarding production applications.

Pilot Environment Support

The OpenCCCApply Pilot environment is designed to be a carbon copy of the live 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 as the Production environment. 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.

Part 2: Using the CCC Report Center

Getting to the CCC Report Center

Authorized users can access the CCC Report Center in two different environments: Pilot and Production. Colleges are provided their custom URLs during product implementation and training.

• 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 CCC Report Center using the custom URL configured exclusively for your college (based on your college or district MIS code). Each college is provided two unique URLs for your branded version of the CCC Report Center; one for the CCCApply Pilot environment, and one for the CCCApply Production environment.

2. At the login screen, enter your college system credentials for the username and password (the credentials used to authenticate you and your college or district IdP.

3. Click the Sign In button.
   

Authorized User Access

The User Manager module allows authorized users from each college or district MIS code to view, add, edit, and delete* all other users within the scope of their own authorized user permissions. The User Manager section provides the ability for users with authorized role(s) to create new users and permissions for your college or district. 

Upon the initial adoption and implementation of CCCApply at your college (or district), one designated User from each college is provisioned with the “Add User” role, which allows he/she to view, add, edit, and delete* all additional users within the scope of their own authorized user account. This user is responsible for adding - and removing - all subsequent approved user accounts; this user is also responsible for deleting users who are no longer affiliated with your college or permitted to access CCCApply data.

User Management

Adding & Editing Authorized User Accounts

If you are a designated “Add User” for your college, you are permitted to manage users for your MIS code. Use the following steps to add users to the CCC Report Center (these steps are also documented in the CCCApply Administrator 2.0 User Guide):

1. Log in to the CCC Administrator (CAP).

2. From the Welcome to the CCC Administrator home page, select “System Administrator” from the “Applications” menu dropdown.

3. Select User Manager from the System Administrator sub-menu to view the User Manager summary table. All users authorized to access CCCApply and related applications within your permissions scope (your MIS code and the applications you are authorized to access) will display, including your own user account. ((Applications->System Administrator->User Manager))
   
   

4. Click the “Add/Edit User” button to display the add user modal.

7. 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.

8. 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.       

Navigating 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.

Accessing Reports

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

• Library link

• View -> Repository link

• Search bar

The Library

The Repository

The Search Bar

College & Public 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.

Reports & The Report Viewer

The CCC Report Center makes it easy to run reports. When you run a report, it opens in the interactive Report Viewer. With the Viewer, you can personalize and refine the displayed report data. If the report has filers (input controls), you run the report with one set of data and then another.

Report Viewer

The Report Viewer allows you to view a report, export content to various output formats, and apply formatting, sorting, and filters to control how the data is displayed.

To open a report in the Report Viewer:

1. Locate your report in the library or repository.

2. Click the report name, or right-click the report name and select Run. In the repository, you can also click the report row and select Run from the tool bar. The report opens in the Report Viewer.

Running or Creating a Report

You can view and work on a report in the Report Viewer in a number of ways:

• Running an instance of an existing report

• Creating a new report from an existing Ad Hoc view

To run a report:

1. Log into the CCC Report Center with your authorized user account.

2. On the Home page, click the large icon in the Reports block.

The search results appear, listing your own college resources and all the public resources that your user account has permission to access.

Table & Crosstab Reports

A table report is a simple, tabular report that lists application data.

Exporting the Report

To export the report:

1. To view and save the report in other formats, click the Export button.

2. Select an export format from the drop-down. The export options are listed in “Export File Types” list below.

Save the report in the export file format, for example PDF, or open the report in the application.

Creating a Report

You can create a custom report directly from the Report Center Home page. This method allows you to select an existing Ad Hoc view and generate a report from it, without going through the Ad Hoc Editor.

To create a report from the Home page:

1. On the Home page, click Create in the Reports block. The Create Report wizard opens.

2. Select the Ad Hoc view you want to use as the basis for your report.

3. Select a report template. To use a template other than the default, select Custom Report Template, click Browse and select the desired template.

4. Click OK. If asked, enter data in the filters (input controls) as needed.

You can now begin working with your report.

The report shown below was created using the Ad Hoc Editor. As this type of report runs, you can interact with it in the Report Viewer to visualize the data in different ways. Column formatting allows you to highlight certain columns and fields, and filtering and sorting report output on‑the‑fly can provide timely views of the data that answer your questions. For example, suppose you’re running the New Applicants public template report and want to know how many applicants have a permanent address outside of California. Highlighting the State column with red text and filtering it to show only the states that are not “CA” would reveal this data.

Formatting a Report

Column Formatting

You can customize the basic format of column headings and fields, using the Format Column dialog. Hover over and click Formatting... The Format column dialog appears.

You can alter a column’s basic formatting or apply conditional formatting to a column.

Column formatting options include:

• Text

• Font type, size, and style

• Background color

• Font color

• Text alignment

To customize your column formatting:

1. Run your report, so it opens in the Report Viewer.

2. Click the header in the column you want to format.

3. Hover over and click Formatting...

4. Click the Basic Formatting tab, and change the following options if needed:

   • Apply to – Select the part of the column you want to apply the formatting to.

   • Heading text – Type new heading text to replace the current text

   • Font – Scroll through the menu to select a font.

   • Size – Scroll through the menu to select a font size.

   • Style – Click to select Bold, Italic, or Underlined text.

   • Background Color – Click to open the background color picker, then click to select the background color.

   • Font Color – Click to open the font color picker, then click to select the text color.

   • Alignment – Click to select Left, Center, or Right alignment.

5. If needed, click Previous Column or Next Column to change the formatting for an adjacent column.

6. Click OK.

Running a Report with Input Controls or Filters

An input control are graphical widgets that filter the data that appears in a report. The perfect input control limits the data to what you want to see—and nothing more. When you run a report based on a Domain Topic that defines a filter, the server can render the filter as an input control. The JasperReports Server interface uses "input controls," "filters," and "options" interchangeably.

If your system administrator has enabled the data snapshot feature (described in Data Snapshots), it is important to note that the default input controls - that is, the input controls as defined when the original Jaspersoft Studio- or Ad Hoc View-based report is run - will overwrite any changes made to them the next time you run a report. For instance, suppose you run a report, update the input controls, then save the report. At a later date, you run a report from the Jaspersoft Studio or Ad Hoc View source again. That new report will replace the report you ran earlier, and your input control changes will be lost.

To avoid this, save a version of the report with your selected data preloaded. That way, when subsequent reports are run from the same source, they will not overwrite your report. See Saving Input Control Values for more information.

Understanding Ad Hoc 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.

You can copy existing Views, renaming them to create a new View where you can add or remove fields. Or, you can create your own new Ad Hoc View from scratch.

Details for using Views and their reports are included in the sections below, but in general, use the following "best practices" when working with Views and reports:

• 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.

Follow these steps to run a Public report:

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

   

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

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

4. 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.

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

The following types of 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.

Use the following steps to copy and then customize a Public report view:

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.
      

      

   2. Click Copy.

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

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

-OR-To copy the View using Save As:

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 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.

You can also create your own View from scratch. To create your own Ad Hoc View from scratch, you'll first create the View, and then save the report from it. Once a report is created, it can be run immediately, run in background, scheduled, or included on a dashboard. Dashboards provide the ability to have more than one report on the same web page. Reports on a dashboard can have the same or different filter criteria.

Important note: Any change you want to make to a report must be first made to its associated View, either by editing the View, or copying the View and then editing it.

To create an Ad Hoc View, use the follow steps:

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.

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

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.

The online help includes detailed information on scheduling a report under the help topic "Scheduling Reports" (within the "Running Reports and the Report Viewer" topic).