Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Loop
Message
De
13/06/2001 18:09:24
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
 
À
13/06/2001 17:16:19
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Re: Loop
Divers
Thread ID:
00519079
Message ID:
00519102
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
Hi Chuck,
Here's how I would approach it. Create one SQL statement that retrieves the right records and then issue REPORT FORM once. In the Report you'll need to create a Data Group for Organization, or whatever each report was focused to, and check the appropriate stuff in the Data Grouping Dialog.
SELECT P.Name, ;
    A.AuthType, ;
    A.Limit, ;
    A.Fund, ;
    A.Project, ;
    A.Program, ;
    A.Account, ;
    A.SFS, ;
    A.MCC, ;
    O.Orgainization ;
   FROM Org O ;
      JOIN Author A ;
      ON O.Organization = A.Organization
      JOIN Person P ON A.ID = P.ID ;
      WHERE (A.End > DATE() OR A.End={} ;
      ORDER BY O.Orgainization, P.Name, A.AuthType
Charlie
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform