crystal report selection criteria

When creating a crystal report, can I have different select criteria for different records within the same report?  For example, I am attempting to create a SMOI report and need current Inventory information ie, quantity on hand, average cost, etc but also need the unit sales history for a specific range of time ?  I seem to be able to have one set of data or the other, but never both?

Do I need to create the historical sale of units as a different group with different select criteria within the same report?  Ultimately, this report will just be exported to excel as a master data record and resorted and formatted. I am just trying to get all the data I need on one crystal report


 

Thanks,

Parents Reply
  • 0 in reply to tendresen

    IM5_InventoryTransactionDetail should probably be a left out join in case you did not have a transaction for an inventory item.  If you have an equal join, only records with transactions will be pulled in.  Also, if you have multiple warehouses, do you have the IM5 linked to the Master or the Warehouse?  What version of Mas are you running?  

Children
No Data