Paginated Report in Report builder having summary and detail data in table

[braypa]

Looking for help understanding grouping in a Power BI Paginated Report built with Power BI Report Builder. I'm trying to show summary for product info and details for buyers in the same table, where all the data is in a single dataset.

My dataset has product and buyer info as follows

Product Key	Product name	Class	Buyer Name	Buyer Address
A100	Red Car	Gas	Sam Smith	Newark, NJ
A100	Red Car	Gas	Jane Doe	New York, NY
B100	Blue Car	Hybrid	Sandeep Hanlon	Hartford, CT
B100	Blue Car	Hybrid	Tara French	Boston, MA

When I've entered A100 as the parameter, I'd like the output table to look like this:

A100	Red Car	Gas
Sam Smith, Newark,NJ
Jane Doe, New York, NY

Instead it looks like this:

A100	Red Car	Gas
Sam Smith, Newark,NJ
A100	Red Car	Gas
Jane Doe, New York, NY

I've tried various combinations of parent/child groups but haven't been successful. Thanks.

[braypa]

Thanks for the suggestion.  It turns out it wasn't the Parent/Child groupings that caused the issue but rather an issue with the expression that calculated the concatenated values field not working correctly if one of the values was null. I was able to resolve this by calculating the address in the data source rather than in the paginated report.

[Anonymous]

Hi @braypa ,

Based on the description, please try to create a parent group and create a child group.

Then, try to adjust the Tablix to display resulted data.

You can also view the following links to learn more information.

Add or delete a group in a data region in a Power BI paginated report - Power BI | Microsoft Learn

Solved: Paginated Reports - How To Create A Summary Table ... - Microsoft Fabric Community

Tables in paginated reports - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.