<It works when I export through the CrystalReportViewer object.
I don't know Crystal too well, but isn't that what that object is for? You don't describe what you mean by "via code" but it's safe to assume that Crystal has some specialized requirements to export reports into some standard data format. So, if it works, then why not do it that way?
Bob