Looping over arrays?

[shastamatt]

Hello,

I have a report which gives monthly totals of peoples production which is categorized and totaled. I also need the categories to have a Year to Date total with a combined year to date total. Doing this with queries is easy, but has a huge effect on load time. I am new to arrays and curious if this would be the correct direction. Each person on the report has a reportOrder which is sequential to the order on the report. If i had year to date totals with the report order (YearToDateUser[1] , YearToDateUser[2], YearToDateUser[3]), is there a way to loop thru to output in the same order? Is this the wrong way to skin this cat? Any ideas would be greatly appreciated.

Thanks,

Matt

[shastamatt · Accepted solution]

Silly me....That was simple.

<cfloop from="1" to="#qryGetOrder.recordcount#" index="i">
<td class="wt"><cfoutput>#ArraySum(yeartodatepersons )#</cfoutput></td>
</cfloop>

Sorry to bother you all.