How to pass parameter from ColdFusion page to ColdFusion Report

[jvy2002help]

Having problem trying to pass parameter from Cold Fusion Page to Cold Fusion Report Builder. Please help.

Following is the code in Cold Fusion page named “CRDF_report.cfm”

<cfreport template="CRDF_Test.cfr" format="PDF">
<cfreportparam name="Judicial_ID" value="LB">
<cfreportparam name="FISCAL_YEAR" value="#variables.fiscal_year#">
<cfreportparam name="RECORD_MONTH" value="#variables.record_Month#">
</cfreport>

Following is the select statement of the SQL Query Builder
in CRDF_Test.cfr

Select Judicial_ID, Fiscal_Year from court_data

The result show fine when I only have the select statement.

But, my goal is to pass the parameter from the ColdFusion page to Cold Fusion report Builder. Therefore, I added a condition to the above query.

select Judicial_ID, Fiscal_Year from court_data
where Judicial_ID = '#Judicial_ID#'

When I either ran “CRDF_report.cfm” or “CRDF_Test.cfr” on the browser, I got the error message that “Judicial_ID” is undefined.

I then tried to add the parameter just to be sure.

After I added the parameter on the right under “Input Parameters”, I moved the “param.Judicial_ID” to the Detail band. I saved the program and ran again. I still got the same error message.

I tried many times and many ways to pass parameters but it just not working. I am really stuck, anyone can tell me what is wrong and show me how to do it correctly would be greatly appreciated.

Thanks,