Period Calender 544

[brxmas]

SQL Server 2000
Crystal 9.0

I created a report that uses a Period table in the database. Our Period Calendar is 544. Users need to be able to see the Period Calendar to select date criteria. See example below:

Period 9 - September
start_date = 08.29.2005 = Default Calendar 08.28.2005
end_date = 09.25.2005

start_dateLY = 08.30.2004
end_dateLY = 09.26.2004

Is there a way that I can show our Period Calendar not the default calendar.

Thanks in advance.

BC

 

[chelseatech]

There are two ways to do this.

One approach is to use a formula to calculate the period number.

A second approach is to generate a calendar table with a record for each day in last year, this year and next year. Include fields for the period number, public holidays and things like that.

Then you can link the date field in your transaction table to the calendar table.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm