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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DerMainzer
Resolver I
Resolver I

Paginated Report MATRIX consolidates

Hi,

 

I've creates a matrix in my pag report that works - BUT - it only shows the first 4 rows from my data. It somehow consolidates or so.

I have 25 rows  with 17 different "properties" in my dataset but only 4 will be shown

 

Does anybody have an idea why and what to do?

 

Thanks in advance18-04-_2023_22-12-07.jpg

1 ACCEPTED SOLUTION
Jon-Heide
Employee
Employee

It's *probably* the way the grouping has been defined in the report. When you create a group, it'll show a row for every unique value. Also, just in case, check that there isn't a second page. 

 

From your picture, not sure why using a matrix instead of a table, as I see groups only on the rows. 

 

Try reviewing these links on how to build nested groups. Suggest starting with a basic, single row group, then adding in more groups and details. 

 

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/create-a-matrix-report-builde... 

 

https://www.tutorialgateway.org/grouping-in-ssrs-matrix-reports/

 

https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/reporting-services-basics-ad... 

View solution in original post

1 REPLY 1
Jon-Heide
Employee
Employee

It's *probably* the way the grouping has been defined in the report. When you create a group, it'll show a row for every unique value. Also, just in case, check that there isn't a second page. 

 

From your picture, not sure why using a matrix instead of a table, as I see groups only on the rows. 

 

Try reviewing these links on how to build nested groups. Suggest starting with a basic, single row group, then adding in more groups and details. 

 

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/create-a-matrix-report-builde... 

 

https://www.tutorialgateway.org/grouping-in-ssrs-matrix-reports/

 

https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/reporting-services-basics-ad... 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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