ȸ°è´Â ¾ðÁ¦ ´Ù ³¡³ª´Âµ¥?

ÆûÁîÀÇ ¼öÁ¤

1. Â÷º¯ Çö±Ý, Â÷º¯´ëü,´ëº¯Çö±Ý,´ëº¯´ëü Çʵ带 Ä«ÇÇÇÏ¿© º¹»çÇÑ´Ù.
2. Propertyµé¾î°¡¼­ À̸§À» dr_cash_amt1,r_tran_amt1,cr_cash_amt,cr_tran_amt·Î °íÄ¡°í
Database Item : No, Visible: No·Î °íÄ£´Ù.
3. :sb1ÀÇ Çʵå Property¸¦ ¿­¾î Summarized Item¿¡°¢°¢
:dr_cash_amt1,:dr_tran_amt1, :dr_cash_amt1,:dr_tran_amt1·Î °íÄ£´Ù
4. Post Query¸¦ ¿­¾î
:dr_cash_amt1 CASE :slip_div WHEN '10' THEN :dr_cash_amt ELSE -:cr_cash_amt END;
:dr_tran_amt1 CASE :slip_div WHEN '10' THEN :dr_tran_amt ELSE -:cr_tran_amt END;
:dr_cash_amt1 CASE :slip_div WHEN '10' THEN :cr_cash_amt ELSE -:dr_cash_amt END;
:dr_tran_amt1 CASE :slip_div WHEN '10' THEN :cr_tran_amt ELSE -:dr_tran_amt END;
¸¦ Ãß°¡ÇÑ´Ù.
5. ÄÄÆÄÀÏÇÏ°í ³¡³½´Ù.

Àμ⹰ÀÇ ¼öÁ¤

1. ÃÖÇÏÀ§ ±×·ì¿¡ FormulaÄ®·³ ³×°³¸¦ ¸¸µç´Ù
2. À̸§À» CF_cr_cash,CF_cr_tran,CF_dr_cash,CF_dr_tran·Î °íÄ¡°í
3. °¢°¢ÀÇ PL/SQL¿¡
return CASE :slip_div WHEN 'Á¤»ó' THEN :cr_cash_amt ELSE -:dr_cash_amt END;
return CASE :slip_div WHEN 'Á¤»ó' THEN :cr_tran_amt ELSE -:dr_tran_amt END;
return CASE :slip_div WHEN 'Á¤»ó' THEN :dr_cash_amt ELSE -:cr_cash_amt END;
return CASE :slip_div WHEN 'Á¤»ó' THEN :dr_tran_amt ELSE -:cr_tran_amt END;
À» ¾Ë¾Æ¼­ ÂÉ°³ ³Ö´Â´Ù.
4. G_1 ±×·ìÀÇ Summary Ä®·³ÀÇ ¼Ò½º¸¦ CF_cr_cash,CF_cr_tran,CF_dr_cash,CF_dr_tran·Î
¾Ë¾Æ¼­ °íÄ£´Ù.
5. ³¡