Dynamic Report heading

I have a stored procedure from MS SQL backend and the result heading is WeekResult1, WeekResult2, WeekResult3... etc until Week20Result for report datasource.

I would like to assign the heading at run time to May/01/2013, May/08/2013, May/15/2013 ... etc base on user enter date range.

I have folloing code on report before export event

<cfstoredProc
datatsource = "MySource"
procedure = "MyColumnHeading"

<cfprocparam
    cfsqltype="cf_sql_date"
    value="#StartDate#">

<cfprocparam
    cfsqltype="cf_sql_date"
    value="#EndDate#">

<cfprocparam
    cfsqltype="cf_sql_date"
    value="#StartDate#">

<cfprocparam
    cfsqltype="cf_sql_numeric"
    value="#DateDiff#">

<cfprocparam
    cfsqltype="cf_sql_numeric"
    value="#DateDiffType#">

>

I would like to know how can  I assign my 20 columns heading record by record from stored procedure result.

Your help and information is great appreciated,

Regards,

Iccsi