Cyrstal Report

[nittu]

Hi,

Nittu here...i am at enty level of crystal reports...i am into support team.

i am facing a problem in most of the reports related to grp by.

viz : i have a table called ward charges...

wardid wardname charges
1 ac room 1950
2 room #1 1400
3 room #2 1400

i need to calculate charges for patient admitted in room#1...
in report since they have groped by wardid...always
1950 is fetched for calculating the ward charges
i want 1400 instead

ward charges = charges * no. of days

same probm i facing in many other places due to grp by..

plz help me hw to sort it out.

from,
nittu

[gjack72]

If you are grouping by wardid, then create a formula and place that formula in your group header.

Formula:

 ({Charges * no.ofdays}) \\ Place this in wardid group header

This will give the calculation for each wardid.

Hope that is what you are after.
GJ