Create report advice help

[AlreadyLost]

I need help with creating a report to show the list of Request number per Owner with the list of payment that needs to be charge. I have the report created by could not figure out how to get the amount to display correctly...

Owner name
Request number
Date completed
Description of work
amount

I have group by Owner, group by Request number,group by date
and my amount is place in one of the group by Date section.

Problem is that my amount is only showing me the first amount in the database. That is probably because I place the amount in the group header of Date. Everything else seems to show up in the report except for the amount. How can I make the amount to display all the amount in the report?

Here is what I want my finally output to look like.

Owner
Request number
Date Completed Description of work amount
Date Completed Description of work amount
Date completed Description of work amount

Request number (if there is more than one request per owner)
Date Completed Description of work amount
Date completed Description of work amount
Date Completed Description of work amount
Total Amount ???

Any input will help..Thanks in advance

I am using Crystal 10.

 

[MrBillSC]

I think your "Date completed", "Description of Work", and "Amount" fields should be in the detail section of the report. The total amount should sum the amount field in the appropriate group footer.

MrBill

 

[AlreadyLost]

The problem with moving those field in the detail section is the the "Date Completed" and Description of Work is repeated mulitple time when I move these field to the detail section. Unless I am doing some grouping that is wrong that will cause my detail section to go crazy.

 

[MrBillSC]

In your detail section place the amount field. Suppress the detail section. In your DateCompleted group footer place your data fields except the Amount field. Right click on the amount field in the detail section and select: Insert/Summary. Then in the first box select the "Amount" field. In the second box select "Sum". In the third box select "Group #3 Date". Click OK and Crystal will create a Sum of your Amount field and place it in the group 3 footer.

Repeat the process for your Group 1 footer to get your Customer total amount.

MrBill