So change your column headers. The query will order the columns in
alphabetical order (Applicant, Neither, Recipient) which is how it's being
output. Your only real option here is to try this as your inner loop:
<cfoutput group="CompIncomp">
<cfset variables.intTreatTotal = QRYTreatment.countTotal +
QRYTreatment.countTotal[currentRow+1] +
QRYTreatment.countTotal[currentRow+2]>
<tr>
<td> #QRYTreatment.CompIncomp#</td>
<td>#QRYTreatment.countTotal#</td>
<td>#QRYTreatment.countTotal[currentRow+2]#</td>
<td>#QRYTreatment.CountTotal[currentRow+1]#</td>
</tr>
</cfoutput>
Bryan Love ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 8:10 AM
To: CF-Talk
Subject: ahh....help with rpt grouping troubles
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
