Dynamic Report heading

[iccsi]

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

[iccsi]

The label is control on the client, if Rebort Builder Support Javascript then it should be able to change caption of label using javascript,

Regards,

Iccsi

[EddieLotter]

Are you talking about tabular columns (fixed columns) or report columns (dynamic flow)?

[iccsi]

I need change the column heading base on user selection,

Regards,

Iccsi,

[EddieLotter]

Okay. See my response to your other thread on this issue.