Hi Walter

I have already put the data into a FOX table and the report is very fast now. Previously it had to gather data from at least 10 tables in SQL Anywhere and it took a long time to run. Yes, I used VFP to munge the data so that Crystal could be optimized.

I have already suggested that I can automate the process for them using VFP since it is rather simple to do. However, I wanted to ensure there was not an existing method in Crystal for such a process. Since I have not used Crystal before nor am I the person developing the Crystal reports I wanted some feedback from someone with more experience so I could judge the skill level of the Crystal developer to make sure we were not missing some functionality already in Crystal.

Thanks for your suggestion as it is basically what I had considered doing.

Simon


>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