Skip to Content
0
Feb 18, 2009 at 03:19 PM

Displaying data showing year to year comparison side by side on report

470 Views

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!