report builder

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 374,167 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,334 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ColdFusion advertiser:

Thread Tools Display Modes

Views: 598 | Replies: 0

•

Join Date: Jan 2008

Posts: 2

Reputation: tcv56 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

tcv56

Offline

Newbie Poster

report builder

Jan 9th, 2008

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