How to Display Each Cross Reference Row as a Separate Column in Report Designer (No Unique Identifier)

Hi everyone,

I'm working on a report in Acumatica Report Designer that pulls data from the InventoryItem table, specifically from the Cross Reference tab (i.e., the INItemXRef table). My goal is to display up to three rows from the cross-reference tab for each item, and show them side-by-side as three separate columns in the report. I’ve attached pictures of:

1. The report
2. Where the cross-reference can be found
3. A view of the cross-reference tab

Here’s the structure I'm aiming for:

| InventoryID | CrossRef1 | CrossRef2 | CrossRef3 |
|-----------------|----------------|----------------|----------------|
| A100           | ABC001     | DEF002     | XYZ003     |

Is there any reliable way in Acumatica Report Designer to extract row #1, row #2, and row #3 from a repeating dataset (like INItemXRef), and display each one as a column — even when there’s no distinct identifier on each row?

Thanks for any insight! And please let me know if I can clarify further!