I have 2 tables, table 1 "Stores" and table 2 "Invoices"
My report will show the stores and invoice totals for the previous day, however if there are no sales on any specific store, no data is showing on the report and I would prefer to show the store and a zero value.

I have tried a left outer join from stores to invoices but still not showing.

In my select record my only filter is invoice date = yesterday

example
store number      Total
store 1           100
store 2           0
Store 3           500


Instead I am getting the following
Store 1           100
Store 3           500