Hi simon,

First of all, I would gather the data from the database regarding all students in one FOX2X table. USe the Fox2X table as the source for CR9. Then loop through all students in VFP, and set a filter in CR9 to the selected student in VFP, then do an export to a PDF file. After setting a filter you might have to refresh the reading of data, but I´m not sure though.

Another strategy is to loop through each student in VFP, export the data of one student into a FOX2X table, refresh the data in CR9 and export it.

Anyways, it is going to be a rather timeconsuming process if you want to export to 3000 PDF files....

Sorry for not providing any code, but my time is very limited right now...

Walter,






>Hi
>
>I have a client who is printing report cards for a school. A VFP table contains all the report card data for each student. The client wants the output to be produced as separate PDF files, one for each student. At present it prints one PDF containing the report cards for each student on a separate page resulting in a 3000 page report.
>
>My question is what settings have to be changed to ensure it prints all the students but saves each students report as a separate PDF file?
>
>Obviously I have not used Crystal Reports before so any tips would be appreciated. The report is written in version 9 using VFP tables as the data source.
>
>I know I could set a parameter for the student number and then run the report specifing a new parameter each time. However, we just want to run the process once and have it produce all the PDF files with correct page numbering.
>
>Thanks
>Simon