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

    Report Designer using stored procedure

    iccsi Level 1

      I use ColdFuiosn and MS SQL server.

      I use a stored porcedure for my report using advance on query builder like following.

       

      <cfquery name="ReportQuery" datasource="myDataSource">

      execute MyStoredProcedure MyParam1, MyParam2

      </cfquery>

       

      I got ColdFusion Report Designer is unable automatically to retrieve  meta data for the report fields.

      Can you please advice how can I manually to get field information to drop on the report designer?

       

      Your help and information is great appreciated,

       

      Regards,

       

      Iccsi