Input Parameter in advance query builder

Forum|Forum|20 years ago
April 21, 2006
2 replies
487 views

I am new user for Report Builder and I am trying to check if this tool helps me convert all my old reports in report builder.
My question is, can I pass input parameter(s) to my query in advance query builder? I tried that but whenever I try to do that, my cfm file where I am calling cfr file in <cfreport> hangs. If anyone know if this is possible or any other way around, please let me know.

Thanks in advance.

Reporting

This topic is closed to new replies. Start a new post to keep the conversation going.

Correct answer romain_soco

if you want to have :
- a dynamic query, create your query and pass it to "query" parameter.
- a single parameter, use the cfreportparam tag.

<cfreport template="report#intNumMenu#/dsp_report.cfr" query="MyQuery" format="pdf">
<cfreportparam NAME="ImagePath" VALUE="test">
</cfreport>

R

romain_socoCorrect answer

Participant

if you want to have :
- a dynamic query, create your query and pass it to "query" parameter.
- a single parameter, use the cfreportparam tag.

<cfreport template="report#intNumMenu#/dsp_report.cfr" query="MyQuery" format="pdf">
<cfreportparam NAME="ImagePath" VALUE="test">
</cfreport>

S

shilpsk-uK8bmfAuthor

Participating Frequently

Thanks, it is working fine this way.
One more question, do I have to write a query in report builder even if I am writing a dynamic query in cfm page and passing the query as follow?
<cfreport template="report#intNumMenu#/dsp_report.cfr" query="MyQuery" format="pdf">
<cfreportparam NAME="ImagePath" VALUE="test">
</cfreport>

Thanks.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.