 					<th>Category</th>
 					<th>Product</th>
 					<th>Size</th>
+					<th>Price</th>
 					<cfloop from="#startHour#" to="#endHour#" index="i">
 						<th width="20" align="center">#i#</th>
 					</cfloop>
 					<th>Total</th>
 					<th>Avg/<br />Week</th>
+					<th>Value</th>
 				</tr>
 				
 				<cfloop array="#productArray#" index="prodrec">

						<td>#theProduct.catTitle#</td>
						<td><a href="http://tweb.sle-admin.co.uk/productStock6.cfm?product=#prodrec#" target="_blank">#theProduct.prodTitle#</a></td>
						<td>#theProduct.siUnitSize#</td>
						<cfset lineTotal = 0>
						<cfloop from="#startHour#" to="#endHour#" index="i">
							<cfif StructKeyExists(theProduct,i)>
								<cfset theValue = StructFind(theProduct,i)>
								<cfset lineTotal += theValue>
									<cfif StructKeyExists(totals,i)>
										<cfset oldValue = StructFind(totals,i)>
										<cfset StructUpdate(totals,i,oldValue + theValue)>
									<cfelse>
										<cfset StructInsert(totals,i,theValue)>
									</cfif>
								<td align="center">#theValue#</td>
							<cfelse>
								<td></td>

						AND siStatus NOT IN ("returned","inactive") )
		WHERE DATE(ehTimeStamp) >= '#parm.reportDateFrom#'
		AND DATE(ehTimeStamp) <= '#parm.reportDateTo#'
		AND eiClass LIKE 'sale'
		<cfif len(reportMode)>AND ehMode LIKE '#reportMode#'</cfif>
        GROUP BY groupTitle, catTitle, prodTitle, siUnitSize, hh
	</cfquery>
<cfelse>
	<p>Please select start date.</p>
</cfif>

<body>
	<div>
		<cfoutput>
