MCCC Knowledge Base

Creating a formatted List of IDs for Use in a CROA Filter

2017

Creating a formatted List of IDs for Use in a CROA Filter

 

When you want to select a specific set of IDs in CROA, they must be formatted with a ‘;’ between the IDs in the list. Here are the steps to get the list into that format.

These instructions assume you have already exported a list of ID numbers from Colleague

 

1. Open the Excel grid and highlight the column of ids you want to use in your CROA report.  
2. Select and Copy the ID numbers  
3. Open a blank Word document  

4. Right click in the body of the blank document a do a “Paste”, selecting the “Keep Text Only” option.

If there were any headers, column sum or counts, delete them from the document. Your document should look something like this:

 

5. Click   from the Home tab of the Ribbon to find all paragraph marks and replace with ;
  • Find what = ^p
  • Replace with = ;
 
6. Click Replace All
  • Your document should now look like this:
 
7. Select All (Ctrl+A)  
8. Copy (Ctrl+C)  
9. Open the appropriate report in CROA  
10. Paste the copied IDs into the report query filter or filter prompt  
   
0 (0)
Article Rating (No Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
CROA: Setting Crystal report viewing preferences
Viewed 10322 times since Thu, Jul 9, 2015
CROA - Viewing Web Intelligence documents
Viewed 9371 times since Thu, Jul 9, 2015
Logging into CROA
Viewed 5998 times since Wed, Jun 22, 2016
CROA Video tutorials
Viewed 10871 times since Thu, Jul 9, 2015
Starfish Attendance Term Exporting
Viewed 25031 times since Thu, Dec 17, 2015
CROA - To save the document in PDF format
Viewed 7293 times since Wed, Jul 8, 2015
CROA - How to customize a table in the report
Viewed 8446 times since Wed, Jul 8, 2015
CROA - Getting Started with SAP - What is SAP BusinessObjects Web Intelligence
Viewed 10086 times since Wed, Jul 8, 2015
CROA Report - Active Program by Term
Viewed 7743 times since Thu, Apr 14, 2016
CROA - To change the page layout
Viewed 7550 times since Wed, Jul 8, 2015

Need Help?