Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple details?
Message
 
À
17/06/1998 14:42:25
Shane Gilbert
Oklahoma State Department of Education
Norman, Oklahoma, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00109175
Message ID:
00109488
Vues:
17
>>Can you give a bit more of a scenario of the details. Its unclear what the totals are to represent and what the relationship between the groups are.
>
>I need a report based on about 20 different fields from several different tables. I have created 2 cursors one that has the header information - name, address,city,etc. the other has the details. There will be no more than twelve records per page which can easily fit on one page.The problem is that the information will not fit across one page even in landscape mode, so I need to put the first 10 or so columns on the top half of the page and the second 10 or so columns on the bottom half of the page.
>
>Shane

Sounds like maybe you could use 3 cursors instead of 2, and split the detail data fields apart (first 10 fields in one cursor, second 10 in another). You'll need a field to relate the header cursor to each of the detail cursors (SET RELATION). Then you'll need another field in the header table for grouping, i.e. PrintOrder,N,1. Setup your header table so that the header data is repeated in 2 records, one record for PrintOrder=1 and another for Print Order=2. Use this PrintOrder field as apart of your report grouping and index on the parent (header) table. In your detail line lay down the first 10 fields with Print When condition for PrintOrder=1. Lay down second set of fields over top of the first 10 with Print When condition for PrintOrder=2. HTH
Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform