Skip to main content
Inspiring
December 18, 2008
Answered

CFREPORTPARAM Not Overriding Subreport query

  • December 18, 2008
  • 1 reply
  • 976 views
I'm trying to use CFREPORTPARAM to override the query of a subreport but it is not working. It still uses the query that is defined in Report Builder for the subreport when the report is run.

<CFREPORT TEMPLATE="Reports/rpt_AllProfileFieldsReportPerform.cfr"
QUERY="qryReport1"
FORMAT="PDF">
<CFREPORTPARAM name="ReportTitle" value=#varReportTitle#>
<cfreportparam name="BureauTitle" value=#bureauTitle#>
<cfreportparam name="Suffix_ID" value="#suffix#">
<cfreportparam query="ReportQuery" subreport="rpt_AuditorAssignment">
</CFREPORT>
This topic has been closed for replies.
Correct answer darbus23
The subreport element in the main report has a name associated with it. It's under Data in the Properties panel. The value in the subreport portion of the cfreportparam tag must match the value in the Properties panel.

1 reply

darbus23AuthorCorrect answer
Inspiring
December 23, 2008
The subreport element in the main report has a name associated with it. It's under Data in the Properties panel. The value in the subreport portion of the cfreportparam tag must match the value in the Properties panel.