Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to include data from multiple tables in a report...
Message
From
05/07/2000 17:21:05
 
 
To
05/07/2000 17:04:03
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00388552
Message ID:
00388557
Views:
8
I can suggest 2 options:

1) Put all of the required tables in the DataEnvironment of the report and link them together like you would in the view designer.

2) Execute a sql select that joins all of the tables together and selects the required fields prior to designing and printing the report.

>Hi Guys
>Seeing as there is no way to reliably print ???, ?/?? reports on a network in VFP, I will have to beg advice on how to get the data from a number of tables onto one report. I am trying to build an invoice that gets data from a number of tables ie: labor, parts, flatrates, etc, and get them all into their own 'groups' on the report. With ?/?? it is simple, but in report designer there is only 1 'details' band, so how the hell do you get it all to come out legibly??
>Your assistance is most appreciated!
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Reply
Map
View

Click here to load this message in the networking platform