Hello everyone,
I am new to Crystal Reports, and have been tasked with creating an YTD comparison report. I have read the other threads, however my report is a bit different, and has been causing me trouble.
The tables that I am concerned with are the salesmen table, and the contributions table. In the salesmen table are listed all the salesmen, and the dates that they started. In the contributions table are listed all of the contributions that the salesmen have made, and the dates that the contributions were made.
I need to create a report that compares new salesmen from previous years to the current year. For example let's say that salesmen#1 started on Jan 1987 and Sales#2 started on Jan 2004. Then the report would compute all the contributions that the two salesmen have made their first month.
The report would look like this
1987 2004 Differance Percent Change
January
Contribution: $79546 $83544 $3998 4.79%
Febuary
Contribution:
March
Contribution:
April
Contribution:
May
Contribution:
June
Contribution:
July
Contribution:
etc..
How would I go about doing this?
I am new to Crystal Reports, and have been tasked with creating an YTD comparison report. I have read the other threads, however my report is a bit different, and has been causing me trouble.
The tables that I am concerned with are the salesmen table, and the contributions table. In the salesmen table are listed all the salesmen, and the dates that they started. In the contributions table are listed all of the contributions that the salesmen have made, and the dates that the contributions were made.
I need to create a report that compares new salesmen from previous years to the current year. For example let's say that salesmen#1 started on Jan 1987 and Sales#2 started on Jan 2004. Then the report would compute all the contributions that the two salesmen have made their first month.
The report would look like this
1987 2004 Differance Percent Change
January
Contribution: $79546 $83544 $3998 4.79%
Febuary
Contribution:
March
Contribution:
April
Contribution:
May
Contribution:
June
Contribution:
July
Contribution:
etc..
How would I go about doing this?