Hello: I'm using CR 2008 version 12.0.0.683
I have two running totals, #OT-Hrs-room and #Reg-Hrs-room. This measures labor hours, Overtime and Regular. The running totals work, print and reset the way I want.
I'm trying to add the two together with the formula @Tot-Hrs-Rm. My problem is that this will not print unless I have Overtime in the group. No overtime and @Tot-Hrs-Rm does not print.
Since either OT-hrs or Reg-hrs (my data) is null I've tried coding this with "IF ISNULL" but that doesn't change the results. whileprintingrecords; does not seem to affect it either.
Thanks for any advice.
~Bob
I have two running totals, #OT-Hrs-room and #Reg-Hrs-room. This measures labor hours, Overtime and Regular. The running totals work, print and reset the way I want.
I'm trying to add the two together with the formula @Tot-Hrs-Rm. My problem is that this will not print unless I have Overtime in the group. No overtime and @Tot-Hrs-Rm does not print.
Code:
whileprintingrecords;
IF {#OT-Hrs-room} <> 0 THEN
{#OT-Hrs-room} + {#Reg-Hrs-room}
else
{#Reg-Hrs-room};
Since either OT-hrs or Reg-hrs (my data) is null I've tried coding this with "IF ISNULL" but that doesn't change the results. whileprintingrecords; does not seem to affect it either.
Thanks for any advice.
~Bob