Long time listner, first time caller. I'm using Crystal Reports 2010.
I have daily trade information that I need to group together if the volume doesn't change. Here's what the data looks like.
Trade# BegDate EndDate Volume
1 1/1/2012 1/2/2012 500
1 1/2/2012 1/3/2012 500
1 1/3/2012 1/4/2012 1000
1 1/4/2012 1/5/2012 750
1 1/5/2012 1/6/2012 750
1 1/6/2012 1/7/2012 500
1 1/7/2012 1/8/2012 500
1 1/8/2012 1/9/2012 500
I need it to look like this.
Trade# DateRange Volume
1 1/1/2012 - 1/3/2012 500
1 1/3/2012 - 1/4/2012 1000
1 1/4/2012 - 1/6/2012 750
1 1/6/2012 - 1/9/2012 500
I need to group by the derived date ranges but I'm not sure how to accomplish this with Crystal. Any ideas??
See Question&Answers more detail:os