게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.
**필수입력사항**
* 고객(업체)명 : 현대로지스틱스
* 제품 버전 : GAUCE 4.0
* 문의 유형(질문/요청/참조) : Report
* 내용 :
전에 게시판에 올렸었는데, 답변을 확인하기 전에 게시판 글이 다 날아갔네요.
report에 데이터를 바인딩 하는데, 특정 조회조건에서만 바인딩이 안 됩니다.
[선언된 Report]
<object id=tb_Report classid=CLSID:CC26E2A9-760B-4EA6-8DDF-DB423FD24089>
<param name="MasterDataID" value="ds_TITLE">
<param name="DetailDataID" value="dsT_CP_PAYMASTER">
<param name="PrintSetupDlgFlag" value="true">
<param name="PaperSize" value="A4">
<param name=LandScape value="false">
<param name="Format" value="
<B>id=Header ,left=0,top=0 ,right=2000 ,bottom=701 ,face='Tahoma' ,size=10 ,penwidth=2
<C>id='TITLE', left=0, top=127, right=1852, bottom=225, face='Tahoma', size=20, bold=true, underline=true, italic=false, forecolor=#000000, backcolor=#FFFFFF</C>
<X>left=1193 ,top=336 ,right=1855 ,bottom=587 ,border=true</X>
<T>id='사장' ,left=1717 ,top=344 ,right=1831 ,bottom=410</T>
<T>id='전무' ,left=1550 ,top=344 ,right=1664 ,bottom=410</T>
<T>id='부서장' ,left=1384 ,top=344 ,right=1498 ,bottom=410</T>
<T>id='기안' ,left=1217 ,top=344 ,right=1331 ,bottom=410</T>
<L> left=1696 ,top=336 ,right=1696 ,bottom=585 </L>
<L> left=1524 ,top=336 ,right=1524 ,bottom=585 </L>
<L> left=1352 ,top=336 ,right=1352 ,bottom=585 </L>
<L> left=5 ,top=701 ,right=1855 ,bottom=701 </L>
<L> left=1193 ,top=423 ,right=1852 ,bottom=423 </L>
</B>
<B>id=DHeader ,left=0,top=0 ,right=1900 ,bottom=167 ,face='Tahoma' ,size=10 ,penwidth=2
<T>id='항목' ,left=987 ,top=95 ,right=1363 ,bottom=159</T>
<T>id='금액' ,left=1447 ,top=95 ,right=1823 ,bottom=159</T>
<T>id='항목' ,left=61 ,top=95 ,right=437 ,bottom=159</T>
<L> left=5 ,top=167 ,right=1852 ,bottom=167 </L>
<L> left=463 ,top=82 ,right=463 ,bottom=167 </L>
<L> left=1410 ,top=85 ,right=1410 ,bottom=167 </L>
<L> left=908 ,top=3 ,right=908 ,bottom=167 </L>
<L> left=5 ,top=0 ,right=5 ,bottom=167 </L>
<T>id='금액' ,left=489 ,top=98 ,right=865 ,bottom=161</T>
<T>id='공제액' ,left=982 ,top=11 ,right=1823 ,bottom=77</T>
<T>id='지급액' ,left=61 ,top=5 ,right=863 ,bottom=71</T>
<L> left=5 ,top=82 ,right=1849 ,bottom=82 </L>
<L> left=5 ,top=82 ,right=1799 ,bottom=82 </L>
<L> left=1852 ,top=0 ,right=1852 ,bottom=167 </L>
</B>
<B>id=default ,left=0,top=0 ,right=1900 ,bottom=1366 ,face='Tahoma' ,size=10 ,penwidth=2
<T>id='법정수당' ,left=61 ,top=90 ,right=437 ,bottom=153 ,align='left', MargineX=15</T>
<T>id='직책수당' ,left=61 ,top=169 ,right=437 ,bottom=233 ,align='left', MargineX=15</T>
<T>id='상여금' ,left=61 ,top=249 ,right=437 ,bottom=312 ,align='left', MargineX=15</T>
<T>id='기타수당' ,left=61 ,top=328 ,right=437 ,bottom=392 ,align='left', MargineX=15</T>
<T>id='개인연금' ,left=61 ,top=407 ,right=437 ,bottom=471 ,align='left', MargineX=15</T>
<T>id='기본급' ,left=61 ,top=11 ,right=437 ,bottom=74 ,align='left', MargineX=15</T>
<T>id='기타지불2' ,left=61 ,top=564 ,right=437 ,bottom=627 ,align='left', MargineX=15</T>
<T>id='식대' ,left=61 ,top=643 ,right=437 ,bottom=706 ,align='left', MargineX=15</T>
<T>id='기타지불1' ,left=61 ,top=484 ,right=437 ,bottom=548 ,align='left', MargineX=15</T>
<C>id='HOL_AMT', left=489, top=564, right=865, bottom=627, align='right'</C>
<C>id='LUN_AMT', left=489, top=643, right=865, bottom=706, align='right'</C>
<L> left=5 ,top=79 ,right=1852 ,bottom=79 </L>
<L> left=5 ,top=159 ,right=1852 ,bottom=159 </L>
<L> left=5 ,top=238 ,right=1852 ,bottom=238 </L>
<L> left=5 ,top=318 ,right=1852 ,bottom=318 </L>
<L> left=5 ,top=635 ,right=1852 ,bottom=635 </L>
<L> left=5 ,top=714 ,right=1852 ,bottom=714 </L>
<L> left=5 ,top=397 ,right=1852 ,bottom=397 </L>
<L> left=5 ,top=476 ,right=1852 ,bottom=476 </L>
<L> left=5 ,top=1032 ,right=1852 ,bottom=1032 </L>
<L> left=5 ,top=1111 ,right=1852 ,bottom=1111 </L>
<L> left=5 ,top=953 ,right=1852 ,bottom=953 </L>
<L> left=5 ,top=794 ,right=1852 ,bottom=794 </L>
<L> left=5 ,top=873 ,right=1852 ,bottom=873 </L>
<C>id='PPED_AMT', left=1447, top=643, right=1823, bottom=706, align='right'</C>
<T>id='개인연금' ,left=987 ,top=643 ,right=1363 ,bottom=706 ,align='left', MargineX=15</T>
<T>id='공조회비' ,left=987 ,top=564 ,right=1363 ,bottom=627 ,align='left', MargineX=15</T>
<C>id='DHLP_AMT', left=1447, top=564, right=1823, bottom=627, align='right'</C>
<C>id='OLD_AMT', left=1447, top=484, right=1823, bottom=548, align='right'</C>
<T>id='장기요양보험' ,left=987 ,top=484 ,right=1363 ,bottom=548 ,align='left', MargineX=15</T>
<T>id='고용보험' ,left=987 ,top=407 ,right=1363 ,bottom=471 ,align='left', MargineX=15</T>
<C>id='HINS_AMT', left=1447, top=407, right=1823, bottom=471, align='right'</C>
<C>id='HINU_AMT', left=1447, top=328, right=1823, bottom=392, align='right'</C>
<T>id='건강보험' ,left=987 ,top=328 ,right=1363 ,bottom=392 ,align='left', MargineX=15</T>
<T>id='국민연금' ,left=987 ,top=249 ,right=1363 ,bottom=312 ,align='left', MargineX=15</T>
<C>id='NPEN_AMT', left=1447, top=249, right=1823, bottom=312, align='right'</C>
<C>id='ETC_AMT_JN', left=1447, top=169, right=1823, bottom=233, align='right'</C>
<T>id='연말정산' ,left=987 ,top=169 ,right=1363 ,bottom=233 ,align='left', MargineX=15</T>
<T>id='주민세' ,left=987 ,top=90 ,right=1363 ,bottom=153 ,align='left', MargineX=15</T>
<C>id='CITI_TAX', left=1447, top=90, right=1823, bottom=153, align='right'</C>
<T>id='소득세' ,left=987 ,top=11 ,right=1363 ,bottom=74 ,align='left', MargineX=15</T>
<C>id='INCM_TAX', left=1447, top=11, right=1823, bottom=74, align='right'</C>
<C>id='OTH_AMT', left=489, top=487, right=865, bottom=550, align='right'</C>
<C>id='PPEN_AMT', left=489, top=410, right=865, bottom=474, align='right'</C>
<C>id='ETC_AMT', left=489, top=331, right=865, bottom=394, align='right'</C>
<C>id='BNS_AMT', left=489, top=251, right=865, bottom=315, align='right'</C>
<C>id='DUTY_AMT', left=489, top=172, right=865, bottom=235, align='right'</C>
<C>id='LAW_AMT', left=489, top=93, right=865, bottom=156, align='right'</C>
<C>id='BAS_AMT', left=489, top=13, right=865, bottom=77, align='right'</C>
<L> left=908 ,top=0 ,right=908 ,bottom=1270 </L>
<L> left=8 ,top=556 ,right=1855 ,bottom=556 </L>
<T>id='기타공제2' ,left=987 ,top=881 ,right=1363 ,bottom=945 ,align='left', MargineX=15</T>
<C>id='OTHD_AMT', left=1447, top=802, right=1823, bottom=865, align='right'</C>
<T>id='기타공제1' ,left=987 ,top=802 ,right=1363 ,bottom=865 ,align='left', MargineX=15</T>
<C>id='ETC_AMT2', left=1447, top=881, right=1823, bottom=945, align='right'</C>
<C>id='DDTT_AMT', left=1447, top=960, right=1823, bottom=1024, align='right'</C>
<T>id='계' ,left=987 ,top=960 ,right=1363 ,bottom=1024 ,align='left', MargineX=15</T>
<T>id='실지급액' ,left=990 ,top=1040 ,right=1365 ,bottom=1103 ,align='left', MargineX=15</T>
<C>id='RL_AMT', left=1450, top=1040, right=1826, bottom=1103, align='right'</C>
<C>id='CONT_AMT', left=1450, top=1119, right=1826, bottom=1183, align='right'</C>
<T>id='사회공헌기금' ,left=990 ,top=1119 ,right=1365 ,bottom=1183 ,align='left', MargineX=15</T>
<T>id='실지급액' ,left=990 ,top=1199 ,right=1365 ,bottom=1262 ,align='left', MargineX=15</T>
<C>id='PAY_AMT', left=1450, top=1199, right=1826, bottom=1262, align='right'</C>
<T>id='출자금' ,left=987 ,top=725 ,right=1363 ,bottom=788 ,align='left', MargineX=15</T>
<C>id='INV_AMT', left=1447, top=722, right=1823, bottom=786, align='right'</C>
<T>id='계' ,left=61 ,top=960 ,right=437 ,bottom=1024 ,align='left', MargineX=15</T>
<C>id='SALT_AMT', left=489, top=960, right=865, bottom=1024, align='right'</C>
<L> left=1852 ,top=0 ,right=1852 ,bottom=1270 </L>
<L> left=5 ,top=1270 ,right=1852 ,bottom=1270 </L>
<L> left=1410 ,top=0 ,right=1410 ,bottom=1270 </L>
<L> left=463 ,top=0 ,right=463 ,bottom=1270 </L>
<L> left=5 ,top=1191 ,right=1852 ,bottom=1191 </L>
<L> left=5 ,top=0 ,right=5 ,bottom=1270 </L>
</B>
">
</object>
[쿼리 결과]
BAS_AMT LAW_AMT DUTY_AMT BNS_AMT ETC_AMT PPEN_AMT OTH_AMT HOL_AMT LUN_AMT SALT_AMT INCM_TAX CITI_TAX ETC_AMT_JN NPEN_AMT HINU_AMT HINS_AMT OLD_AMT DHLP_AMT PPED_AMT INV_AMT OTHD_AMT ETC_AMT2 DDTT_AMT RL_AMT CONT_AMT PAY_AMT
"879947120" "320352926" "5900000" "437311509" "27091461" "13179250" "523771598" "4660000" "0" "2212213864" "313220310" "31320640" "0" "57738390" "48450670" "10078141" "3154310" "2472000" "26428400" "5255000" "26040765" "22822600" "546981226" "1665232638" "190926" "1665041712"
자릿수 제한 같은 것이 있는 것인지 확인부탁드립니다.
|
|
질문이 명확하지 않아 답변드리기 어렵습니다.
"특정 조회조건에서만 바인딩이 안 됩니다." 모든 데이터가 안나오신다는 말씀이신가요?
여기서 말하는 특정 조회조건이란 어떤 상황인지 명확히 설명해주시기 바랍니다.
또 자릿수 제한을 말씀하셨는데 어떤 경우의 자리수 제한을 말씀하시는 건가요?
감사합니다.