Missing data in export of report to Excel

[bobm]

Hi,



I have a report where there is usually duplicate data for the first of seven columns. If I turn Hide Duplicates to 'no' in the text box properties then the export to Excel is fine. When I put 'yes' the excel display is missing data at seemingly random places.
Any idea what may cause this?

Cheers
Bob

[June7]

No, but I do know export of reports can be unsatisfactory, especially the more settings are applied, such as Grouping and Sorting. Why export report and not query?

[bobm]

No, but I do know export of reports can be unsatisfactory, especially the more settings are applied, such as Grouping and Sorting. Why export report and not query?

Why don't I use a query? I don't wish to see duplicating data. I don't know how I can hide duplicated data and export the result