Skip to main content
Inspiring
May 17, 2013
Answered

Report Designer using stored procedure

  • May 17, 2013
  • 1 reply
  • 619 views

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

    This topic has been closed for replies.
    Correct answer iccsi

    I just need to create fields on the Report Builder user interface on the field and parameter section,

    Thanks for your information and help,

    regards,

    iccsi

    1 reply

    iccsiAuthorCorrect answer
    Inspiring
    May 20, 2013

    I just need to create fields on the Report Builder user interface on the field and parameter section,

    Thanks for your information and help,

    regards,

    iccsi