I'm embarased to ask this, I'm sure the answer is really simple. I'm working in SAP B1 2007 and CR 2008. I have OITM and OITW tables, where OITM is all the basic data about each item (SKU, Description, Vendor, etc), with one line per item, and OTW is all the warehouse specific data (BOH, Min/Max, etc) about each item, with 8 lines of data per item (I have 8 warehouses). I want to create a report that shows each item only one time, with basic info and WH specific info. If I use OITM inner join OITW on OITM.ItemCode = OITW.ItemCode, I get 8 entries for each item. I used a sub-report, which worked great, but now I need to sort the results by one of the fields in the sub-report.
Is it possible to sort by the results of a formula in a sub-report?
Or, how do I join OITM and OITW so that I only get 1 result per item with all the info?
Thanks.