Cognos报表开发技巧整理

PAGEPAGE10 /31LIST6、类型分组如下图：添加、类型页眉、类型的单元格将、和类型的汇总拖到名称处产品系列，产品类型打开列表的锁reportpageHTML2更详细的含义可参考的在交叉表中实现目录树功能的注释。<script><script>functionExpandCollapse(el)functionExpandCollapse(el){vartbl=tr.parentElement.parentElement;vartr=vartbl=tr.parentElement.parentElement;vartr=el.parentElement.parentElement;varsDisplay=(el.src.indexOf("minus")==-1)?"":varsDisplay=(el.src.indexOf("minus")==-1)?"":"none";varsDisplayReverse=(el.src.indexOf("minus")==-1)?"none":"";varsDisplayReverse=(el.src.indexOf("minus")==-1)?"none":"";el.src="../pat/images/PropertyGroup_"+(el.src.indexOf("minus")==-1?"minus":el.src="../pat/images/PropertyGroup_"+(el.src.indexOf("minus")==-1?"minus":"plus")+".gif";"plus")+".gif";for(vari=tr.rowIndex+1;i<tbl.rows.length;i++)for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{vartrCurrent=tbl.rows(i);vartrCurrent=tbl.rows(i);ifif(0).firstChild&&trCurrent.cells(0).getElementsByTagName("IMG").lengthtrCurrent.cells(0).getElementsByTagName("IMG").length){{ifif(tr.cells(0).style.paddingLeft==""&&trCurrent.cells(0).style.paddingLeft=="20px")=="20px"){{if(el.src.indexOf("minus")==-1)if(el.src.indexOf("minus")==-1){{trCurrent.cells(0).getElementsByTagName("IMG").item(0).srctrCurrent.cells(0).getElementsByTagName("IMG").item(0).src="../pat/images/PropertyGroup_plus.gif";"../pat/images/PropertyGroup_plus.gif";}}}}else{else{break;break;}}}}if ( tr.cells(0).style.paddingLeft =="" && trCurrent.cells(0).style.paddingLeftif ( tr.cells(0).style.paddingLeft =="" && trCurrent.cells(0).style.paddingLeft=="40px"&&el.src.indexOf("minus")>0)=="40px"&&el.src.indexOf("minus")>0){{trCurrent.style.display=sDisplayReverse;trCurrent.style.display=sDisplayReverse;}}else{else{trCurrent.style.display=sDisplay;trCurrent.style.display=sDisplay;}}}}}functionfunctionStartHidden(el){for(vari=0;i<tbl.rows.length;i++)vartbl=el.parentElement.parentElement.parentElement.parentElement;for(vari=0;i<tbl.rows.length;i++)vartbl=el.parentElement.parentElement.parentElement.parentElement;{{vartrCurrent=vartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft.indexOf("px")>if(trCurrent.cells(0).style.paddingLeft.indexOf("px")>-1)}}}}{trCurrent.style.display="none";}}</script></script>HTML'<imgonclick=''ExpandCollapse(this)''src=''../pat/images/PropertyGroup_plus.gif''HTML'<imgonclick=''ExpandCollapse(this)''src=''../pat/images/PropertyGroup_plus.gif''style=''cursor:hand;style=''cursor:hand;vertical-align:middle;margin-right:2px''/><spanonclick=''ExpandCollapse(this.previousSibling)''onclick=''ExpandCollapse(this.previousSibling)''style=''cursor:hand''>'+[gosales_goretailers].[[gosales_goretailers].[].['</span>''<imgonclick=''ExpandCollapse(this)''src=''../pat/images/PropertyGroup_plus.gif''HTML'<imgonclick=''ExpandCollapse(this)''src=''../pat/images/PropertyGroup_plus.gif''style=''cursor:hand;style=''cursor:hand;vertical-align:middle;margin-right:2px''/><spanonclick=''ExpandCollapse(this.previousSibling)''onclick=''ExpandCollapse(this.previousSibling)''style=''cursor:hand''>'+[gosales_goretailers].[[gosales_goretailers].[].['</span>'名称HTML否则不能实现隐L<imgonload='StartHidden(this)'src='../pat/images/blank.gif'/>代码如下：<imgonload='StartHidden(this)'src='../pat/images/blank.gif'/>选择并设置每样就不用再翻了）UNIONHTML。面介绍。1：HTMLLISTLISTpaddingLeftpadding<script>1HTML<script>/*纵向折叠*//*纵向折叠*/functionExpandCollapse1(el)functionExpandCollapse1(el)if(el.src.indexOf("blank")>0if(el.src.indexOf("blank")>0) return;vartr=el.parentElement.parentElement;vartr=el.parentElement.parentElement;vartbl=vartbl=tr.parentElement;/*判断加减号*//*判断加减号*/el.srcel.src="../pat/images/PropertyGroup_"+(el.src.indexOf("minus")==-1?"minus":"plus")+".gif";"plus")+".gif";/*判断层次*//*判断层次*//*每/*每最外层if级目录展开缩*/if(tr.cells(0).style.paddingLeft=="20px")if(tr.cells(0).style.paddingLeft=="20px")/*/*x{/*循环读取并判断表中每一条记录。*//*循环读取并判断表中每一条记录。*/for(vari=tr.rowIndex+1;i<tbl.rows.length;i++)for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{varvartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft=="20px")if(trCurrent.cells(0).style.paddingLeft=="20px")/*如果是当前目录则退出循环不作处理*//*如果是当前目录则退出循环不作处理*/{break;}{break;}if(el.src.indexOf("minus")>0)if(el.src.indexOf("minus")>0)/*/*判断是否图标为“-号，如果是则有可能是其已经展开了的子目录，但现还不能确定是否是其子目录，有可能是同一级的已展开了的目录*/目录，有可能是同一级的已展开了的目录*/if(trCurrent.cells(0).style.paddingLeft=="40px")if(trCurrent.cells(0).style.paddingLeft=="40px")/*判断是否为当前目录的子目录。若是则展开，因为/*判断是否为当前目录的子目录。若是则展开，因为minu“标记表明已经由plus“转变过来。即点击了即点击了*/{{/*表示可以显示*//*表示可以显示*/trCurrent.style.display="";trCurrent.style.display="";/*并将/*并将-“号图标变为trCurrent.cells(0).getElementsByTagName("IMG").item(0).srctrCurrent.cells(0).getElementsByTagName("IMG").item(0).src="../pat/images/PropertyGroup_plus.gif";"../pat/images/PropertyGroup_plus.gif";}}/*以下if语句实现展开后缩进*//*以下if语句实现展开后缩进*/if(el.src.indexOf("plus")>0)if(el.src.indexOf("plus")>0)if((trCurrent.cells(0).style.paddingLeft=="40px")if((trCurrent.cells(0).style.paddingLeft=="40px")||(trCurrent.cells(0).style.paddingLeft=="60px")||(trCurrent.cells(0).style.paddingLeft=="60px")||(trCurrent.cells(0).style.paddingLeft=="80px"))||(trCurrent.cells(0).style.paddingLeft=="80px")){{/*隐藏当前目录下的行记录。*//*隐藏当前目录下的行记录。*/trCurrent.style.display="none";trCurrent.style.display="none";}}}}}}/*以下模块功能和上面差不多。*//*以下模块功能和上面差不多。*/if(tr.cells(0).style.paddingLeft=="40px")if(tr.cells(0).style.paddingLeft=="40px"){{for(vari=tr.rowIndex+1;i<tbl.rows.length;i++for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{varvartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft=="40px")if(trCurrent.cells(0).style.paddingLeft=="40px"){break;}{break;}if(el.src.indexOf("minus")>0)if(el.src.indexOf("minus")>0)if(trCurrent.cells(0).style.paddingLeft=="60px")if(trCurrent.cells(0).style.paddingLeft=="60px")trCurrent.style.display="";{trCurrent.style.display="";{trCurrent.cells(0).getElementsByTagName("IMG").item(0).srctrCurrent.cells(0).getElementsByTagName("IMG").item(0).src="../pat/images/PropertyGroup_plus.gif";"../pat/images/PropertyGroup_plus.gif";}}if(el.src.indexOf("plus")>0)if(el.src.indexOf("plus")>0)if((trCurrent.cells(0).style.paddingLeft=="60px")if((trCurrent.cells(0).style.paddingLeft=="60px")||(trCurrent.cells(0).style.paddingLeft=="80px"))||(trCurrent.cells(0).style.paddingLeft=="80px")){trCurrent.style.display="none";}{trCurrent.style.display="none";}}}}}if(tr.cells(0).style.paddingLeft=="60px")if(tr.cells(0).style.paddingLeft=="60px"){{for(vari=tr.rowIndex+1;i<tbl.rows.length;i++for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{varvartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft=="60px")if(trCurrent.cells(0).style.paddingLeft=="60px"){break;}{break;}if(el.src.indexOf("minus")>0)if(el.src.indexOf("minus")>0)if(trCurrent.cells(0).style.paddingLeft=="80px")if(trCurrent.cells(0).style.paddingLeft=="80px"){{trCurrent.style.display="";trCurrent.style.display="";}}if(el.src.indexOf("plus")>0)if(el.src.indexOf("plus")>0)if(trCurrent.cells(0).style.paddingLeft=="80px")if(trCurrent.cells(0).style.paddingLeft=="80px"){trCurrent.style.display="none";}{trCurrent.style.display="none";}}}}}}/*/*。*/functionStartHidden(el)functionStartHidden(el)vartbl=el.previousSibling;vartbl=el.previousSibling;varvartrCurrent2=tbl.rows(0);varsubnum;varsubnum;vari,j,jj;vari,j,jj;/*判断层次，*//*判断层次，*//*若要显示总/*若要显示总，则消除下*//*trCurrent2.cells(trCurrent2.cells.length-1).children(0).innerText="合计";*//*trCurrent2.cells(trCurrent2.cells.length-1).children(0).innerText="合计";*/if((trCurrent2.cells(j).children(0).innerText.indexOf(" ")==0)for(varj=1;j<trCurrent2.cells.length;j++){if((trCurrent2.cells(j).children(0).innerText.indexOf(" ")==0)for(varj=1;j<trCurrent2.cells.length;j++){&&(trCurrent2.cells(j).children(0).innerText.indexOf("&&(trCurrent2.cells(j).children(0).innerText.indexOf("")!=0)){trCurrent2.cells(j).style.paddingTop="10px";trCurrent2.cells(j).style.paddingTop="10px";continue;continue;}}if((trCurrent2.cells(j).children(0).innerText.indexOf("if((trCurrent2.cells(j).children(0).innerText.indexOf("")==0)&&(trCurrent2.cells(j).children(0).innerText.indexOf("&&(trCurrent2.cells(j).children(0).innerText.indexOf("")!=0)){trCurrent2.cells(j).style.paddingTop="20px";trCurrent2.cells(j).style.paddingTop="20px";continue;continue;}}}}/*/**//*/**/vartrCurrent1;vartrCurrent1;/*tbl.rows(1).cells(0).children(1).innerText="合计";*//*tbl.rows(1).cells(0).children(1).innerText="合计";*/tbl.rows(1).cells(0).getElementsByTagName("IMG").item(0).srctbl.rows(1).cells(0).getElementsByTagName("IMG").item(0).src="../pat/images/blank.gif";"../pat/images/blank.gif";/*从表中第二/*从表中第二记录开始判断子目录是否展开了展开了隐藏。第一为合计汇*/for(i=2;i<tbl.rows.length;i++){for(i=2;i<tbl.rows.length;i++){trCurrent1=tbl.rows(i);trCurrent1=tbl.rows(i);if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf(" ")!=0)){&&(trCurrent1.cells(0).children(1).innerText.indexOf(" ")!=0)){trCurrent1.cells(0).style.paddingLeft="20px";trCurrent1.cells(0).style.paddingLeft="20px";/*trCurrent1.style.display="none";*//*trCurrent1.style.display="none";*/continue;continue;}}if((trCurrent1.cells(0).children(1).innerText.indexOf(" ")==0)if((trCurrent1.cells(0).children(1).innerText.indexOf(" ")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf("")!=0)){trCurrent1.cells(0).style.paddingLeft="40px";trCurrent1.cells(0).style.paddingLeft="40px";trCurrent1.style.display="none";trCurrent1.style.display="none";continue;continue;}}if((trCurrent1.cells(0).children(1).innerText.indexOf("if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf("")!=0)){trCurrent1.cells(0).style.paddingLeft="60px";trCurrent1.cells(0).style.paddingLeft="60px";trCurrent1.style.display="none";trCurrent1.style.display="none";}}if((trCurrent1.cells(0).children(1).innerText.indexOf("if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf("")!=0)){trCurrent1.cells(0).style.paddingLeft="80px";trCurrent1.cells(0).style.paddingLeft="80px";trCurrent1.style.display="none";trCurrent1.style.display="none";trCurrent1.cells(0).getElementsByTagName("IMG").item(0).srctrCurrent1.cells(0).getElementsByTagName("IMG").item(0).src=}"../pat/images/blank.gif";}"../pat/images/blank.gif";}}}</script></script>2Lstyle=''cursor:hand;vertical-align:middle;margin-right:2px''/>''<img onclick=''ExpandCollapse1(this)''style=''cursor:hand;vertical-align:middle;margin-right:2px''/>''<img onclick=''ExpandCollapse1(this)''src=''../pat/images/PropertyGroup_plus.gif''2HTML<imgonload='StartHidden(this)'<imgonload='StartHidden(this)'src='../pat/images/blank.gif'/>（具体制程）表LIST建如插长度空识那么方另外始空长度让代识（具体制程）科科选择功选择科下自动该科成员框供选择1p_level123)2“条件资源管理器”定义条件变量读取是p_level3（RenderVariable对应条件变量具体值（即该值则生该列）CASE??WHEN'1'THEN4要自动提交；列要cascadep_level5Query时需要通过case来控制CASE??WHEN'1'THENcaption([erpfdb].[CCB_COGNOS_FTACCT_DV1].[CCB_COGNOS_FTACCT_DV].[ACCT1_DESC])caption([erpfdb].[CCB_COGNOS_FTACCT_DV1].[CCB_COGNOS_FTACCT_DV].[ACCT1_DESC])WHEN'2'THENWHEN'2'THENcaption([erpfdb].[CCB_COGNOS_FTACCT_DV1].[CCB_COGNOS_FTACCT_DV].[ACCT2_DESC])caption([erpfdb].[CCB_COGNOS_FTACCT_DV1].[CCB_COGNOS_FTACCT_DV].[ACCT2_DESC])WHEN'3'THENWHEN'3'THENcaption([erpfdb].[CCB_COGNOS_FTACCT_DV1].[CCB_COGNOS_FTACCT_DV].[ACCT3_DESC])caption([erpfdb].[CCB_COGNOS_FTACCT_DV1].[CCB_COGNOS_FTACCT_DV].[ACCT3_DESC])ENDEND6Query条件则需要给每个供都添加条件条件“可（optional”即可特点：多列折叠例报：0个l1个“；下来“政条线”就不起了“默认2”就属于1了表为sxtrCurrent1.cells(1).getElementsByTagName("IMG").item(0).src="../pat/images/blank.gif";if(trCurrent1.cells(0).style.paddingLeft=="5px"){}/*果是“政条线”trCurrent1.cells(1).getElementsByTagName("IMG").item(0).src="../pat/images/blank.gif";if(trCurrent1.cells(0).style.paddingLeft=="5px"){}/*取cells(1*/else{else{……if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)/*否则取cells(0)对象*/……if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)其他跟上述折叠报表技巧类似全部展开、折叠功能果下：报表上添加了“全部展开”按钮点击可将折叠的项都展开；<script>1、修改原来的js代码：<script>/*纵向折叠*//*纵向折叠*/vartbl;vartbl;functionallWrap(el)functionallWrap(el)if(el.value=="全部展开"){{if(el.value=="全部展开"){for(i=2;i<tbl.rows.length;i++){for(i=2;i<tbl.rows.length;i++){tbl.rows(i).style.display="";tbl.rows(i).style.display="";if(tbl.rows(i).cells(0).style.paddingLeft!="80px")if(tbl.rows(i).cells(0).style.paddingLeft!="80px")="../pat/images/PropertyGroup_minus.gif";"../pat/images/PropertyGroup_minus.gif";}}el.value="全部折叠";el.value="全部折叠";return;return;}}if(el.value=="全部折叠"){if(el.value=="全部折叠"){for(i=2;i<tbl.rows.length;i++){for(i=2;i<tbl.rows.length;i++){if(tbl.rows(i).cells(0).style.paddingLeft!="20px")if(tbl.rows(i).cells(0).style.paddingLeft!="20px")tbl.rows(i).style.display="none";tbl.rows(i).style.display="none";if(tbl.rows(i).cells(0).style.paddingLeft!="80px")if(tbl.rows(i).cells(0).style.paddingLeft!="80px")="../pat/images/PropertyGroup_plus.gif";"../pat/images/PropertyGroup_plus.gif";}}el.value="全部展开";el.value="全部展开";}}functionExpandCollapse1(el)}functionExpandCollapse1(el)if(el.src.indexOf("blank")>0if(el.src.indexOf("blank")>0) return;vartr=el.parentElement.parentElement;vartr=el.parentElement.parentElement;/*vartbl=tr.parentElement;*//*vartbl=tr.parentElement;*//*/**/el.src="../pat/images/PropertyGroup_"+(el.src.indexOf("minus")==-1?"minus":el.src="../pat/images/PropertyGroup_"+(el.src.indexOf("minus")==-1?"minus":"plus")+".gif";"plus")+".gif";/*/**/if(tr.cells(0).style.paddingLeft=="20px")if(tr.cells(0).style.paddingLeft=="20px"){{for(vari=tr.rowIndex+1;i<tbl.rows.length;i++for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{varvartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft=="20px")if(trCurrent.cells(0).style.paddingLeft=="20px"){break;}{break;}if(el.src.indexOf("minus")>0)if(el.src.indexOf("minus")>0)if(trCurrent.cells(0).style.paddingLeft=="40px")if(trCurrent.cells(0).style.paddingLeft=="40px"){{trCurrent.style.display="";trCurrent.style.display="";trCurrent.cells(0).getElementsByTagName("IMG").item(0).srctrCurrent.cells(0).getElementsByTagName("IMG").item(0).src="../pat/images/PropertyGroup_plus.gif";"../pat/images/PropertyGroup_plus.gif";}}if(el.src.indexOf("plus")>0)if(el.src.indexOf("plus")>0)if((trCurrent.cells(0).style.paddingLeft=="40px")if((trCurrent.cells(0).style.paddingLeft=="40px")||(trCurrent.cells(0).style.paddingLeft=="60px")||(trCurrent.cells(0).style.paddingLeft=="60px")||(trCurrent.cells(0).style.paddingLeft=="80px"))||(trCurrent.cells(0).style.paddingLeft=="80px")){trCurrent.style.display="none";}{trCurrent.style.display="none";}}}}}if(tr.cells(0).style.paddingLeft=="40px")if(tr.cells(0).style.paddingLeft=="40px"){{for(vari=tr.rowIndex+1;i<tbl.rows.length;i++for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{varvartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft=="40px")if(trCurrent.cells(0).style.paddingLeft=="40px"){break;}{break;}if(el.src.indexOf("minus")>0)if(el.src.indexOf("minus")>0){if(trCurrent.cells(0).style.paddingLeft=="60px"){if(trCurrent.cells(0).style.paddingLeft=="60px")trCurrent.style.display="";trCurrent.style.display="";trCurrent.cells(0).getElementsByTagName("IMG").item(0).srctrCurrent.cells(0).getElementsByTagName("IMG").item(0).src="../pat/images/PropertyGroup_plus.gif";"../pat/images/PropertyGroup_plus.gif";}}if(el.src.indexOf("plus")>0)if(el.src.indexOf("plus")>0)if((trCurrent.cells(0).style.paddingLeft=="60px")if((trCurrent.cells(0).style.paddingLeft=="60px")||(trCurrent.cells(0).style.paddingLeft=="80px"))||(trCurrent.cells(0).style.paddingLeft=="80px")){trCurrent.style.display="none";}{trCurrent.style.display="none";}}}}}if(tr.cells(0).style.paddingLeft=="60px")if(tr.cells(0).style.paddingLeft=="60px"){{for(vari=tr.rowIndex+1;i<tbl.rows.length;i++for(vari=tr.rowIndex+1;i<tbl.rows.length;i++){{varvartrCurrent=tbl.rows(i);if(trCurrent.cells(0).style.paddingLeft=="60px")if(trCurrent.cells(0).style.paddingLeft=="60px"){break;}{break;}if(el.src.indexOf("minus")>0)if(el.src.indexOf("minus")>0)if(trCurrent.cells(0).style.paddingLeft=="80px")if(trCurrent.cells(0).style.paddingLeft=="80px"){{trCurrent.style.display="";trCurrent.style.display="";}}if(el.src.indexOf("plus")>0)if(el.src.indexOf("plus")>0)if(trCurrent.cells(0).style.paddingLeft=="80px")if(trCurrent.cells(0).style.paddingLeft=="80px"){trCurrent.style.display="none";}{trCurrent.style.display="none";}}}}}}functionfunctionStartHidden(el){/*var*/tbl=el.previousSibling;/*var*/tbl=el.previousSibling;vartrCurrent2=tbl.rows(0);vartrCurrent2=tbl.rows(0);varsubnum;varsubnum;vari,j,jj;vari,j,jj;/*判断层次，*//*判断层次，*//*trCurrent2.cells(trCurrent2.cells.length-1).children(0).innerText=/*trCurrent2.cells(trCurrent2.cells.length-1).children(0).innerText=";*/for(varj=1;j<trCurrent2.cells.length;j++){for(varj=1;j<trCurrent2.cells.length;j++){if((trCurrent2.cells(j).children(0).innerText.indexOf(" ")==0)if((trCurrent2.cells(j).children(0).innerText.indexOf(" ")==0)&&(trCurrent2.cells(j).children(0).innerText.indexOf("&&(trCurrent2.cells(j).children(0).innerText.indexOf("")!=0)){trCurrent2.cells(j).style.paddingTop="10px";trCurrent2.cells(j).style.paddingTop="10px";continue;continue;}}if((trCurrent2.cells(j).children(0).innerText.indexOf("if((trCurrent2.cells(j).children(0).innerText.indexOf("")==0)&&(trCurrent2.cells(j).children(0).innerText.indexOf("&&(trCurrent2.cells(j).children(0).innerText.indexOf("")!=0)){trCurrent2.cells(j).style.paddingTop="20px";trCurrent2.cells(j).style.paddingTop="20px";continue;continue;}}}}/*纵向折叠*//*纵向折叠*/vartrCurrent1;vartrCurrent1;/*tbl.rows(1).cells(0).children(1).innerText=/*tbl.rows(1).cells(0).children(1).innerText=";*/="../pat/images/blank.gif";"../pat/images/blank.gif";for(i=2;i<tbl.rows.length;i++for(i=2;i<tbl.rows.length;i++){trCurrent1=tbl.rows(i);trCurrent1=tbl.rows(i);if((trCurrent1.cells(0).children(1).innerText.indexOf("if((trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf(" ")!=0)){&&(trCurrent1.cells(0).children(1).innerText.indexOf(" ")!=0)){trCurrent1.cells(0).style.paddingLeft="20px";trCurrent1.cells(0).style.paddingLeft="20px";/*trCurrent1.style.display=/*trCurrent1.style.display="none";*/continue;continue;}}if((trCurrent1.cells(0).children(1).innerText.indexOf(" ")==0)if((trCurrent1.cells(0).children(1).innerText.indexOf(" ")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf("")!=0)){trCurrent1.cells(0).style.paddingLeft="40px";trCurrent1.cells(0).style.paddingLeft="40px";trCurrent1.style.display="none";trCurrent1.style.display="none";continue;continue;}}if((trCurrent1.cells(0).children(1).innerText.indexOf("if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf("")!=0)){trCurrent1.cells(0).style.paddingLeft="60px";trCurrent1.cells(0).style.paddingLeft="60px";trCurrent1.style.display="none";trCurrent1.style.display="none";}}if((trCurrent1.cells(0).children(1).innerText.indexOf("if((trCurrent1.cells(0).children(1).innerText.indexOf("")==0)&&(trCurrent1.cells(0).children(1).innerText.indexOf("&&(trCurrent1.cells(0).children(1).innerText.indexOf("")!=0)){trCurrent1.cells(0).style.paddingLeft="80px";trCurrent1.cells(0).style.paddingLeft="80px";"../pat/images/blank.gif";}"../pat/images/blank.gif";}trCurrent1.style.display="none";trCurrent1.cells(0).getElementsByTagName("IMG").item(0).src=}}}</script>jsallWrap(el)“全部功能。<inputtype="buttonvalue=2L<inputtype="buttonvalue=在交叉表中类似列表中页眉效果123456，PAGEPAGE25/317t空间“控件也作一行或一列。何通过一列控制另一列数展开与缩进下面以业务报表 1为例，通过，以，为每一个部门中的产品作一个小计。1， l，下：'<imgstyle=''cursor:hand;vertical-align:middle;margin-right:2px''/>'2，，表，通过后，如上图所示。3， 为。4， 表下面L，下5， 页眉处的 vt代码是关键，代码如下：<scriptLANGUAGE="JavaScript">varimg_pls="PropertyGroup_plus.gif";varimg_min="PropertyGroup_minus.gif";varimg_blk="blank.gif";varimg_pth="../pat/images/";vartab_obj;varcell_num=24; //设置交换列数varbegin_line=2; //开始行下标varle"5px";//缩进距离functionStartHidden(obj) //初始化函数。{tab_obj=obj.previousSibling;varrow_len=tab_obj.rows.length;varrow_index;//tab_obj.rows(row_len-1).cells(1).getElementsByTagName("IMG").item(0).src=img_pth+img_blk;//将“总计”前面的“+”号去去掉。for(vari=begin_line;i<row_len-1;i++){// if(tab_obj.rows(i).cells(1).innerText=="非经营性部门"){tab_obj.rows(i).cells(1).children(1).innerText="非经营部门";tab_obj.rows(i).cells(24).children(0).innerText="非经营部门";PAGEPAGE27 /31}varstr5=tab_obj.rows(i).cells(1).innerText;if(str5.substr(0,6)=="经营部门合计"){tab_obj.rows(i).cells(1).getElementsByTagName("IMG").item(0).src=img_pth+img_blk;}//if(tab_obj.rows(i).cells(1).style.paddingLeft==leftpad) //如果为产品”{tab_obj.rows(i).style.display="none";}else 等于部门或经营部门合计。{row_index=tab_obj.rows(i).rowIndex; //记录当前部门的行下标}//移动单元格，目的是将“小计”行的数据与部门的第一行进行调换。varstr4=tab_obj.rows(row_index).cells(1).