function paramToString(v) {
return v == null ? null : v.toString();
};
function main(spreadsheetReport, param) {
// 避免宏代码循环调用
if (!spreadsheetReport._init) {
return;
}
if (param.name == "跳转至报表") { //判断参数名称是否为"跳转至报表"
var destQuery = null;
var command = spreadsheetReport.command;
command.close();
if (param.value == 1) { //如果参数B的值为2,则打开电子表格2
destQuery = 'I8a8af0a6017297949794e7480172986ed7b10d71'; //电子表格2的ID
}
if (param.value == 2) { //如果参数B的值为2,则打开电子表格2
destQuery = 'I8a8af0a6017297949794e7480172987376070df0'; //电子表格2的ID
}
command.execute('OPENWITHNOREFRESH', destQuery);
//spreadsheetReport.autoRefresh = false;
var report = command.spreadsheetReport;
if (spreadsheetReport.params.length > 0) {
report.setParamsInfo(spreadsheetReport.buildParamsInfo()); // 传递所有参数值
}
if (spreadsheetReport.autoRefresh == 1) { // 增加电子表格切换参数自动刷新判断
report.doRefresh();
}
}
};