Creating Group Eliminates Records

Forgive the novice nature of this question.

I have a report that I want to create four groups for. Prior to grouping, I've created a Sum for an amount field. I get a Total of $1000.00 (for simplicity sake I'm making up a number).

I create the first grouping and subtotal that group. No problem
I repeat for the second and third grouping. No problem.

However, on the final grouping, it changes my Grand Total to $988.50. I assume this means that records are being eliminated? The final grouping is different than groups 1, 2, and 3 in that it is in a different table. Does this have anything to do with it.

Your help is greatly appreciated.What type of join do you use when joining this table?
Inner or Left Outer?|||I've been taught to just click the smart button on the join screen. So I accepted what Crystal mapped.

It's set to an inner join. I changed it and it worked! Thank you so much.

Is there anyway that you can tell me in layman's terms why I needed to do that? What is the difference between those types of joins?

Also, do the joins get saved with the report, or do I need to set them each time I refresh the report with new data?

Thank you again!|||:) Yes, of course the joins get saved with the report.

I don't think I can give you better explanations then those you have in the 'Help' file.
Read help on 'inner join' and 'left outer join'.

Actually, here is one example of how it works, let's say we have 2 tables.
The 1st one is accounts:

acc_num acc_name state
-----------
acc1 name1 MN
acc2 name2 NJ
acc3 name3 NY
acc4 name4 OH
acc5 name5 AK

and the 2nd one is payments:

acc_num pay_date amount
------------
acc1 6/1/07 $30.00
acc3 7/4/07 $100.00
acc5 7/15/07 $40.00

If you use inner type of join to link them (accounts.acc_num=payments.acc_num), the result will be next:

acc_num acc_name state pay_date amount
--------------------
acc1 name1 MN 6/1/07 $30.00
acc3 name3 NY 7/4/07 $100.00
acc5 name5 AK 7/15/07 $40.00

2 records from the 1st table (acc2, acc4) are not selected because there are no such field values in the 2nd table.

But if you use left outer join, you will get all of the records from the primary (left) table:

acc_num acc_name state pay_date amount
--------------------
acc1 name1 MN 6/1/07 $30.00
acc2 name2 NJ
acc3 name3 NY 7/4/07 $100.00
acc4 name4 OH
acc5 name5 AK 7/15/07 $40.00

...probably, your smart button didn't get what you were trying to do ;)
but to be serious, I wouldn't use it. :)|||Duh, the help file. That was, helpful.

In all seriousness, thank you so much for your help.