在透视分析报表的第一行参数最后添加“分析”按钮,点击“分析”则刷新报表,在第二行参数后面添加“导出”按钮,点击“导出”,则导出excel,具体实现效果见下图:
选中透视分析,右键选择 编辑宏 进入报表宏界面。
注意:该透视分析要求参数分两列。
类型 | 对象 | 事件 |
---|---|---|
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