Very Strange Problem/ Exporting Reports

[liimra]

I have created reports with calculated fields & added three buttons on each report (export to excel, rtf, pdf, html). Everything seemed to work very fine but unfortunately I am facing very weird problem.

There is a problem with the calculated (or concatenated) fields when exporting the report to Excel, RTF or HTML while there is no problem with PDF. The funny thing is that I face no problem when I export the report using the button found in the ribbon under external data!!! I even tried to export using DoCmd.Runcommand (acCmdExportExcel), and logically this should give the same result as the export to excel button in access but unfortunately it doesn’t!! and the calculated fields still have a problem (the first two rows are ok)


Example:
BankA BankB TotalBanks (Equal BankA+BankB)
5 //////// 15 //////// 20
5 //////// 10 //////// 15
10 /////// 12 //////// 22
15 /////// 2 //////// 22
20 ////// 5 //////// 22
30 ////// 3 //////// 22
1 //////// 1 //////// 22 and so on

Initially I used this and the output is the same DoCmd.OutputTo acReport, "Name", acFormatXLS, , True

Any Help is appreciated and thanks in advance for taking time to go over my issue

Regards,
Ali

[liimra]

Dear All,

First, Sorry for the mistake I should have stated 4 buttons instead of 3.

Second, I expected a faster interaction but this how it usually goes :).

Anyways, just to clear the air as some other people might face this problem --> a simple solution is to make the calculations in the Query and not in the report itself. But honestly, I want to share the strange thing I was facing with someone else --> just to share than getting a solution and really try it; it is funny!! if you use the built in button to export it has no problems and when you use DoCmd.Runcommand (acCmdExportExcel) it gives problems really funny unless I am missing something in there - both are the same.

Best Regards,
Ali