UN-SUMMARIZE?????? 1

[ajde12]

OK folks,
I have from database data-(time) which are type(int)...
like 95959(9:59:59)...so in CR v8.5 I convert this INT to
the time:
whileprintingrecords;
numbervar THours ;
numbervar TMins ;
numbervar TSecs ;
numbervar Temp := {Definity_History.secDur};

THours := truncate(Temp/10000,0);
TMins := truncate((Remainder ({Definity_History.secDur}, 10000))/100);
TSecs := Remainder({Definity_History.secDur},100);
//If {Proba.sec} >= 60 then
///TMins := TMins +1;

totext(THours,"00&quot + ":" + totext(TMins,"00&quot + ":" + totext(TSecs,"00&quot ;

then I convert this field to seconds(at the end I need SUM),
like...:
local numbervar hours;
local numbervar minutes;
local numbervar seconds;

//convert the hours to seconds by multiplying by 3600
hours := hour(ctime({@to_time})) * 3600;
//convert the minutes to seconds by multiplying by 60
minutes := minute(ctime({@to_time})) * 60;
seconds := second(ctime({@to_time}));

//add up all the seconds
hours + minutes + seconds;

and then when I try to make SUM,or even RUNNING TOTAL doesnt
work...something like "The summary/running total field could not be created"
I will appreciative for any idea,help

 

[Reebo99]

Because you are using the evaluation time whileprintingrecords;

Looking at your formula, I don't see why you need this. Try removing it and let me know what happens.

Reebo
UK

"Before you judge a man, walk a mile in his shoes. After that, who cares? ...He's a mile away and you've got his shoes." - Billy Connolly

 

[ajde12]

Thanx Reebo99,know is perfect...
I didnt notice this
regards
Ivan