When a report is saved to Excel (data only) it doesn't always show the exact same result as when saved to PDF, Word, or Excel (data + lay-out).

This is due to limitations in RDLC on calculated fields, but is very confusing for customers: especially those who have been upgraded or re-implemented from a classic NAV version to BC.

Example:

In report 113 Customer/Item Sales, when you save the report to Excel with data + lay-out, the profit % is calculated and shown in Excel as expected.

But when you save the report to Excel with data only, the profit % is not calculated and always 0 in Excel.