There is a good reference to how to do this in the help that ships with Visual Studio .NET. With CR.NET, you would want to use the "Push" model for setting your data sources of the Crystal Report Object Model. Here is the link from within the help files:

ms-help://MS.VSCC/MS.MSDNVS/crystlmn/html/crconreportdataaccess.htm

Then after that page, follow the link called "Reporting off an ADO.NET Data Set" for more information of how to impliment the Push model. You can do what you are currently doing in VFP but using DataSet(s) instead.


>I used to have a VFP reporting application, using Crystal Reports 8.5.
>
>Most reports utilized three files...HEADFILE, DETFILE, and SUMFILE (for report and column headers, detail lines, and subtotals). All three were linked in the RPT file itself.
>
>The application would prepare these three files (FOX2X DBFs...I always avoided ODBC with CRW), put them in a run-time defined temporary location, then use the following CRW API function...
>
>nCRWResult = PESetNthTableLocation(nPrintJob,1,runtimedir + '\HeadFile')
>nCRWResult = PESetNthTableLocation(nPrintJob,2,runtimedir + '\Detfile')
>nCRWResult = PESetNthTableLocation(nPrintJob,3,runtimedir + '\SumFile')
>
>And if the report used subreports, I'd use PEOpenSubreport() to get the print job number, and pass that on as additional calls into PESEtNth...
>
>All that worked fine and dandy for years...and now it's ADO.NET time.
>
>I'm having some difficulty finding the same syntax when I create and use a Report object. I can use Crystal .NET to specify a single Dataset for a data source at runtime, but haven't quite figured out how to do what I described above (specifying multiple files). Is the syntax similar and I'm just missing an object reference, or do I need to do something completely different?
>
>Follow-up question...does CR.NET have the same capabilities as CRW 8.5?
>
>Thanks much...
>Kevin