Exporting Report - No file created

[jpatchak]

Hi, I have kind of a strange problem. I have a report that I need to export to excel. The report opens fine in Access and when I export it or click on "Analyze It with Microsoft Office Excel," I get the dialog that says it's exporting page n of total to file such and such. I get no error message. However, no Excel file is created.

I've tracked down the problem to one of my fields on the report. It is a field called "ExpectedRate," with the control source of the "ExpectedRate" field on the query (format: Currency) on which this report is based. If I remove this field, exporting works as expected. Has anyone seen this before?

I know that I can get around this using ADO and OLE commands, but I'd rather not put in the time doing that. I don't need it to look fancy - I just want the data showing in my report to show in Excel so I can use it in another program.

Thanks,
Josh

[NeoPa]

I'm afraid that doesn't ring any bells with me Josh.
Without knowing any details it's hard to dig deeper.

[MMcCarthy]

Hi, I have kind of a strange problem. I have a report that I need to export to excel. The report opens fine in Access and when I export it or click on "Analyze It with Microsoft Office Excel," I get the dialog that says it's exporting page n of total to file such and such. I get no error message. However, no Excel file is created.

I've tracked down the problem to one of my fields on the report. It is a field called "ExpectedRate," with the control source of the "ExpectedRate" field on the query (format: Currency) on which this report is based. If I remove this field, exporting works as expected. Has anyone seen this before?

I know that I can get around this using ADO and OLE commands, but I'd rather not put in the time doing that. I don't need it to look fancy - I just want the data showing in my report to show in Excel so I can use it in another program.

Thanks,
Josh

Try changing the format of the field from currancy to double. Does this make any difference?

[MMcCarthy]

Just had a thought. Is your report based on a query and does the query run OK outside of the report. If so can you export the query to excel?

[nico5038]

I've had some trouble with numbers when the Regional settings (Start/settings/Control panel...) were having a decimal separator like "." and for currencies "," or the other way around. I guess you might check their settings.

Nic;o)

[jpatchak]

Just an FYI, the report was based on a SQL Server view - linked using ODBC. This means that Access was treating the view/query as a linked table. It was running fine in the table. I changed the control source on my report to
=CDbl(ExpectedRate) and now it works fine. thanks.

[MMcCarthy]

Just an FYI, the report was based on a SQL Server view - linked using ODBC. This means that Access was treating the view/query as a linked table. It was running fine in the table. I changed the control source on my report to
=CDbl(ExpectedRate) and now it works fine. thanks.

Thanks for posting the solution. It may be helpful to other members.

Mary