Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group twice by different ways
Message
 
To
26/03/2003 05:17:30
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00770122
Message ID:
00770240
Views:
12
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 && group by year
      select .... group by year ... into cursor ....
      report form byYear preview noconsole
   case ThisForm.TheOptionGroup.Value = 2 && group by priority
      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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform