Hello forum,
I have just started using Crystal Reports. I'm using visual Studio 2005. I have a dataset with 2 tables.

Datable1:
MainItemIndex
ItemNumber
Description
qty
price

datatable2:
MainItemIndex
SubItemIndex
Description
qty
price

Im trying to link each SubItem(datatable2) with the MainItem(datatable1) using the MainItemIndex field. I can link them but I get the following

Item:1 Description Main Item Qty:12 Price:$12
       Description Sub Item 1 Qty 4 Price $0.50

Thats fine if I only have 1 sub item for each main item.
But If I have two subitems I get.

Item:1 Description Main Item Qty:12 Price:$12
       Description Sub Item 1 Qty 4 Price $0.50

Item:1 Description Main Item Qty:12 Price:$12
       Description Sub Item 2 Qty 4 Price $0.50

I would rather have it like the following.

Item:1 Description Main Item Qty:12 Price:$12
       Description Sub Item 1 Qty 4 Price $0.50
       Description Sub Item 2 Qty 4 Price $0.50

Item 2 .........

I have tried and googled for hours. Any help would be appreciated . Thank you

Also forgot to mention if I dont have a sub Item it does not show a main item.


Edited by darknoobie - 07 Nov 2012 at 6:28pm

I think that what lockwelle is saying is to try creating a group on table1.mainindex (or any other field that you would use to sort the data from table1.