Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reporting a table below another table
Message
 
À
07/01/2008 09:42:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01279498
Message ID:
01279979
Vues:
24
This message has been marked as the solution to the initial question of the thread.
You can use multiple detail bands to pull this off. Create a dummy table with one record and set a dummy relationship to each of the 2 tables you have. Put everything for Table 1 into the Detail 1 band. Check the Detail Header and Footer band checkox and put your totals for table one into the Detail 1 Footer band. Do the same for the 2nd table using the 2nd detail band.

>Basically, I have 2 unrelated tables, and I have to report one after the other in the same report. I can`t use two reports without eject page.
>
>The layout is:
>
>Table 1
> Details
> Totals
>
>Table 2
> Details
> Totals
>
>
>>I'm not clear on what you want. Could you be more descriptive about what is coming from what table .. and which lines are "totals" of previous records and which lines are the detailed records themselves.
>>
>>
>>
>>>Hello.
>>>
>>>I have a report who needs to include a totals page wich is in another table.
>>>
>>>Example:
>>>
>>>Vendor Doc Amount
>>>Vendor Doc Amount
>>>Vendor Doc Amount
>>>Vendor Doc Amount
>>>
>>>Total amount xxxxxxxxx
>>>
>>>Vendor1 #docs amount
>>>Vendor2 #docs amount
>>>Vendor2 #docs amount
>>>Vendor2 #docs amount
>>>
>>>
>>>
>>>
>>>How can I make this report? TIA
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform