report builder
 

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