I'm after writing a report that shows sales for all deaprtments and catergories, even those that haven't got sales. This is because i want to link to a table with forecasts and although you may have a value in the forecast you may not have taken any sales for it.
I have tried all combinations of joins but only seem to be able to get the report to show departments and categories that have taken sales for the period selected