Lots of calculated fields?

[john]

I^m looking at having to create a summary report. This report will have 360 totals and calculated fields. The bulk of these fields will be totals fields, each with a unique condition. The condition will always have the same "shape", but the constants used will change from field to field. Here is a sample of the condition:____RIGHT( RTRIM(ZONE), 1 ) = "3" and PAY_FLAG = "1" and INTCODE <>"U20" and RES_FLAG <> "Y"____At two minutes per field, we are looking at about 12 hours of work to create this report in RRW. Is there a better/faster way to create summary reports which have hundreds of fields?

[Randall_Warden_(Guest)]

Could you set up groups for ZONE, PAY_FLAG, INTCODE, RES_FLAG, etc. and create a subtotal at the lowest group level that prints on the group footer band with the values of ZONE, PAY_FLAG, INTCODE, RES_FLAG, etc. being printed in the corresponding group header?____Randall____

[kfleming]

In Version 11 you can copy totals and can use find/replace for total condition expressions if that helps at all.____Kathleen__R&R Support