示例说明

在透视分析报表的第一行参数最后添加“分析”按钮,点击“分析”则刷新报表,在第二行参数后面添加“导出”按钮,点击“导出”,则导出excel,具体实现效果见下图:

 
设置方法

  1. 在展现定制中,创建一张透视分析;
    住:该透视分析要求参数分两列。

  2. 切换到 定制 -> 宏管理 页面,双击此透视分析进入报表宏界面。
  3. 在报表宏界面新建客户端模块,在弹出的新建模块对话框中选择对象为INSIGHT;事件为onRender;并把下面宏代码复制到代码区域。

 

宏类型

类型

对象

事件

ClientSide

INSIGHT

onRender

宏代码

function main(insight) {
    //debugger;
    insight.zwwl_rebuildParamPanel = insight.rebuildParamPanel;
    insight.rebuildParamPanel = function() {
        this.zwwl_rebuildParamPanel();
        addBtns(this);
    }
    addBtns(insight);
}
function addBtns(insight) {
    var paramTable = insight.paramPanelObj.layoutTable;
    var i, cell, lastCell1, lastCell2;
    for (i = 0; i < paramTable.rows.length; i++) {
        cell = paramTable.rows[i].insertCell( - 1);
        if (i == 0) lastCell1 = cell; //paramTable.rows.length - 1
        if (i == 1) lastCell2 = cell;
    }
    //新建button,并把这个button加到最后一个参数后面
    var btnElem = document.createElement("input");
    btnElem.type = "button";
    btnElem.value = "分析";
    btnElem.className = "queryview-toolbar-button";
    /*btnElem.style.background = "url(./img/button/button_bgicon_add.gif) no-repeat top right";*/
    btnElem.style.border = "1px solid #A1ACB9";
    btnElem.style.width = "80px";
    btnElem.style.padding = "2px 0 0 0";
    btnElem.style.margin = "0 10px 0 10px";
    btnElem.onclick = doClick;
    //debugger;
    var btnExport = document.createElement("input");
    btnExport.type = "button";
    btnExport.value = "导出";
    btnExport.className = "queryview-toolbar-button";
    /*btnExport.style.background = "url(./img/button/button_bgicon_add.gif) no-repeat top right";*/
    btnExport.style.border = "1px solid #A1ACB9";
    btnExport.style.width = "80px";
    btnExport.style.padding = "2px 0 0 0";
    btnExport.style.margin = "0 10px 0 10px";
    btnExport.onclick = doExport;
    if (lastCell1) {
        lastCell1.appendChild(btnElem);
    }
    if (lastCell2) {
        lastCell2.appendChild(btnExport);
    }
    //定义button的Click事件
    function doClick() {
        insight.doRefresh();
    }
    function doExport() {
        insight.doExportMenuCloseUp("EXCEL");
    }
}

资源:migrate.xml