No records exported in CR9 when records are suppressed

[themanpap]

Crystal Reports Professional 9 (9.2.3.1699, to be exact)
Windows XP
Connecting to an Access Database

I currently connect to several tables using CR9, and at times, I need to suppress the data because some records are very similar.
In the section expert, I check Suppress (no drill-down), and include the following formula:
ID = previous(ID)

I then get all the records I need. But when I export to a comma delimited file (.csv), I get no records. If I remove the suppression in the section expert, and then refresh the report (thus getting duplicates) and then export, I get all of the data (including the duplicates) in the .csv file.
It seems that the export function doesn't like suppression, even if there are still records being reported.
Does anyone have an idea how I can fix this?

 

[synapsevampire]

Try grouping by the ID field and placing the fields in the report header and suppressing the details and group footer.

-k