CROSS TAB REPORT FOR TOTAL LABOR HRS

[AlanApplications]

{labtrans.regularhrs}*{labtrans.payrate} + if {labtrans.otscale}=1.38 then (({labtrans.payrate}*1.38)*{@ot}) + if {labtrans.otscale}=1.78 then ({@dtbillrate}*{@DT})
Well, this report I'm reworking....I mean given to do, doesn't make sense to me. It displays regularhrs, overtime but no dbltime and the total adds everything except the dbltime??? any help would be great....

 

[Madawc]

I'm surprised the statement works, if indeed it does work. I'd do it as a set of formula fields. The conditional parts could be

If {labtrans.otscale}=1.38 
then 
({labtrans.payrate}*1.38)*{@ot}) ) 
else 0

If {labtrans.otscale}=1.38 
and  {labtrans.otscale}=1.78 
then 
{@dtbillrate}*{@DT}
else 0

The final command could then be

{labtrans.regularhrs}*{labtrans.payrate} + @SumOne + @SumTwo

I assume you have these figures in a crosstab. I'd suggest you first put them into detail lines. Adjust the crosstab when it's working

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Please don't use block capitals, it counts as SHOUTING.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10