Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Multi-Table Reporting
Hi All!
I need to figure out how to create a Foxpro report, from the report designer, that pulls data from two or more tables. The client wants something like this:
________________________________________________________________
Customer: XXXXX Home Phone: (123) 123-4567
Address: XXXXX Work Phone: (123) 123-7654 Ext. 123
XXXXX
________________________________________________________________
Manufacturer Style Code Quantity
Manufacturer Style Code Quantity
Manufacturer Style Code Quantity
Manufacturer Style Code Quantity
________________________________________________________________
Extra Description Extra Quantity
Extra Description Extra Quantity
Extra Description Extra Quantity
________________________________________________________________
Total Units Total Cost
The manufacturer info is from an sales file and is each line item sold. The extras come from a labor table for extra cost options. Both are related to the customer by a 'deal' number.
I can get either the manfacturer stuff, or the extra stuff, but not both on the same page.
TIA!
Tom.
I'm using Foxpro 6.0 on an NT network with the various defined printers for any of the workstations (Windows 95).
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement