Its not just one additional column. The report data comes from the stored procedure which accepts a date as an input parameter and the result will have 12 columns with last 12 months of data.

So it could be any date. Say if we enter 9/23/2013 the result set will have column headers

Sep2012,Oct2012,Nov2012,Dec2012,Jan2013,Feb2013,Mar2013,Apr2013,May2013,Jun2013,Jul2013,Aug2013.

if we enter 01/01/2013 the result column headers will be

Jan2012,Feb2012,Mar2012,Apr2012,May2012,Jun2012,Jul2012,Aug2012,Sep2012,Oct2012,Nov2012,Dec2012.

Based on this requirement how can I keep the column headers dynamic in the result set. This report can run for the dates starting from 01/01/2004 to any future date since this report is going to run in the future as well.

Thanks.