CROA is a system that allows you to pull data reports specifically for analytic purposes. The data that is pulled is directly from Colleague, once a day.  

CROA is sometimes referred as BI or Business Intelligence. Everything in CROA has had the data validated.  

This article will provide you with an overview of CROA including the following:

1. Logging In
2. Setting your Preferences
3. Navigating CROA
4. Opening a Report
5. Reports with Prompts
6. Saving a Report
7. Edit a Report
8. Export a Report
9. Share a Report

Note: You are unable to access CROA from a laptop unless you are plugged in, docked and on campus. 

3. Once logged in you will see the Home page/tab (unless you have changed this landing page previously). You can change what you see upon login by updating your Preferences.

Note: You can also access CROA from reports.mc3.edu.

7. Under View and Modify make sure HTML is selected.

If Applet is selected then you will need to have Java installed. Java is not installed on all computers across campus. The applet option can also cause you to see a blank screen when you try to open a report. 

Note: All reports in this area are from Ellucian or IT has created them. 

2. Your Inbox is the space where you will find reports that others share with you. You should only share reports with others via CROA since they can contain sensitive information.

Note: You are not notified when someone sends you a report. 

2. Right click on a report to show a list of options. 

• View: View a report. If it open as an Excel file this means it is a scheduled report. 
• Schedule: Where you can set it the report to run as often as you wish. A new window will open where you can set this option. You can also modify the Prompts or Formats. 
• History: Shows you when the report was last run. 
• Organize: Copy a report.  When you Copy a report you are copying the current version of the report. 
  • Create a Shortcut: Create a shortcut in your Favorites folder if you are looking to get a report quickly. 

All reports are either from Ellucian or IT has created them. These reports pull information from Colleague which helps ensure accuracy, however, it is always good to open and review that reports have been updated.  

If you are unsure what report to open, hover over the report to see a report description.

Note: Crystal Reports are reports indicated with a green dot. Crystal Reports show live data (I.e. Finance and Purge reports). Crystal Report must be created by IT. 

Note: If you open a report that has a schedule attached it will open an Excel file that does not have the most up to date data.

Note: Some reports have multiple tabs. Be sure to check before you use or export the report because it will only give you the information on the current tab that you are viewing. 

3. When the report opens, look at the bottom right hand corner of the report to see the last time the data was refreshed. Click the icon in the lower right corner of the report to refresh the data. It’s important to always refresh the data when you open it.  

Note: If it has a refresh of 5 years ago it does not mean it’s old sometimes it means that you do not have the ability to save. Do not worry about the last time it was run, just make sure to refresh. Some reports set to refresh automatically. Some reports will just run. Some reports give you a list of prompts. 

To Track Changes, click the Track Changes icon at the bottom right corner of the report.

1. When you open a report and a pop-up window appears that says Prompts then you will either be required or not required to enter information before the report runs. Required and not required prompts are identified by the following:

• Green Check mark - Not required and currently being used in the report
• Red Arrow - Required and not being use in the report 

2. Prompts that require additional information involve you identifying what information you want to pull for said prompt.

Click the prompt identified with the red arrow to select the value you wish to add to the report.

3. Move over to the Enter value(s) for Section Term box to look for the value you want to add. You can use the search option at the bottom to search for values or click the heading, Section Term, to organize the values.

Note: You can enter your own value manually, but if you do not type it correctly it will give you zero results.

4. Click the value you want to add in the Enter value(s) for Section Term window and use the arrows to the right of the box to move them into the blank box to the far right.

Once you add the value, under the Prompts Summary box, the prompt you selected with the red arrow will now turn to a green check mark.  

Note: You can add more than one value to a prompt. 

If you want to use a report, but make changes to it, you must save the report to your Favorites folder first. You are unable to edit public reports. 

Note: It is recommended that you do not create a report from scratch. Find a report that is close to what you want and make edits to the existing report. 

Note: The save icon may not work if you are currently in MCCC Reports.

Note: Web Intelligence will always be your option when saving. 

4. Click the small arrows pointing to the right to expand your options. Enter a Description and Keywords. This helps when it comes to searching and identifying a report.

You can also check the box next to Refresh on Open. You do not have to select this option if you prefer to see information from the day before versus the information on the current. day.

1. Locate and click the report you want to make changes to. Most reports you will be looking for are under Documents, then Folders, Public Folders, and MCCC Reports. 

Note: If you are creating a new report, it is recommended that you find a report that is close to what you want and then edit the information so you are not creating a report entirely from scratch.

2. Open the report and click small down arrow to the right of the Design icon. For your reference, there are 2 design views:

• With Data: Shows the report with the data. This option allows you to edit the data within the report
• Structure Only: Shows the fields being used on the report. This option allows you to change the font color, style, etc.

For this example, click With Data.

Note: If you need to make changes to a report you will be unable to see a Design option if the report is not saved. 

4. Report options that can be edited are as follows:

• Result Objects: The information you have currently in the report.
• Query Filters: The type of data you see. Think of the Query Filters as how you will refine the data. For example, if you need a report that indicates a course section, but you only want to view a specific section from a specific year, then you will edit your Query Filter so it is only pulling that specific information. If this is not identified then the report will pull every section from every year.

Note: M45 is common to see for Query Filters and Result Object options. M45 is the Customer number for Ellucian. Always pick M45 since Colleague is customized for the College.

5. Click the information you want and use the respective arrows to the right of the box to move it into the area you wish.  

Note: You can use the search feature in the panel to the left to search for fields or you can click on an existing field and it will take you to the folder where it lives.  

6. Under Query Filters you do have the ability to define your filter type.

Click the icon next to the filter you want to define. From the drop down, select Constant (if this should remain as is), Values from List (select a value that should be used), or Prompt (if you want to be prompted to enter the information prior to the report running). 

Note: As you create and update reports on your own, be sure to validate the data that is within the reports with what you see on Colleague and on your report. Any report validating requests can be sent to the Help Desk at helpdesk@mc3.edu. 

You can export a report to view the data more closely if you wish. 

Note: Do not export a report and send it via email. It is not the most secure option.

3. Select CSV or Excel. CSV removes the report formatting and Excel keeps the report formatting.   

Note: Do not export a report and send it via email. It is not the most secure option.

2. Select Send from User. This option will send the report via CROA so that it is delivered to their CROA Inbox.  

Note: It is recommended that your share reports via CROA as this is the most secure way of sharing data. 

3. Click the user you want to send the report to. Use the arrows to move the recipient names over to Selected Recipients box. The system searches by the users College username.

4. Leave Target Name and Send As: as the default option. Then click Send. 

Note: The user you send the report to is not notified that you have send a report. It is recommended that you follow up via email to let the person know that you have shared a report in CROA.