export report to excel

[sdel_nevo]

Hi All



been looking in the forum but can't seem to find out if this is possible

i have a report called "profit and loss" that is not based on a query but has lots of unbound fields, these fields are populated by Dsum values, the report is filtered between to dates from the form that opens it "open Profit and loss Form"

is it possible to have a button on the report that when clicked exports the report into excel and also keeps the formatting?

if i preview the report and right click - export to excel all the data is placed in the same row, and no formatting is carried over.

Many Thanks

Steve

[rpeare]

exporting a report directly to an excel spreadsheet, probably not. You'd likely have to cycle through the data source driving the report and export cell by cell. If the export to excel is giving you the numbers you want, just not in the correct format you may be able to, instead, open the excel file after the export is completed, modify the format of ranges of cells to be what you want, then close the file again. I believe you can suppress the excel window from showing in your hotbar as well so it looks seamless.

[sdel_nevo]

Hi rpeare

thanks for the response, i have just noticed that no data is exported, the labels are but the data that fills the unbound text box does not?

should the values be exported? or will i have yo base the report on a query?

Steve

[rpeare]

Typically when you export a report to excel none of the formula fields go with it, usually it's just the data that comes from the query/table (I don't export reports very often, maybe once every couple of years). So the short answer is yes, if you want to see your data in a certain way when you export it it's probably better to base your report on that query or, alternately, create a query that has the exact same data you want and export the query as an excel spreadsheet rather than the report itself.

[sdel_nevo]

Hi

thank you for that mate

i will create the query and export that.

many thanks

steve