My <cfdump var="#q_RptResult#"> show error

Hi,

          Please make sure your SP is return an 'OUT'

Try moving the CFPROCRESULT tag above the CFPROCPARAM tags. I am not sure if that will solve the issue but everywhere I use these tags the CFPROCRESULT comes first. Give it a shot.

<cfstoredproc procedure="myreport" datasource="#DSN#">

  <cfprocresult name="q_RptResult">

   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@compcode" value="#compcode#">

   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@InventYear" value="#InventYear#">

</cfstoredproc>

Could we see the error message? In any case, don't you require a cfprocparam of type 'out'?