Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Nathan99
Regular Visitor

Order number on report builder

I am needing to create a report that will pull all inofmration associated to the order number. whenever i add the items or descriptions of the items in the order it creates multiple records with the same order nuber in different rows. is there a way to make this distinct so that all relevant details will be shown next to the order number 

1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

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) | Micr...

 

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

View solution in original post

1 REPLY 1
v-jingzhan-msft
Community Support
Community Support

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) | Micr...

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors