How can i make calculation ?

Comments

• AlexTZ

  October 2009 edited 4:34PM

  Hello,
  
  Sum your field using FastReport total, then convert the total value from seconds to hh:mm:ss format using a script function.
• mohanaraj 600001

  October 2009 edited 4:34PM

  AlexTZ wrote: »

  Hello,
  
  Sum your field using FastReport total, then convert the total value from seconds to hh:mm:ss format using a script function.

  
  
  Dear Alex,
  
  I sum the field by adding New total to the data window and in the total popup window i select the duration field and save. Then i place this total field in the summary band and right click then i choose format (time to 13:30) and saved.
  
  Then i run the report the result displayed wrong.
  
  This is right way? Please advice about " format using a script function."
• AlexTZ

  October 2009 edited 4:34PM

  Since your sum is a number of seconds, you just can't format it using standard format means (you need DateTime value to do this). That's why you have to convert your value manually (either convert it to DateTime somehow, then format it using standard FastReport means; or use custom function that will extract hours, minutes and seconds from this value and output them in a report).
• AlexTZ

  October 2009 edited 4:34PM

  The elegant solution is to use TimeSpan. Put this in your Text object, and you get hh:mm:ss value.
  
  [TimeSpan.FromSeconds(your_seconds_value)]
• mohanaraj 600001

  October 2009 edited 4:34PM

  AlexTZ wrote: »

  The elegant solution is to use TimeSpan. Put this in your Text object, and you get hh:mm:ss value.
  
  [TimeSpan.FromSeconds(your_seconds_value)]

  
  Dear Alex,
  
  Thanks Its work fine.
• mohanaraj 600001

  October 2009 edited October 2009

  AlexTZ wrote: »

  The elegant solution is to use TimeSpan. Put this in your Text object, and you get hh:mm:ss value.
  
  [TimeSpan.FromSeconds(your_seconds_value)]

  
  Dear Alex,
  
  In the above line of code not working when i gave the second as 141700.
  It display wrongly as 1.15:21:40 instead of 39:21:40 please give suggestion.
  
  
• AlexTZ

  October 2009 edited 4:34PM

  Write this in your report script:
  

    public class ReportScript
    {
      private string SecondsToHHmmss(int seconds)
      {
        int hours = seconds / 3600;
        seconds = seconds - (hours * 3600);
        int minutes = seconds / 60;
        seconds = seconds - (minutes * 60);
        return String.Format("{0:00}:{1:00}:{2:00}", hours, minutes, seconds);
      }
    }
  

  
  and use this function in your Text object:
  [SecondsToHHmmss(141700)]
• mohanaraj 600001

  November 2009 edited 4:34PM

  Dear Alex,
  
  Thank you.