Kevin,

Good for you. While I still am using FPD 2.6, I am studying VFP and next year, when I am fully into it, will try to do the same.

Alex

>What I have done is create a report builder that allows the user to pick a report from a treeview. When they pick the report it lists all the fields in a listbox that they can pick from (Descriptions of fields not field names). They then can pick the fields that they want to pull info on and as they pick them it adds those fields to a form on the fly that is on the main form. They then can put in whatever criteria they want in the fields they pick. I take these objects along with their values and build the where clause in the SQL. They also can pick the Sort which is a listbox that adds fields to another listbox and this creates another macro for the order clause. They then can pick up to 5 groupings (report bands) from another list of the fields that they want the report to group on. This creates 5 fields called grp1,grp2,etc that are added to the SQL. The report form has these groups set up already and shows those bands with subtotals etc only if they have something in them. There is
>also another drop down next to each group combo that allows for some addition building of groups such as Month which builds a CMONTH around the date field, etc. They can then save their criteria and give it a name for easy access for next time. They also have the option to send it to the printer, screen, or an excel file. Whew!