Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reporting a table below another table
Message
From
16/01/2008 11:12:49
Victor Chigne
Inteliventas
Peru
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01279498
Message ID:
01282274
Views:
17
Thanks Cathy, it worked for a new report. On the last one, I put the secont table detail and totals in a dummy memo :)

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform