Hi,
I am trying to pass several cf calculated variables (for EACH record in my table) to cf report builder and I got the same repeated value showing up for that many records on my report (as if I had only one record).Here are what I have tried:
template.cfm
<cfloop>
.......
<cfset c1 = val(#myquery.f1#) + val(#myquery.f2#)>
<cfset c2 = val(#myquery.f3#) + val(#myquery.f4#)>
<cfset c3 =...........................>
.........
</cfloop>
<cfform name="report" action="../index.cfm?template=report" method="post">
<cfinput type="submit" name="Report" value="Download Report">
<cfoutput>
<cfinput TYPE="hidden" VALUE="#c1#" NAME="col1">
<cfinput TYPE="hidden" VALUE="#c2#" NAME="col2">
<cfinput TYPE="hidden" VALUE="#c3#" NAME="col3">
</cfoutput>
</cfform>
report.cfm
<cfreport template="testrpt.cfr" format="pdf" overwrite="yes" >
<cfreportparam name="rpt1" value="#col1#">
<cfreportparam name="rpt2" value="#col2#">
<cfreportparam name="rpt3" value="#col3#">
testrpt.cfr
input parameter:
rpt1
rpt2
rpt2
the report supposed to look like this
c1 c2 c3
22 31 75
54 77 59
46 36 42
......
how do I fix this? thanks