How to Create "Group Reporting using Data Report "

[taong_grasa]

Pls. tell me how to create a group report... the problem really is... I don't know how to create a report that would display all the orders from "Orders" table and its details from "OrderDetails" table group by OrderID..

Here's the sample view of the report:

OrderID------CustomerID------PONumber------OrderDate
0001 ------- C-0001 ------ PO-0001 ----- 02/25/2005

ProductCode ------- Quantity
NRCP 6--------------25
NRCP 12-------------10

Here's the structure of database:

Table Name: Order
Fields:OrderID,CustomerID,PONumber,OrderDate

Table Name: OrderDetails
Fields: OrderDetailID,OrderID,ProductCode,Quantity

Relationship: One-to-Many