잘 됩니다.

빠른 답변 감사 드립니다.

수고 하세요.



>게시판을 이용해 주셔서 감사합니다.
>다음양식에 맞게 입력해주세요.
>
>* 고객시스템명 : LG CNS
>* GAUCE 버전 : 3.5
>* WAS 종류(WebLogic 등등) : 8.x
>* DB 종류 : Oracle 9i
>* 문의 유형(질문/요청/참조) :  질문
>* 내용 : 수제건과 같이 SubSumText 를 subsum 라인별 표현하고 싶습니다.
>
>아래는 소스이고 소스가 너무길어 필요 부분만 첨부 합니다.
>
>=== 아 래 ===
>
>function f_gridHeaderSet() {
>    var currentMonth = eme_currentMonth.text.substring(4,6);
>    gr_inventoryTurnoverRatio.format = ''
>        +'<fc> id=branchName           name="LG Office"           sort=true  width=78  align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText="Sub Total", SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=agentName            name="Agent"               sort=true  width=70  align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="6", SubSumText="",          SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=product              name="Product"             sort=true  width=80  align=left   HeadBgColor=#F7F7EF, HeadColor=Black, suppress="5", SubSumText="",          value={decode(product,""," ",product)}, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=productLine          name="Product;Line"        sort=true  width=80  align=left   HeadBgColor=#F7F7EF, HeadColor=Black, suppress="4", SubSumText="",          value={decode(productLine,""," ",productLine)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=shipFrom             name="Ship;From"           sort=true  width=55  align=left   HeadBgColor=#F7F7EF, HeadColor=Black, suppress="3", SubSumText="",          value={decode(shipFrom,""," ",shipFrom)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=gblModelAndGblSuffix name="Global Model.Suffix" sort=true  width=140 align=left   HeadBgColor=#F7F7EF, HeadColor=Black, suppress="2", SubSumText="",          SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=agentModel           name="Agent Model"         sort=true  width=100 align=left   HeadBgColor=#F7F7EF, HeadColor=Black, suppress="1", SubSumText="",          SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>        +'<fc> id=monthCurrent         name="Current("'+currentMonth+'")"   width=80  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</fc>'
>        +'<c>  id=month01              name=1M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month02              name=2M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month03              name=3M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month04              name=4M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month05              name=5M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month06              name=6M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month09              name=9M                                 width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month12              name=12M                                width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
>        +'<c>  id=month12Over          name="12M ~"                            width=50  align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>';
>        +'<h>  id=modelMapId           name="ModelMapId"                     width=50  align=left   HeadBgColor=#F7F7EF, HeadColor=Black,                                       SumColor="Black", SumBgColor="#F7F7EF"</h>'
>    gr_inventoryTurnoverRatio.dataid = "ds_inventoryAsing";
>}
>
><!-----------------------------------------------------------------------------
>    Dataset Components Declaration
>------------------------------------------------------------------------------>
><!-- 재고 월  DataSet -->
><object id="ds_inventoryAsing" classid="<%=LGauceId.DATASET%>">
>    <param name=SubsumExpr value="3:branchName,2:agentName,1:product">
>    <param name=SyncLoad   value=true >
></object>
>
>위의 소스에서 grid 컴포넌트에서 데이터를 보여줄때 SubsumExpr의 value 값에서 3, 2, 1 의 값을 알아내어
>'<fc> id=branchName           name="LG Office"           sort=true  width=78  align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText={decode(???,3,"Sub Total","") , SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
>이런식으로 현현하고 싶습니다. 물론 ???는 제가 모르는 것이기에 물음표 처리 하였습니다.
>