same day this year as last

[darwin101]

hi all

I need to do a sales summary report that displays a figure for today Tuesday the 3rd and if possiable the Tuesday from last year that is as close to the 3rd as possiable.

The ultimate results would be a calendar like display that has sales for 2007 and 2006 by day (Monday, Tuesday ect)

any pointer would be appreciated.

 

[paulkeys]

The corresponding day of the previous year would be 52 weeks * 7 days ago - 364 days.

I'm not sure how you're approaching the data set development - but if it's done in sql server, you could use a dateadd function or similar.

 

[darwin101]

thanks Paul
I am using SQL Server. You got me thinking in the right direction. I think I might look at the Calendar control from Dundas, not sure how else to do this in SRS

select datename(weekday,dateadd(dd,-364,convert(char(10),getdate(),121)))
, dateadd(dd,-364,convert(char(10),getdate(),121))

 

[paulkeys]

Do you need to display the values on the calendar itself, or allow the user to select the required date from a calendar?

 

[darwin101]

they want to look at say.. a calendar view of this month and have the current month/year sales on the correct date and the sales from last year to display also, but they have to match up by Monday, Tuesday... ect.
I know... clear as mud.

 

[paulkeys]

Sounds like the kind of spec i get! Never had to use calendar controls i'm afraid - so can't advise, but would presume you'd need a custom control - and Dundas would be the best place to start -

http://www.dundas.com/Products/Calendar/RS/Features/index.aspx