Crystal Reports Sum Column

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Sum Column

Author	Message
Hossam Newbie Joined: 31 Mar 2009 Location: Egypt Online Status: Offline Posts: 23	Topic: Sum Column Posted: 03 Apr 2009 at 5:40am
	Hi all , I have column"Duration" in my report look like the following "1.0 h 20 m" "2.0 h 15 m" i need to display summation of this column in footer of report to be total duration "3.0 h 35 m " Thanks in advance, regards
	IP Logged

Chrissy Newbie Joined: 01 Apr 2009 Online Status: Offline Posts: 9	Posted: 03 Apr 2009 at 2:07pm
	Did you try formatting the string to a real time format? Maybe use TimeValue (, , ) and then try to sum it.
	IP Logged

Hossam Newbie Joined: 31 Mar 2009 Location: Egypt Online Status: Offline Posts: 23	Posted: 03 Apr 2009 at 5:35pm
	Could you please use samples because i haven't used before Thanks, regards Edited by Hossam - 03 Apr 2009 at 5:42pm
	IP Logged

Chrissy Newbie Joined: 01 Apr 2009 Online Status: Offline Posts: 9	Posted: 04 Apr 2009 at 6:56pm
	I don't have any specific examples, it was just an idea for you to try. It seems logical to sum a time that you would need to format it as such. Just do a search on timevalue() and I'm sure you can find some examples.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.020 seconds.