1 Reply Latest reply on May 20, 2013 10:13 AM by iccsi

    Dynamic Report heading

    iccsi Level 1

      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

        • 1. Re: Dynamic Report heading
          iccsi Level 1

          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,