Report Designer using stored procedure

[iccsi]

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

[iccsi · Accepted solution]

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