Query based on 2 date fields
I have a following report requirement.
Identify the sales figure for multiple periods (variable of type range) for those contracts validity date ending a particular date range (variable of type range). Report should show contract numbers even though there is no sales activity in the given period. Expected output is
Contract No, Item, Start dt, End dt, Material, Sales Amount
I have 2 ODS one for the contract and the other for the sales. I tried with Infoset it showing report only when sales transaction present for the contract.
how can I achieve this report?
Thanks in advance.