Record counted twice?

[maggi]

Hi,

My report uses two tables that have a left outer join. Lets call the tables table1 and table2. table2 basically stores the comments. table1 can have multiple comments associated with it in table2. I have a formula in my report that sums up a field in table1. Right now if table1 has 2 comments associated with it in table2 it sums that field twice and hence the formula displays wrong result. How should this be handled?

Thanks

 

[lbass]

Use a running total that evaluates on change of the table1 field.

-LB

 

[Madawc]

Group by the account number in table 1. Suppress the details and use the group header or footer as if it were a detail line.

Running totals can be set to evaluate once per group.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[maggi]

Running doesn't seem to work. Let me try and explain a little more. I have a formula in my detail section that I summarize in my group header #2. My report looks something like this

ID-----tasks
1111-----2
2222----10 (5+5) here it counts this record twice as table 2 has 2 comments associated with ID 2222. It should display only 5.

 

[lbass]

Go to the field explorer and insert a running total where you choose {table.amt}, sum, evaluate on change of group {table.ID} (insert a group as Madawc suggested), reset never.

-LB