Display sub total Duration in Footer Band
mohanaraj
600001
Dear all,
How to display the Total Duration in the footer band present in the Data band. In this i want to display the sub Total Duration
i want to pass the value to the function
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);
}
Previously i display the duration in this band by creating new total field and select " Print on the band" option and select this footer band i done it in design mode the display in total second i want to display it in HH:MM:SS so i want to pass this total duration to the above function how can i achieve this.
And also the report summary calculation goes wrong.
Thanks in advance.
How to display the Total Duration in the footer band present in the Data band. In this i want to display the sub Total Duration
i want to pass the value to the function
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);
}
Previously i display the duration in this band by creating new total field and select " Print on the band" option and select this footer band i done it in design mode the display in total second i want to display it in HH:MM:SS so i want to pass this total duration to the above function how can i achieve this.
And also the report summary calculation goes wrong.
Thanks in advance.
Comments
Put this text in your Text object (where you want to print the total):
[SecondsToHHmmss([TotalDuration])]
where "TotalDuration" is the name of your total.
Dear Alex,
Thanks.
I display the total Cost when the all the cost is 0.00 means the sum display as 0.
how i make this 0 to 0.00 How i format?
Dear Alex,
Thanks,
But i don't want to display currency symbol "$". I cut down the code (Format.CurrencySymbol="$") in frx file but any way it display.
How i remove the symbol.