crosstab.html

这是一个报表开发包,支持中国样式的报表,支持分组和交叉报表

<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>12,500.00&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=1  class='MyReport_head' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>北京&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,000.07&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,100.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,100.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,200.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>12,400.07&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=1  class='MyReport_head' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>成都&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,200.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,100.89&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,100.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>3,200.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>12,600.89&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=2  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>小计&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>9,300.07&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>9,300.89&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>9,300.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>9,600.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>37,500.96&nbsp;</td>
</tr>
<tr >
<td rowspan=3 colspan=1  class='MyReport_head' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>产品3&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_head' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>上海&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,100.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,400.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,000.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,102.01&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>16,602.01&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=1  class='MyReport_head' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>北京&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,890.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,400.03&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,000.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,100.05&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>17,390.08&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=1  class='MyReport_head' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>成都&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,200.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,500.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,000.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>4,100.45&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>16,800.45&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=2  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>小计&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>13,190.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>13,300.03&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>12,000.00&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_groupTotal' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>12,302.51&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>50,792.54&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=2  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>总计&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>35,650.87&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>26,050.92&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>24,900.43&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>25,802.51&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>112,404.73&nbsp;</td>
</tr>
</table>

<table  style='border-collapse:collapse;'  border='0' bordercolor='#000000' bgcolor='#ffffff' align='center' valign='middle' height='0%' cellPadding='2' cellSpacing='0' width='75%'>
<tr >
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>制表人:xxx&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='center' valign='middle' height='0%'>审核人:xxx&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='right' valign='middle' height='0%'>制表日期:xxx&nbsp;</td>
</tr>
</table>