Our accounting department uses crystal reports and has a report that gives a list of customers and payments by those customers. I have been asked to take that report and make an automated process with it that will fire up each day to run the report and export the data to sql server. I created a new crystal report project and used their report as the datasource. When I run it, the data shows up fine, but programmatically, I'm not sure how to get to the data to get it into a view or dataset or something. I've done some searching for this, but all the articles I've seen were on creating crystal reports with .net, not with exporting the data from a report. Can anyone tell me how to do this or point me toward a tutorial that covers this? Thanks!

I'm not sure that you can export data that you see on the report, because the report relies on a datasource from something (SQL Server, Access, etc) To export the data you see on the report, you would have to export the underlying data. When you say you are trying to export the data to SQL Server, are you trying to add data to a database? Or just trying to export the report itself so that others can see it?

I'm trying to export the data from the report and add it to the sql database. The report is being generated from Mas90 which from what I understand is nearly impossible to query in .net or anything else. You have to use a proprietary tool to manually export a file from Mas90 that .net can work with. At least, that's what I've been told. But I'm looking into finding an alternative to that too. Thanks.