Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create One-to-many report without using the wizar
Message
From
16/04/2002 02:51:21
 
 
To
15/04/2002 23:19:44
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00645281
Message ID:
00645305
Views:
10
>*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
Previous
Reply
Map
View

Click here to load this message in the networking platform