I Have a main report with 2 groups and 1 detail section. The subreport is in the detail section as each record on the main report might/might not have a matching subreport record. The records I need to see are all those on the main report with a matching record in the subreport. For example the main report is Stock in main warehouse and the sub report is Stock in bulk warehouse. I want to see where the stock is low in main warehouse but have stock in bulk. The link between the main and subreport is SKU ID.
It may be of use to know that if there is no stock held in the bulk warehouse the subreport will be blank so ultimately the report will show me a list of stock that needs replenishing from Bulk Warehouse.
Any assistance on this would be greatly appreciated :-)
Many thanks in advance,