Hello,
I am having trouble fixing this report and I am quite
new to CF....getting a bit frustrated...
my report should look something like this:
(the problem is that the numbers for Recipient are in
the Neither column and the numbers for the Neither are
in the Recipient column. Applicant is fine. I know
this should be simple to fix but I cant seem to get
it....any ideas as to why????)
Applicant Recipient Neither
Treatments Types
New Treatment
Incomplete 1 3 0
Complete 0 1 1
Old Treatment
Incomplete 5 1 1
Complete 1 2 2
the CF code is:
<cfoutput query="QRYTreatment"
group="TreatmentTypes">
<tr>
<td>#QRYTreatment.TreatmentTypes#</td>
</tr>
<cfoutput group="CompIncomp">
<tr>
<td> #QRYTreatment.CompIncomp#</td>
<cfset variables.intTreatTotal = 0>
<cfoutput>
<cfset variables.intTreatTotal =
variables.intTreatTotal +
QRYTreatment.CountTotal>
<td>#QRYTreatment.CountTotal#</td>
</cfoutput>
</td>
</tr>
</cfoutput>
</tr>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
