글 수 7,449
김유진
조회 수 : 1335
2007.01.12 (01:27:12)
게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.
* 고객시스템명 :
* GAUCE 버전 : 4.0
* WAS 종류(WebLogic 등등) : weblogic
* DB 종류 : oracle
* 문의 유형(질문/요청/참조) :
* 내용 :
jsp에서 dataset을 얻어왔는데요.
그것을 grid에 담을 수 있나요?
또 한가지는 subsum에 관한건데요.
subsum을 구했을때 supress가 걸려있는데 그리드가 합쳐지지 않네요.
합치는 방법이 있는지요.
<X> Name="소 속" ID="1" bgcolor="<%=gridHeadColor%>"
<G> bgcolor="<%=gridHeadColor%>" </G>
<C> Name="단/실/지사" ID="SS_NAME" <%=gridCellColor%> align="left" width="120"
SumText="합 계" SubSumText="" SubBgColor=#FFFFFF <%=sumTBG%> Suppress="1" edit="none"
</C>
<C> Name="팀/지점" ID="SOSNAME" <%=gridCellColor%> SubSumText="소계" SubBgColor=#F0FAFF align="left" width="130"
<%=sumTBG%> edit="none"
</C>
</X>
<X> Name="정규직" ID="1" bgcolor="<%=gridHeadColor%>"
<G> bgcolor="<%=gridHeadColor%>" </G>
<C> Name="임;원" ID="MANAGER" sumtext=@sum
SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF SubColor=#305F81 <%=gridCellColor%>
align="right" width="20" <%=sumTBG%> edit="none" Value={Decode(MANAGER,0,,MANAGER)} HeadAlign="center"
</C>
<C> Name="1;직;급" ID="JIK1" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK1,0,,JIK1)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="2;직;급" ID="JIK2" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK2,0,,JIK2)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="3;직;급" ID="JIK3" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK3,0,,JIK3)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="4;직;급" ID="JIK4" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK4,0,,JIK4)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="5;직;급;A" ID="JIK5_A" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK5_A,0,,JIK5_A)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="5;직;급;B" ID="JIK5_B" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK5_B,0,,JIK5_B)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="6;직;급" ID="JIK6" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK6,0,,JIK6)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계;약; 갑" ID="KY3_1" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(KY3_1,0,,KY3_1)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계;약; 을" ID="KY3_2" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(KY3_2,0,,KY3_2)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계;약; 병" ID="KY3_3" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(KY3_3,0,,KY3_3)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계" ID="HAP" <%=gridCellColor%> align="right" width="35" sumtext=@sum <%=sumTBG%>
edit="none" SubBgColor=#F0FAFF Value={Decode(HAP,0,,HAP)} HeadAlign="center"
SubColor=#305F81
</C>
</X>
다음양식에 맞게 입력해주세요.
* 고객시스템명 :
* GAUCE 버전 : 4.0
* WAS 종류(WebLogic 등등) : weblogic
* DB 종류 : oracle
* 문의 유형(질문/요청/참조) :
* 내용 :
jsp에서 dataset을 얻어왔는데요.
그것을 grid에 담을 수 있나요?
또 한가지는 subsum에 관한건데요.
subsum을 구했을때 supress가 걸려있는데 그리드가 합쳐지지 않네요.
합치는 방법이 있는지요.
<X> Name="소 속" ID="1" bgcolor="<%=gridHeadColor%>"
<G> bgcolor="<%=gridHeadColor%>" </G>
<C> Name="단/실/지사" ID="SS_NAME" <%=gridCellColor%> align="left" width="120"
SumText="합 계" SubSumText="" SubBgColor=#FFFFFF <%=sumTBG%> Suppress="1" edit="none"
</C>
<C> Name="팀/지점" ID="SOSNAME" <%=gridCellColor%> SubSumText="소계" SubBgColor=#F0FAFF align="left" width="130"
<%=sumTBG%> edit="none"
</C>
</X>
<X> Name="정규직" ID="1" bgcolor="<%=gridHeadColor%>"
<G> bgcolor="<%=gridHeadColor%>" </G>
<C> Name="임;원" ID="MANAGER" sumtext=@sum
SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF SubColor=#305F81 <%=gridCellColor%>
align="right" width="20" <%=sumTBG%> edit="none" Value={Decode(MANAGER,0,,MANAGER)} HeadAlign="center"
</C>
<C> Name="1;직;급" ID="JIK1" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK1,0,,JIK1)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="2;직;급" ID="JIK2" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK2,0,,JIK2)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="3;직;급" ID="JIK3" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK3,0,,JIK3)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="4;직;급" ID="JIK4" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK4,0,,JIK4)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="5;직;급;A" ID="JIK5_A" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK5_A,0,,JIK5_A)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="5;직;급;B" ID="JIK5_B" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK5_B,0,,JIK5_B)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="6;직;급" ID="JIK6" <%=gridCellColor%> align="right" width="25"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(JIK6,0,,JIK6)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계;약; 갑" ID="KY3_1" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(KY3_1,0,,KY3_1)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계;약; 을" ID="KY3_2" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(KY3_2,0,,KY3_2)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계;약; 병" ID="KY3_3" <%=gridCellColor%> align="right" width="20"
sumtext=@sum SumColor=#FFFFFF SumBgColor=#C1AC79 SubBgColor=#F0FAFF
<%=sumTBG%> edit="none" Value={Decode(KY3_3,0,,KY3_3)} HeadAlign="center"
SubColor=#305F81
</C>
<C> Name="계" ID="HAP" <%=gridCellColor%> align="right" width="35" sumtext=@sum <%=sumTBG%>
edit="none" SubBgColor=#F0FAFF Value={Decode(HAP,0,,HAP)} HeadAlign="center"
SubColor=#305F81
</C>
</X>
|
|
