Print Page | Close Window

CRB2008 - Data Grouping Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4180 Printed Date: 05 May 2024 at 12:55am Topic: CRB2008 - Data Grouping Posted By: gtruter Subject: CRB2008 - Data Grouping Date Posted: 07 Sep 2008 at 12:47pm I have created a report that includes a chart which displays the attendance data for a meeting. The data is broken up into the weeks of a month. I then compare the attendance of the previous years data to the current year. My problem is that currently the chart shows the data as it is in the database, first the weeks for the previous year and then the current year. What I would like to see is the 2 weeks of both years together and so on eg: 01/01/2007 200 08/01/2007 100 15/01/2007 250 22/01/2007 300 01/01/2008 100 08/01/2008 230 15/01/2008 280 22/01/2008 500 The above data is charted on a line graph in 1 colour. What I want to see is the following: 01/01/2007 200 01/01/2008 100 08/01/2007 100 08/01/2008 230 15/01/2007 250 15/01/2008 280 22/01/2007 300 22/01/2008 500 I would also like to see each year in a separate colour. Any help would be appreciated. ------------- Thanks, Garth.

Print Page | Close Window