I think i understand what you mean...
You could create a report grouped by year for instance ( let's call it byYear ) and another report grouped by priority ( byPrio ).
In your form, i guess your users have some optionbox or the like to choose which type of report they want. Let's call this optiongroup value 1 for grouped by year, and 2 for grouped by Priority.
You should just switch "REPORT FORM" commands, based on the value of this optiongroup. For you it's many reports, but for your user it's transparent, it seems like one report. So, your command should look something like
do case
case ThisForm.TheOptionGroup.Value = 1
select .... group by year ... into cursor ....
report form byYear preview noconsole
case ThisForm.TheOptionGroup.Value = 2
select .... group by priority .... into cursor ....
report form byPrio preview noconsole
...
endcase
Hope this is what you meant...
Jaime
>Thanks,Liam
>But I don't have prolem with the 'group by SQL statement'.
>I have the results in cursor.
>I have a problem to print the cursor grouped by different ways (if you use with form disiner wizard you can see the groups options in step 2 - I speak about this category).
>Chaim
Why do programs stop working correctly as soon as you leave the Fox?