none
SSRS report grouping problem RRS feed

  • Question

  • 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

    Friday, November 30, 2018 8:18 AM

Answers