crosstab.html

使用java的报表操作的类

<style>
.MyReport_groupTotal{BACKGROUND-COLOR: #d8e4f1; font: bold 12pt 隶书;}
.MyReport_total{BACKGROUND-COLOR: #d8e4f1; font: bold 12pt 隶书;}
.MyReport_head{BACKGROUND-COLOR: #ffdead; font: bold 12pt 隶书;}
.MyReport_data{font: 12pt}
.MyReport_title{font: bold 18pt ;}
.MyReport_cross_head_head{BACKGROUND-COLOR: #a68763; font: 9pt }
</style>

<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=3  class='MyReport_data' width="20%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='center' valign='middle' height='0%'>中国XXX股份有限公司XXX分公司&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=3  class='MyReport_title' width="20%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='center' valign='middle' height='0%'>产品销售统计报表&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=1  class='MyReport_data' width="20%" 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="60%" 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="20%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>&nbsp;</td>
</tr>
<tr >
<td rowspan=1 colspan=1  class='MyReport_data' width="20%" 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="60%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='center' valign='middle' height='0%'>报表日期：2003-11-11至2003-11-16&nbsp;</td>
<td rowspan=1 colspan=1  class='MyReport_data' width="20%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='right' valign='middle' height='0%'>单位：吨  元&nbsp;</td>
</tr>
</table>

<table  style='border-collapse:collapse;'  border='1' bordercolor='#000000' bgcolor='#ffffff' align='center' valign='middle' height='0%' cellPadding='2' cellSpacing='0' width='75%'>
<tr >
<td rowspan=1 colspan=2  class='MyReport_cross_head_head' width="-1%" nowrap="true" style='margin: 0px;padding: 0px;' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;厂家<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;销售额<br>&nbsp;&nbsp;&nbsp;&nbsp;品种<br>市场</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_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_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_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_total' width="-1%" nowrap="true" style='' border='1' bordercolor='#000000' bgcolor='#ffffff' align='left' valign='middle' height='0%'>总计&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%'>产品1&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%'>1,290.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%'>1,150.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%'>1,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%'>1,300.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%'>4,940.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%'>10,580.80&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%'>1,150.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%'>1,200.20&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%'>1,300.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%'>14,231.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%'>1,290.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%'>1,150.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%'>1,200.23&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%'>1,300.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%'>4,940.23&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,160.80&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%'>3,450.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%'>3,600.43&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%'>3,900.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%'>24,111.23&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%'>产品2&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%'>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,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>