Query Help - Group By 2 tables

[bbranco]

Hi,
I am relatively new to Crystal Reports and I need to accomplish this.

Basically what I need is if the item has Onhand > 0 and the sales for the date parameter is 0, include it on the report

Table 1:
Invoice # Date Item Quantity
1000 03/01/24 ABC1 10
1001 03/01/24 DEF1 20
1002 04/01/24 ABC1 20

Table 2
Item Onhand
ABC1 40
DEF1 50
GHI1 200
JKL1 250

I have a date parameter so the user enters in a from and to date range.

Date Range 03/01/24 to 03/31/24
Item Onhand Sales
GHI1 200 0
JKL1 250 0
(item ABC1 and DEF1 are in the date range)

Date Range 03/01/24 to 04/30/24
Item Onhand Sales
JKL1 250 0
(item ABC1, DEF1 and GHI1 are in the date range)

Can someone help with this? I have been working on it for a while and I am stuck.