I am developing a SSRS Report, which is based on three tables, Orders , invoice and receipts
the relation between orders and receipts is one to many
the relation between orders and invoice is one to many
and there is no relation between invoice and receipts
I am using left join between these tables to get data.
In my report there are columns related to all 3 tables,
My requirement is date wise filtration of all records , i.e. if order date is not in between search dates it should not display but if receipts or invoice exists it should be shown.
please find the attachment for sample data and report format. Sample.xlsx