Crystal Reports Build Group Increments

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Build Group Increments

Post Reply

Post New Topic

Author	Message
vcs1161 Newbie Joined: 03 Mar 2010 Online Status: Offline Posts: 33	Topic: Build Group Increments Posted: 29 Oct 2014 at 5:08am
	I have the results from a datediff formula in minutes in my report. I would like to group these numbers in increments of 30. So those records where the datediff is 0-30 minutes would be grouped as "0-30", datediff of 31-60 would be "31-60" and so on. Any ideas of how I can build these in Crystal? Thank you for your time.
	IP Logged


vcs1161 Newbie Joined: 03 Mar 2010 Online Status: Offline Posts: 33	Posted: 29 Oct 2014 at 5:30am
	I think I just figured it out: if INT({Command.timediff}/30) + 1 = 1 then "0-"+totext((INT({Command.timediff}/30) + 1)30) else totext (((INT({Command.timediff}/30) + 1)30)-29)+"-"+totext((INT({Command.timediff}/30) + 1)*30) Edited by vcs1161 - 29 Oct 2014 at 5:34am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Oct 2014 at 5:30am
	totext(ceiling(datediffvalue,30)-30,0,'')+'-'+Totext(Ceiling(datediffvalue,30),0,'')
	IP Logged

vcs1161 Newbie Joined: 03 Mar 2010 Online Status: Offline Posts: 33	Posted: 29 Oct 2014 at 5:47am
	Thank you. This works also but it does not begin the next group by one so this seems to work after the first group is created. if {Command.timediff} in [0 to 30] then "0-"+Totext(Ceiling({Command.timediff},30),0,'') else totext(ceiling({Command.timediff},30)-29,0,'')+'-'+Totext(Ceiling({Command.timediff},30),0,'')
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 Oct 2014 at 5:53am
	note I also noticed it breaks if the value is 0 so you may want another IF to start it with
	IP Logged

vcs1161 Newbie Joined: 03 Mar 2010 Online Status: Offline Posts: 33	Posted: 29 Oct 2014 at 7:32am
	Yep, I do see that. Thank you very much.
	IP Logged

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