Creating a formatted List of IDs for Use in a CROA Filter
Article ID: 953 | permalink | Rating: Unrated | Last Updated: Tue, Jun 7, 2022 at 4:56 PM
![]() |
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 ![]()
|
![]() |
|
6. Click Replace All
|
![]() |
|
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 | ![]() |
|
![]() |
||