EasyCFM.COM Forum / Coding Help! / Subtotal Array Within Output Group

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Subtotal Array Within Output Group

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

jaco5md
03-09-2010 @ 9:22 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 490
Joined: Jul 2005

I am trying to get subtotals for each column in my array (arrRegionDetail[currentrow][6]...) within a specific grouping and cannot figure out how.  All code I use give me different data no matter where I place it within the output statement.

<!--- Display Parent Data (Group 2) --->
            <cfoutput group="uic_id">
            <tr>
              <td height="20" class="MTFHeading">
              <div style="margin-left:8px">#name# (#uic_id#)</div>
              </td>
              <td class="MTFHeadingNum"></td>
              <td class="MTFHeadingNum"></td>
              <td class="MTFHeadingNum"></td>
              <td class="MTFHeadingNum"></td>
              <td class="MTFHeadingNum"></td>
              <td class="MTFHeadingNum"></td>
              <td class="MTFHeadingNum"></td>
            </tr>

<!--- Display Child Data --->
<cfoutput>
            <tr bgcolor="###iif(currentrow MOD 2,DE('ffffff'),DE('FAF8F5'))#">
<td height="20" class="MTFSubHeading">
<div style="margin-left:15px">#child_name# (#uic_child_id#)</div></td>
<td class="MTFSubHeadingNum">#arrRegionDetail[currentrow][6]#</td>
<td class="MTFSubHeadingNum">#arrRegionDetail[currentrow][7]#</td>
<td class="MTFSubHeadingNum">#arrRegionDetail[currentrow][8]#</td>
<td class="MTFSubHeadingNum">#arrRegionDetail[currentrow][9]#</td>
<td class="MTFSubHeadingNum">#arrRegionDetail[currentrow][10]#</td>
<td class="MTFSubHeadingNum">#arrRegionDetail[currentrow][11]#</td>
<cfset GrandDetailTotal = #arrRegionDetail[currentrow][6]# + #arrRegionDetail[currentrow][7]# + #arrRegionDetail[currentrow][8]# +
#arrRegionDetail[currentrow][9]# + #arrRegionDetail[currentrow][10]# + #arrRegionDetail[currentrow][11]#>

<td class="MTFSubHeadingNumTotal">
<div style="margin-right:20px; text-align:right">
#NumberFormat(GrandDetailTotal, "," )#
</div>
</td>
</tr>
</cfoutput>
</cfoutput>


-David

"Rock 'n' Roll 4 Ever"

nmiller
03-09-2010 @ 10:19 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 756
Joined: Apr 2003

You don't want to use an array at all, you want to use
output grouping:

http://tutorial150.easycfm.com/

reformat your code to use this technique.

Nathan Miller
NM Consulting




Copyright © 2002 - 2009. EasyCFM.COM, LLC.
Powered by < CF FORUM > v.2.0
 
Download the EasyCFM.COM Browser Toolbar!