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 or relationships to make this happen. I am able to get the data but I’m having a problem with grouping.
Thanks,
Ltrain