Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group twice by different ways
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00770122
Message ID:
00770240
Vues:
10
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform