question

akhterhussain-3167 avatar image
0 Votes"
akhterhussain-3167 asked akhterhussain-3167 commented

Report Format Required in RDLC

I have data in below form

132102-image.png


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

Like below Format

132055-image.png


sql-server-reporting-services
image.png (9.8 KiB)
image.png (12.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

IsabellaZhangMSFT-7746 avatar image
0 Votes"
IsabellaZhangMSFT-7746 answered akhterhussain-3167 commented

Hi @akhterhussain-3167 ,

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.

132232-design-report.png


132242-report-review.png



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.


design-report.png (5.7 KiB)
report-review.png (5.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for Response,i already made above report,but i do not that format.

0 Votes 0 ·