Display data for previous 8 weeks from sel month in sqlsrv

building semantic layer
1

Hi,

       Can any one help me with this issue. I need to build a report which displays data for the selected month by month id and aslo display data for previous 8 weeks from the selected month. I am having a prompt on month. I need the synatx for doing this in sqlserver. The report should look something like this. I can not use a cross tab for this.

Region March 2009 Week 2 week 3… week 10

NorthEasst 1200 1400 1600
East 1400 1200 1500

Any help would be greatly appreciated. :cry:

good4ru (BOB member since 2005-08-03)