Report Format Required in RDLC

Question

I have data in below form

Now i want to convert it into martix Report ,but have limit on columns 4 of Weight

Like below Format

Answer 1

Hi @Analyst_SQL ,

Base on my experience，it may not be possible to achieve that with a matrix.

when you set a matrix report，you will have column group and row group， column group should not depend on row group ,the reverse is also the same, they should be independent. As in your situation，if you set weight as the matrix columns，then every distinct weight will have one column ，and I think it is not what you expected.

Alternatively，you can use table to achive your goal and it is much simple .

Here is my test report on you issue. HTH.

Best Regards,
Isabella

---

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.