Totalling Related Tables

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
RoyP
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

Totalling Related Tables

Post by RoyP » Thu Sep 22, 2005 7:41 am

I have what on the surface appears to be a simple totalling problem and beleive I must be missing something very simple.____I have created the situation with Sample tables and can email a Zip file with sample data and report showing the situation, if anyone can help then please answer showing your email address.____What I cannot seem to do is create independent totals for the Master Table and the Related table, what happens is that the related table totals become multiplied by the number of records in the Master table.____I have tried various options within the totalling area e.g. using ^SCANNING^ as a condition but this will not help, I have tried greating a group based upon the linking field for both the Master and the Related table.____Prevoiously I have exported totals from 2 separate reports and then picked up the exported tables with a third report and then printed the results as I expect.____Help please this is silly I am sure.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Totalling Related Tables

Post by kfleming » Thu Sep 22, 2005 4:30 pm

You can send the file to livesupport@livewarepub.com____Kathleen__R&R Support

Post Reply