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



      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,