1. 二维报表

界面模板：

 <table id="tbcrossid1" source="t2" dfield="count" vfields="xb" hfields="zk" cross="2" style="width:80%;margin-top:30px;" align="center" border="1">
        <tbody>
            <tr class="firstRow">
                <td flag="first" bgcolor="blue" style=";background-color:#DB5A6B" align="center" editable="1" class="f33">
                    交叉报表测试
                </td>
                <td flag="dimensionA" class="f30" readonly="readonly" editable="1" type="string" style=";color:#E08A1E">
                    <span style="">横向字段</span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                </td>
                <td flag="rsh" class="f22" readonly="readonly" editable="1" style=";color:#F62459" type="string">
                    平均值
                </td>
            </tr>
            <tr align="center">
                <td flag="dimensionB" class="f30" readonly="readonly" editable="1" style=";color:#36D7B7" type="string">
                    纵向字段
                </td>
                <td flag="basedata" bgcolor="#C0C0C0" class="f30" readonly="readonly" editable="1" style=";color:#19B5FE" type="string">
                    数据
                </td>
                <td flag="rs" fmt="#.##" bgcolor="#00AF00" class="f22" readonly="readonly" editable="1" style="background-color: rgb(77, 175, 124); text-align: right;" type="string">
                    avg
                </td>
            </tr>
            <tr align="center">
                <td flag="csh" class="f30" readonly="readonly" editable="1" style=";color:#F58F84" type="string">
                    合计
                </td>
                <td flag="cs" bgcolor="#00CF00" class="f22" style=";background-color:#ECF0F1" align="center" readonly="readonly" editable="1" type="string">
                    sum
                </td>
                <td flag="table" bgcolor="ff00ff" readonly="readonly" editable="1" style="background-color: rgb(25, 181, 254); text-align: right;" type="string">
                    sum
                </td>
            </tr>
        </tbody>
    </table>

数据模板：

select top 100 
    case when ord_xb='' or ord_xb is null then '未知' else ord_xb end as xb,
    case when ord_hyzk is null or ord_hyzk='' then '保密' else ord_hyzk end as zk,
    1 as count 
from order_40

运行结果：