I have a report that's run each month and the data transferred to an excel document for management reports.
The report tracks items entered into a system by Country, Object Type and Object Classification.
It's set up as a cross-tab report and it works fine as it is, BUT it (quite logically) only returns the rows for which there is a value in that month.
However, the excel sheet that they go into obviously still has the results from each country. Ideally I'd like to be able to export the BO report into Excel, paste that as a datasheet in the report workbook and have lookups fill in the values for each country/type etc. At the moment, because the BO report won't show the empty rows I can't do this.
How do I make my BO report show the empty rows (for instance, if France has no entries that month it should still show all the rows for France, just blank or zero)