Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I create five detail bands in a report
Message
De
03/09/2001 07:38:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00551520
Message ID:
00551768
Vues:
27
>dear hilmar
>table 1 has field1,field2,fiedl3
>table 2 has field4,field5
>table 3 has field6,7,8,9,10
>table 4 has fiel11,12,13,14
>table 5 has field15,16
>thank you

Sure. I sent just an example.

In the example you give, you have to create field1..field16 for each of the five tables, same structure for each, and combine the results with a UNION. Add an additional field, "table", that says from which of the 5 tables the data comes. This allows you to print conditionally - for instance, the first sub-report is only printed for the condition "table = 1".

HTH! Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform