Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simulating 2 detail bands
Message
De
31/12/1999 15:48:54
 
 
À
27/12/1999 11:44:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00308778
Message ID:
00311023
Vues:
19
I am looking for a solution myself. In the top of my form I faked running a "Short" detail for one sql selected table and just added all records into a variable using scan/endscan and let the field-box's "Stretch" feature of the rpt-wrtr do the word wrapping using Courier-New, a fixed-cpi font. This is limited in size unless this info is put into a memo-field. I still have the problem of outputting 2-lines per record (some blank to be filled with SPACE()).
I will try The "Union-Print-when" strategy below.

>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform