Cross tab Crystal report last 12 month column dynamically

[Asutosha]

Hi,
i want to create a cross tab report in vs 2005+sql server 2000.

My table name is "RepMonthlySales" having Columns
(RepCode,repname,Accntref,AccntName,Qty, Year, MonthName,Sales )

From my UI i will give give todays date it will filter data thismonth+11 month before
Ex : if i select 13/11/2008 then range will (1/12/2007- 13/11/2008)
my cross tab report column(MonthName) should start from Dec 2007, jan 2008........Nov 2008.

can any one help me to solve the problem.

Thanks and regards

Asutosha

[Dököll]

He there Friend!
Fire up below link see if you can find anything there:
http://www.google.com/search?sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8&q=cross+tab+report+in+vs+2005%2 B+sql+server+code+example

Let us know if any worked:-)