I'm trying to create a simple report that shows: Item, Description,
Batch, and Qty OnHand.
In the query element of my report I have the following datasources:
InventSum (ordermode==orderby)
|
|--InventDim (ordermode==groupby)(fetchmode==1:1)
(joinmode==innerjoin)
| (relation:
inventdim.inventdimid==inventsum.inventdimid)
|
|--InventBatch (ordermode==groupby)(fetchmode==1:1)
(joinmode==innerjoin)
| (relation:
inventbatch.inventbatchid==inventdim.inventbatchid)
|
|--InventTable (ordermode==groupby)
(fetchmode==1:1)(joinmode==innerjoin)
(relation:
inventtable.itemid==inventbatch.itemid)
My result should look something similar to this:
______________________________________________________________
| |
| Item | Description | Lot | On Hand |
_______________________________________________________________
|
| 100 | BMX Bike - Girl's Edit. | BMX003 | 56 |
| BMX004 | 73 |
_______________________________________________________________
| Total | 129 |
| |
_______________________________________________________________
| 102 | Skate Board | SKT002 | 104 |
_______________________________________________________________
| 167 | Basket Ball | BBL002 | 200 |
_______________________________________________________________
etc...
Can anyone offer some insight at to settings to make this happen. I
am able to get the data but I'm having a problem with grouping.
Thanks,
Ltrain
