Crystal Reports - Average of two fields

  • Thread starter Thread starter amit
  • Start date Start date
A

amit

Hi guys

I am using access database with Crystal Reports in VS2003
I am working on "Hospital Database"
The fields are -
Name - Date - ConsultingCharge - TotalFees
i.e. Total Fees include fees for medicine issued by hospital


In the report I want to display the Average of ConsultingCharge and
TotalFees for every record.
i.e. Name - Date - ConsultingCharge - TotalFees - Aversge (TotalFees/



ConsultingCharge)
How can we display the average of two fields in database for every
record.


Further in the monthly analysis report I want to display
Month - TotalFees - ConsultingCharge - Average ( ConsultingCharge/
TotalFees )
How to generate report for month from the database with all the dates.
How to display the average of sum of ConsultingCharge and TotalFees.


Thanks


Amit
 
In the report I want to display the Average of ConsultingCharge and
TotalFees for every record.
i.e. Name - Date - ConsultingCharge - TotalFees - Aversge (TotalFees/



ConsultingCharge)
How can we display the average of two fields in database for every
record.
Click to expand...

Have you taken a look at formula fields?
 
Back
Top