Order number on report builder

Hi Nathan99 

To address this issue, you might want to use the grouping feature in Report Builder to group your data by the order number. This will allow you to display all item details associated with each order number together. Here's a brief guide on how to achieve this:

• In your report, go to the data region where you're displaying the order numbers and item details.
• Right-click on the row group where your order number is displayed, then select "Group Properties."
• In the Group Properties dialog, ensure that your group is set to group by the order number.
• You can then add the item details to the group details section, ensuring that all details related to an order number are displayed together.

For more detailed instructions on grouping, please refer to the Report Builder documentation here:

Understand groups in a Power BI paginated report - Power BI | Microsoft Learn

Tutorial: Create a basic table report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!