SSRS report grouping problem

[tonylck]

I create a SSRS report with Visual Studio 2017 with SQL Server Data Tools. It is necessary to generate the report in the following layout

Code Description Unit
[001] [Remark 001] [BOX]
Supplier
Contract No. Supplier Name Order No. Order Date Qty
[000001] [Supplier A] [00100] [2018-01-01] [100]
[000002] [Supplier B] [00110] [2018-01-10] [200]

Code Description Unit
[002] [Remark 002] [BOX]
Supplier
Contract No. Supplier Name Order No. Order Date Qty
[000005] [Supplier C] [00110] [2018-09-01] [300]

Note:
Group By: Code
data fields are marked as []

How can I edit the report in order to display the above layout?

Thanks,
Tony

Continue reading...