Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lromano1962
Starting Member
13 Posts |
 Posted - 2008-05-12 : 10:41:53
|
| I am trying to create a report that will group by the product sold and then show the current sales, previous year and variance for a date range (which is prompted).example:Current Date : 04/01/08 {?StartDate} 04/30/08 {?EndDate}Previous Yr : 04/01/07 04/30/07 Current Date Prev Year VarianceBooks 10 12 -2Pencils 15 10 5Thanking you in advance, LisaLisa Romano |
|
|
|
|
|
Crystal Reports Previous Year