Crystal Reports Linked Tables/ formula
Posted on 2012-09-14
Hi, I hope I can explain this correctly, complete novice in Crystal!
I have a report created that I export data form an Access DB into a csv file. The crystal report contains 3 tables at the moment, linked with left outer join and with internal reference as the field that should be matched. This works fine
I have now added another table that contains around 12 records. I have checked and these 12 records are present in all 3 of the existing tables, so I added the table again with a left outer join and with the same field. I have a formula field in crystal called paid, which adds up the field paid in all 4 tables. Since I have added the 4th table, this field now only show amounts when there is data from the 4th Table, otherwise the field is just blank. All other fields are as expected. I'm certain that this is something to do with my links, I have tried everything but can not get the field to show the correct data in the paid field. The formula is very basic and just adds the paid fields from all the tables together. If I remove the 4th table from the formula all works fine, but without adding the amount from the 4th table.
Tables are linked as follows
table1 -left outer join =internal ref table 2 -left outer join =internal ref table 3 -left outer join =internal ref table4
I have tried other links but when I do this I only get the data from table 4, I missing something really basic I know
Can anyone put me out of my misery :-)