I'm working on a Crystal Report which will save to multiple PDF files, each file having a different filter. For example, it will print JOHN.PDF, RON.PDF, and so on. Each file uses a filter to select only the records for that rep. I like to use 1 dataset as recalculating takes forever. I can't use DataView because Crystal Reports doesn't support it.

Is there a ADO command somewhere which filters the dataset so only specified records will be visible; for example, userid = "Erik"?

If it doesn't exist, how can I, by program, delete or insert the dataset records?

Erik