MCCC Knowledge Base

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


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.
There are no comments for this article. Be the first to post a comment.
Related Articles RSS Feed
CROA - Viewing Web Intelligence documents
Viewed 7577 times since Thu, Jul 9, 2015
CROA - To change the page layout
Viewed 6357 times since Wed, Jul 8, 2015
CROA BI launch Pad 4.x Tutorials
Viewed 8738 times since Thu, Jul 9, 2015
Advisory Committee Membership Reporting
Viewed 6862 times since Thu, Jul 16, 2015
Setting CROA recommended preferences
Viewed 5516 times since Thu, Jun 23, 2016
CROA - Accessing the Web Intelligence HTML interface in the BI launch pad
Viewed 7452 times since Wed, Jul 8, 2015
CROA Basics Overview
Viewed 6658 times since Fri, Feb 1, 2019
EDU Student Clearance Record Keeping
Viewed 18818 times since Tue, Jan 12, 2016
CROA - Getting Started with SAP - What is SAP BusinessObjects Web Intelligence
Viewed 8535 times since Wed, Jul 8, 2015
CROA - Working with content objects
Viewed 8007 times since Thu, Jul 9, 2015

Need Help?