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