Group Footer and Group Header

[AlreadyLost]

I still don't get this group footer and group header. It's driving me nuts with my report.

I have a report that I want to display the list of amount on my group header and is only displaying my last record.. When I display it on my group footer, it is displaying my first record.. What can I do so that all the amounts would be in my group header?

 

[synapsevampire]

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

 

[AlreadyLost]

Okay.. here is my layout: Crystal 10, SQL

GH 1 (group by Representative Name, contain Representative name)
GH 2 (group by Record Number, contain record number, invoice number, @description)
GH 3 (group by Activity Date ,contain activity date,description, amount )

My problem result:
Name: Joe

Record # Invoice Number Description Amount
P12 In543 Payment Credit (blank)

Activity Date
1/2/2003 Removal Tank 310.00
1/3/2003 Permit Fee 310.00
1/10/2003 Modify Fee 310.00

Total Due: 305.00



Result I want:

Name: Joe

Record # Invoice Number Description Amount
P12 In543 Payment Credit -230.00

Activity Date
1/2/2003 Removal Tank 310.00
1/3/2003 Permit Fee 125.00
1/10/2003 Modify Fee 100.00

Total Due: 305.00


Does this help of what I want my result to look like? The "Amount" field is straight from the table.