You have that backwards, the first record is in the group header, the last in the group footer.
Not sure how technicall proficient you are, forgive me if this insults you.
Groups are the same type of entity as a group within a SQL statement.
What occurs is that all similar items exist within each distinct value you selected as the field to group by.
So if your data has:
ID Value
1 100
1 300
1 500
2 500
2 600
3 200
3 100
The group header would show the FIRST row it encounters within the group header, and the last within the group footer.
So the first group if done by ID above would have 100 in the header, and 500 in the footer.
Example:
GH 1 100
Details 100
Details 300
Details 500
GF 1 500
Rather than trying to state architecture, especially since you don't understand what groups are, you should post your environment and requirements. Stating that you are going nuts is fine, but not if that's all the technical information we have to go on. Post:
Crystal version (any software post should include this)
Database/connectivity used
Example data (show what is in the database)
Expected output (show what you want to display)
Statements such as "What can I do so that all the amounts would be in my group header?" are confusing, as we have no idea what you mean by all values, state specifics. You want every value in the report, or sums of the groups, or???
If you want a sum, create a formula containing:
sum({table.fieldtosum}, {table.fieldyougroupedon})
Then place it in the group header or group footer.
-k
