Report Builder 3.0 Grouping but info in every row

Question

Report Builder 3.0 Grouping but info in every row

Knuif, MBG (Martin) 41

I have made a report en made a group (Name, Place, Afk), the result is like the first screenshot. I like to have in the red cels that there was also the data of the cel above, see the green cels in the second screenshot. So I don't have to do anything when exporting to EXCEL. Who can help me? Thanks in advance ![69746-screenshot1.png][1]![69739-screenshot2.png][2] [1]: /api/attachments/69746-screenshot1.png?platform=QnA [2]: /api/attachments/69739-screenshot2.png?platform=QnA

Accepted answer

0 additional answers

Your answer

Answer 1

Joyzhao-MSFT 15,636

Hi @Knuif, MBG (Martin) ,
Assuming [Place] group by [Name], when we create a group, a new column [Name] will be added, delete the [Name] column, and select "Delete column only". Then insert [Name]Details outside the group.
I did the test locally, you can refer to the following operations:

First I have an original table, and I have messed up the order of name and place. As shown below:
Create a group, where I set [Afk] group by [Place], [Place] group by [Name], and then delete only the column of the parent group, as shown in the following gif file:
Export to Excel file for viewing:

Hope this helps.
Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Knuif, MBG (Martin) 41 Reputation points

2021-02-19T11:19:40.69+00:00

Thank you for uour quick response, and very helpful to show that in a video.
Bit now I see I forgot the most relevant detail. My problem occurs in a matrix-report. I tried your solution in my matrix report but unfortunately it is not working. Can you help me …. again?
Joyzhao-MSFT 15,636 Reputation points

2021-02-22T02:34:15.083+00:00

Hi @Knuif, MBG (Martin) ,
What is the structure of your matrix report? Could you provide some samples?
Judging from the data you provided before, I think tablix is more suitable for your needs.
Tablix has a fixed number of columns and a variable number of rows. In other words, the number of rows in the table depends on the number of result rows returned after executing the database query.
Matrix is that rows and columns are variable. The matrix displays data in a structure similar to a cross-tab or axis table. Rows and columns can be grouped.
Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Knuif, MBG (Martin) 41 Reputation points

2021-02-22T07:06:35.5+00:00

Hi @Joyzhao-MSFT ,

I sent you mine example of a matrix-report and I hope it shows to you what I finally want.
Thanks again in advande.

Martin Knuif
Joyzhao-MSFT 15,636 Reputation points

2021-02-23T06:27:36.977+00:00

Thanks for your feedback, but I'm sorry I actually want to know what your current matrix looks like, because this seems to be just a screenshot in Excel. What is the table in the database? This looks like a combination of two tables in the database.
Knuif, MBG (Martin) 41 Reputation points

2021-02-23T08:04:03.043+00:00

@Joyzhao-MSFT
Thanks for replying. You mean the table underneath? Thanks in advance.
Joyzhao-MSFT 15,636 Reputation points

2021-02-23T10:07:49.41+00:00

Hi @Knuif, MBG (Martin) ,
OK, I see. I will demonstrate as follows, please check carefully, I left blank for the month column, because it is not difficult for you.

Best Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Knuif, MBG (Martin) 41 Reputation points

2021-02-23T14:09:01.667+00:00

Hello @Joyzhao-MSFT It's fantastic, it works.
Can you also help me in the next case?
I want a total of all [Sum(TotalWaarde)] in every column. It seems to me simple, but everything I tried failed. I often get a total per line, but I want per column a total of all lines.
Thanks again in advance.
Joyzhao-MSFT 15,636 Reputation points

2021-02-24T01:37:45.77+00:00

Hi @Knuif, MBG (Martin) ，
Judging from the title of the case，It seems this is one question that worth to be separated in one independent thread, how do you think ?
Could you help kindly to close this thread and mark helpful answer and open a new thread so we could work on that ?
Thanks for you understanding ! :)

Best Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Report Builder 3.0 Grouping but info in every row

0 additional answers

Your answer