crosstab using formulas in a sub report

[CCH50]

I am trying to create a crosstab, using totaled workorder hours, then using a manual running total to get monthly hours for each piece of equipment.I am using 2 string arrays to get the data to the subreport.
This one collects the equipment;

whileprintingRecords;
stringvar strEquipmentName;
strEquipmentName:= strEquipmentName +{WFR_SYSTEMS.SYSTEM_DESCR} + "^";

This collects the monthly hours for each equipment:

whileprintingrecords;
stringvar Sum_mthHrs;
Sum_mthHrs := Sum_mthHrs + totext({@JanHrs_Display}) + "^"+totext({@FebHrs_Display})+ "^" +totext({@MarHrs_Display})+ "^" + totext({@AprHrs_Display})+ "^"+ totext({@MayHrs_Display})+ "^"+ totext({@JunHrs_Display})+ "^"+totext({@JulHrs_Display})+ "^" +totext({@AugHrs_Display})+ "^"+totext({@SepHrs_Display})+ "^"+totext({@OctHrs_Display})+ "^"+totext({@NovHrs_Display})+ "^"+totext({@DecHrs_Display})+ "^";

I can't get this to work in a crosstab, can anyone help please.

 

[Madawc]

You're trying to create a crosstab on a summary field. It only works on details.

It should work on formula fields at detail-line level, though this depends on the version. LIkewise it may let you group by month on the crosstab, failing which you can set up a formula field to show Year/Month

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP