>In VFP report designer, do I have to fixed a grouping for the report format and design x number of report formats against x number of grouping? Or can I on runtime, change the Report Grouping information?
>Thanks.


Suppose you have a table called "Sales" with three fields: region, department, and sale_amount.

You can create a report listing the three fields but with a dummy grouping expression by combining the macro substitution "EVAL" function with a memory variable called cDummyGrpVar. Make your grouping expression for your report as follows:
EVAL(m.cDummyGrpVar)
Just before you invoke your "Report Form ..." command, assign the field name you want to group this particular report by to the memory variable cDummyGrpVar and the report should group on the field you have selected.

So, if you say:
m.cDummyGrpVar = 'sales.region'
report form ...
Your report will be grouped by region. If you say:
m.cDummyGrpVar = 'sales.department'
report form ...
Your report will be group by department. Pretty slick eh? Further, no reason why you can't have 3, 4, 5 ... levels of grouping expressions each with it's own dummy memory variables to really make a single report design work for you.

Paul