Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create One-to-many report without using the wizar
Message
De
16/04/2002 02:51:21
 
 
À
15/04/2002 23:19:44
Hee Lim Wang
Fantasy Software Enterprise
Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00645281
Message ID:
00645305
Vues:
11
>*form.init
>Create Cursor detail(ac c(10),amount N(12,2))
>INDEX ON ac TAG ac
Set Order To AC
>CREATE CURSOR account(ac c(10),name c(20))
>INDEX ON ac TAG ac
Set Order To AC
>SET RELATION TO ac INTO detail
>SET SKIP TO detail
Set Skip To ACCOUNT && If account is the child alias
>.......add some records into curosr.......
Select DETAIL
>report form MyReport preview

If Your parent table/alias is account, then change all the aliases from SET RELATION and SET SKIP TO

SELECT detail
SET RELATION TO ac INTO account
SET SKIP TO detail
SELECT account
REPORT FORM myreport preview


Mauricio
Be fast like the Fox
Be free like the Penguin
Se Rápido como el Zorro
Se libre como el Pingüino
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform