Group data in rdlc report RRS feed

  • Question

  • I need to show Order Details according to the OrderID in Orders table. Below is my dataset

    and this is my report.

    But this doesn't generate the result as I expect. What I expect is below.

    Order ID  Username Order Date

    111           abc             11/12/2013

            Item ID   Item Name    Unit Price

            1             item1             $10

            2             item2             $12

    Can someone please help on designing this report and also do I need to do any change in my dataset?

    • Edited by DevNC Sunday, August 10, 2014 2:00 AM
    Sunday, August 10, 2014 1:59 AM