Sum of Field qty problem

[nogs]

When the grand total is calculated with only 1 database it is reported correctly, when I link 3 databases to enhance the report the grand total is coming out different? Nogs

 

[IanWaterman]

The addition of links is bringinag back either duplicates of your value, or is restricting values being returned because there is no corresponding data in the new tables.

If the former you will need to add selection criteria on fields in the new tables to eliminate duplicates.

If the latter you may want to use a left outer join from your first table to subsequent tables. But only if you want to see all records in the first table irrespective of whether or not there is data in the new linked tables.

Ian Waterman
Uk Crystal Consultant

 

[nogs]

Hello Ian
The reports is returning slightly more than double the original qty. The field in the grand total exists only in the original database. I'm using 2 search criteria - both on the original database, as above.HTH. Nogs

 

[Roadkill150]

I have to agree with Ian,
You have fields in the 2nd table that are causing it to appear you have duplicates.. I am sure you would find that if you put the relevant info from table #2 into the detail section you would see where your discrepancies are coming from.. Solutions to this are to either modify your selection criteria, setup grouping, use a conditional running total using distinct counts possibly..
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[nogs]

Thanks Guys,
by adding search criteria on the new tables I have solved the problem thanks for your help Nogs