Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to print one record with all child records
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00996520
Message ID:
00996661
Views:
12
I think that what you call "database" is a table,
are the two tables included to the report's dataenvironment?
If yes, create (with drag&drop) the relation into the report's DE and set the relation's property

OneToMany=.t.

this way the record pointer of the child table is moved and all the child record should be displayed

HTH
Franco

>Still having problems with report detail bars. I have a master database that I show in a form and you can use navigation buttons to go to the next or previous record. Each time you select a new record, I have set relation to for the child database and it shows the child records in a grid. All works fine on the screen. I have a [print] button to print the current record from the master database with all the associated records from the child database. If I use "report form name.fx NEXT 1 to printer, It prints the master record fine, but I only get one of the associated child records to print. Does the detail band also adhere to the NEXT 1 option and if it does, how can you print just the currect master record with all the child records?
Previous
Reply
Map
View

Click here to load this message in the networking platform