Page Comparison

_{Version 6.0.1 - Last version update: 12-15-2021}

...

The Enabling Services team strives to build strong, customer-centric relationships with colleges throughout the implementation process with the following support representatives:

Get Started with Implementation: Contact yourCollege Relationship Manager (CRM) to discuss new products and upgrades at crms@ccctechcenter.org.

...

Logging In

1. Navigate to the CCCApply 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 CCCApply 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. 

...

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 CCCApply Report Center (these steps are also documented in the CCCApply Administrator User Guide):

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

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

5. Select Data Use Only from the Authorization Type drop-down list to assign the new user the ability to use CCCApply 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 CCCApply Report Center reporting functionality AND the ability to add other CCCApply Report Center users.

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

...

• Library link

• View -> Repository link

• Search bar

The Library

...

The Repository

...

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

...

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

...

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.

...

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.

...

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

...

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.
   

   Image Modified

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.

...

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.
      

      Image Modified

   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

...

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

1. Select Create -> Ad Hoc View from the CCCApply 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.

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

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

4. The Data Source Selection panel (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.

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

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

...

To add fields and measures as columns to a table:

1. In the Data Source Selection panel, click to select the field or measure you want to add to the table. Use Ctrl-click to select multiple items.

2. Drag the selected item into the Columns box in the Layout Band. (The field is added to the view as a column in the table.)

To remove a field or measure from a table:

...

Data is grouped in the table according to the order in which the data groups have been added. You can change the order by dragging the groups into position if needed.

To create a group:

1. In the Data Source Selection panel, click to select the field you want to add to the table as a group.

2. Drag the field to the Groups box in the Layout Band. (The Ad Hoc view refreshes and displays the data grouped under a new header row.)

...

To edit a column or header label:

1. On the Ad Hoc view panel, right-click the column or group header you want to rename.

2. Select Edit Label from the context menu. The Edit Label window opens.

3. In the text entry box, delete the existing name and enter the new name.

4. Click Submit.

If space is at a premium, you can remove labels from the view. When you delete a label, it still appears when you look at the view in the Ad Hoc Editor, but does not appear when you run the report.

...

To delete a column or header label:

1. On the Ad Hoc view, right-click the column or header label you want to remove.

2. Select Delete Label from the context menu.

To re-apply a label:

1. Right-click the column or header label you want to replace.

2. Select Add Label from the context menu. The Edit Label window opens.

3. Enter the label name, if needed.

4. Click Submit.

Managing Column Size and Spacing

You can change the size of, and spaces between, columns to manage the appearance of your table or use space more efficiently.

To resize a column:

1. In the Ad Hoc View panel, click to select the column you want to resize.

2. Move the cursor to the right edge of the column.

3. When the cursor changes to the resize icon, click and drag the column edge right or left until the column is the needed size.

Spacers can be added to a table to arrange columns farther apart, or add margins to a table.

To change the spacing between columns:

1. In the Data Source Selection panel, in the Measures section, click Spacer.

2. Drag the spacer into the Columns box in the Layout Band between names of the two columns you want to move apart.

3. A spacer column, labeled, appears in the table. Repeat this action to add space as needed between columns.

4. To remove a spacer, right-click the spacer column and select Remove from Table.

To use spacers to create table margins:

1. In the Data Source Selection panel, click to select Spacer.

2. Drag the spacer into the Columns box in the Layout Band.

3. Repeat until the margins are as wide as needed.

4. Repeat the steps above, adding the spacer to the right edge of the table.

Reordering Columns

You can move columns to the right or left to reorder data in your table.

To reorder a column:

1. In the Ad Hoc View panel, right-click the column you want to move.

2. Select Move Right or Move Left from the context menu.

Sorting Tables

In the Ad Hoc Editor, you can sort the rows of a table by any field, using a number of different methods.

To sort a table:

1. Click the A-Z sort icon. The Sort window appears. If the table is already sorted, the window shows the fields used.

2. To add a field to sort on, double-click the field in Available Fields. The Available Fields panel now lists only fields not currently in Sort On.

3. Select one or more fields to sort by. You can also use Ctrl-click to select multiple fields.

Image Modified

To arrange the sorting precedence of the fields, select each field in the Sort window and click Move to top, Move up, Move down, or Move to bottom: , , , and .

Image Modified

To remove a field, select it and click the icon .

Click OK. The table updates to display the rows sorted by the selected fields.

...

• Right-click a field in the Fields section of the Data Source Selection panel, and select Use for Sorting from the context menu. In this case, the table is sorted by a field that isn’t in the table; you may want to note the sorting fields in the title.

• Right-click a column header on the Canvas of the Ad Hoc View panel, and select Use for Sorting from the context menu.

• If a column is already being used and you want to stop using it or change the sorting, right-click the column and select Change Sorting from the context menu.

Adding a Title

1. Above the table, click the text Click to add a title.

2. Enter the new table title in the text entry box.

Changing the Data Format

You can change the formatting for columns containing numeric data, such as dates and monetary amounts. The format is applied to all rows as well as the group- and view-level summaries. By default, non-integer fields use the -1,234.56 data format; integers use -1234.

To change the data format for a column:

1. In the Ad Hoc view, right-click the column header.

2. Select Change Data Format from the context menu.

3. Select the format you want to use. These options vary, depending on the type of numeric data contained in the column.

The data in the column now appears in the new format.

...

To change the table’s data source:

1. At the top of the Data Source Selection panel, click  and select Change Source.

2. Select a different Topic, Domain, or OLAP connection.

3. Click Table to apply the new data source.

Click Cancel to return to the editor without changing the Topic.

...