帆软决策报表tab 多sheet导出

发布时间 2023-05-30 16:02:46作者: 打工人998
  1. 新建cpt普通报表,将多tab语句放入

    在决策报表自定义导出按钮,定义导出事件
    `
    var url="${servletURL}?viewlet=xx/进销存日报导出.cpt"
    var region = this.options.form.getWidgetByName("regioncode").getValue();
    var city = this.options.form.getWidgetByName("citycode").getValue();
    var start = this.options.form.getWidgetByName("startdate").getValue();
    var end = this.options.form.getWidgetByName("enddate").getValue();
    var orgid = this.options.form.getWidgetByName("orgid").getValue();
    var productgroup = this.options.form.getWidgetByName("productgroupid").getValue();

var config = {
format:"excel",
extype:"simple",
regioncode : region,
citycode : city,
startdate : start,
enddate : end,
orgid : orgid,
productgroupid : productgroup
}
FR.doHyperlinkByPost(url,config,"_self")`