Hello-
In short, I would like to display comparison data on a report side by side, for this example this year goals compared to last years goals by goal code A-Z (which is a credit code, goals are for the # of credits by code for the year). The end result I would like is to look like this:
code 2009 goal 2008 goal
A 25 20
B 50 60
C 10 15
However the data looks like this (displaying all of the 2009 data first then the 2008 data, not side by side):
code 2009 goal 2008 goal
A 25
B 50
C 10
.
etc to Z
A 20
B 60
C 15
We are currently exporting data out of our legacy system to an excel format and then importing into a mysql database. We are mainly doing this to summarize data by month, quarter, years and then report on that data. So basically the table is custom which I can set up which ever way would be best but I don't have that experience.
Right now the data is structured like:
Code Goal Date (this is currently a string in the db)
A 25 YTD 2009
B 50 YTD 2009
etc. A-Z for 2009 then:
A 20 YTD 2008
B 60 YTD 2008
If there is an easy way on the crystal report side to achieve this or if anyone has any experience on the DB side and has a solution on how to set this up in the table to make things easier on the crystal report side. Right now we are just looking for a year to year comparison however we will eventually be doing month to month (Feb this year vs Feb last year) comparison's as well as Jan-Dec 2009 comparisons.
Any ideas or thoughts would be appreciated. Thanks!