Connecting Tech Pros Worldwide Forums | Help | Site Map

Crystal Reports 2008 - Comparing Date Parameters

Newbie
 
Join Date: Jul 2009
Posts: 4
#1: Jul 27 '09
Hello,

I wish to have the user enter a date range (i.e. 01/01/2009 ---> 12/31/2009) to retrieve data to populate part of my report, and then populate another column with the same date range, but from, say, a year earlier. This will help determine sales from year to year.

Example:

Expand|Select|Wrap|Line Numbers
  1. Order #  Account #    Product ID    # Sold '07    # Sold '08  Profit '07   Profit '08
  2. 01            12842         129               200            193           912.00      850.00
Where "08" is the date entered by user, and "07" is the same range, but from previous year.


Thanks in advance!

tlhintoq's Avatar
Moderator
 
Join Date: Mar 2008
Location: Arizona, USA
Posts: 1,772
#2: Jul 27 '09

re: Crystal Reports 2008 - Comparing Date Parameters


Please show the code you have written for this so far, and explain what errors you are getting.
Newbie
 
Join Date: Jul 2009
Posts: 4
#3: Jul 27 '09

re: Crystal Reports 2008 - Comparing Date Parameters


I haven't started the actual coding yet, I am just having difficulties tieing two parameters values to seperate cloumns in my report.

Once I figure this out, the coding shouldn't be tough. I am just new to Crystal Reports and figured since I will be developing in C#, I would start my post here.


Thanks!
Newbie
 
Join Date: Jul 2009
Posts: 4
#4: Jul 27 '09

re: Crystal Reports 2008 - Comparing Date Parameters


I simply want one column to be the values of the date parameter entered by the user, and another column to display the values from said date but from the prior year.
Reply

Tags
compare, cr9, crystal reports, date ranger