Filtered report and export it to excel

[like]

May Somebody help me

I want to running report with filter by combobox, and export this report to excel.

In fact, I can see the report with success, but when I see the xls result, it not represent the filtered report.

Can somebody help...?
thanks in advance

 

[gemma-the-husky]

filtering the form, doesn't change the underlying query, which is not filtered. You need to put the filter on the query as a criteria, I think

you may be able to save the report itslef as an xls sheet. try file... options, or try rightclicking in the preview report for options

 

[like]

Thanks for Your response
I fix it with macro, but the next problem coming
I have 5 reports need to export to one xls file, and those 5 reports want to
write to sheet1 .... sheet5.
How to solve this...?
thanks

filtering the form, doesn't change the underlying query, which is not filtered. You need to put the filter on the query as a criteria, I think

you may be able to save the report itslef as an xls sheet. try file... options, or try rightclicking in the preview report for options