>>I am creating a program for my Dad to keep track of the standings in his Bass Fishing Club. The number of tournaments varies from year to year so I created a function that creates a schedule table based on the Members.dbf and Tournaments.dbf. Any suggestions how to do a Report for this table that has varying field names and field counts? Is there any way to use the Report Generator or am I going to have to code this by hand? BTW, I am using VFP 3.0 for the PC.
>
>
>You need a cross-tab report. VFP comes with GENXTAB.PRG that will create the report for you.
Thanks for the suggestion, this gets me almost home. I have created a CROSS-TAB table and then can create a cross-tab SQL using that table. How do I get that into a report, keeping in mind that the fields will not always be the same?
--Shane