topic Report Builder - Matrix with text without aggregation in Report Server

Report Builder - Matrix with text without aggregation

pipkinp86 — Thu, 27 Jul 2023 22:01:25 GMT

I need to create the following report, the idea is that students will attend to all classes but in any day, the report needs to group who attend to what in a specific day, I'm using power BI report builder, but it's not working. I did was able to make it work on Power BI using

Measure: Student List = CONCATENATEX('Schedule',[Student],UNICHAR(10) )

Matrix with Class on Rows, Day on Columns and [Student List] on Values.

But I don't know how to make it work on Report Builder

Below is the data table and what I wanted to look like

Re: Report Builder - Matrix with text without aggregation

d_gosbell — Sat, 29 Jul 2023 04:10:21 GMT

pipkinp86 wrote:

But I don't know how to make it work on Report Builder

The identical approach should also work in Report Builder. If you use the [Class] and [Day] columns and the [Student List] measure you should be able to create a similar matrix output to the one you did in Power BI desktop.

Re: Report Builder - Matrix with text without aggregation

pipkinp86 — Wed, 02 Aug 2023 14:20:01 GMT

Hello, I was not able to use the measure within a matrix in Power BI report builder, I found another way to make it work, adding the measure withing the query, but if you can give me more details on how to use the first Power BI desktop approach, using the measure I created on power bi desktop, I would appreciate it.

Re: Report Builder - Matrix with text without aggregation

pipkinp86 — Wed, 02 Aug 2023 14:18:32 GMT

this is how I ended up fdoing it:

EVALUATE

(

SUMMARIZE(

'Schedule',

'Schedule'[day],

'Schedule'[class],

"StudentList", CONCATENATEX(VALUES('Schedule'[Student]), 'Schedule'[Student],", " & UNICHAR(10))

)