Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
it seems that the controls are client side, ColdFusion Server does not know anything about client side controls, if it support Javascript then it should be able to set the caption on the label,
regards,
Iccsi,