I have a report which is running from a crosstab query, no issues with the running of report.
When I try to export the relt of the report to Excel I get an "Overflow" error message (that is all it says "Overflow"
.
All my value fields on the relevant tables are set to Double and I have calculations within the report with data formats set to both currency and percentage.
The values are divided by 1000 in the query so rthey are quite low values.
I do have some #Num & #Div/0 errors occuring on the report resulting from the calculation fields within the report (not in query) and I am using the Val(Nz()) funtions to return nulls as 0 in the query.
This error only occurs when I try to export to Excel.
Any help would be greatly appreciated!
When I try to export the relt of the report to Excel I get an "Overflow" error message (that is all it says "Overflow"
.All my value fields on the relevant tables are set to Double and I have calculations within the report with data formats set to both currency and percentage.
The values are divided by 1000 in the query so rthey are quite low values.
I do have some #Num & #Div/0 errors occuring on the report resulting from the calculation fields within the report (not in query) and I am using the Val(Nz()) funtions to return nulls as 0 in the query.
This error only occurs when I try to export to Excel.
Any help would be greatly appreciated!
