Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Loop
Message
From
13/06/2001 18:09:24
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
To
13/06/2001 17:16:19
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: Loop
Miscellaneous
Thread ID:
00519079
Message ID:
00519102
Views:
16
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform