Detailed Sales Showing All Departments and Categories

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

Reply to
toploader
Loading thread data ...

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

Reply to
cptsoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.