I have created a report that previews absolutely fine but when I try and export to Excel I get a blank sheet.
The report is based on two linked tables.
It has a detail line listing sales prices for all of orders.
Because each order could have more than 1 product sold against it there is a footer to the detail that sums the sales prices.
It then lists (within the detail footer) payments made against that order and compares it to the sum of the sales prices.
Any ideas? Been really bugging me to try and sort this out.
The report is based on two linked tables.
It has a detail line listing sales prices for all of orders.
Because each order could have more than 1 product sold against it there is a footer to the detail that sums the sales prices.
It then lists (within the detail footer) payments made against that order and compares it to the sum of the sales prices.
Any ideas? Been really bugging me to try and sort this out.