Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simulating 2 detail bands
Message
De
27/12/1999 11:44:24
 
 
À
27/12/1999 10:51:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00308778
Message ID:
00308795
Vues:
13
>Is it possible with the foxpro native report writer Nest detail bands, or create 2 detail bands?

The best you can do is to simulate 2 or more detail bands using some condition for the "print when". You would need to "combine" the data for the multiple detail bands into one cursor for the report, identifying the different "detail bands" in the cursor.

Table1 has field1 & field2
Table2 has field3 & field4
SELECT '1' AS BAND, ;
       field1, ;
       field2, ;
       field3 AS SPACE(whatever), ;
       field4 AS SPACE(whatever) ;
       FROM table1 ;
       UNION (SELECT '2' AS BAND ;
                     field1 AS SPACE(whatever), ;
                     field2 AS SPACE(whatever), ;
                     field3, ;
                     field4 ;
                     FROM table2) ;
       INTO CURSOR reportdata
Now use the cursor field BAND in the "print when" conditions.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform