Showing posts from May, 2024
1. Grand/Group Sum Advanced : <?sum(current-group()/ DEBIT [.!=''])?> Group Amount in Word: <?xdoxslt:toWordsAmt(sum(current-group()/ DEBIT [.!='']))?> taka only. ------------ Advanced : <?sum( DEBIT [.!=''])?…
SELECT EMPNAME,ZONE_NAME, case when ATTN_IN IS NOT NULL then '<span class="info" style=" text-align: center; letter-spacing: .3px; display: inline-block;padding: 0.4rem 0.66666667rem;line-height: 1;padding-right: 0.6em;padding-…
Step-1: ===== Create Report Parameter Items. And Create Region PLSQL Dynamic Container. PLSQL Code : htp.p(' <!--div id="div_print2" align="left"-->'); HTP.P('<div id="printableArea" style=&quo…
Step-1: ===== Create Classic/IR Report For Master. (Department List) SQL Query : Select A.DEPARTMENT_ID, A.DEPARTMENT_NAME, NVL(B.QTY,0) QTY, A.DEPARTMENT_ID report FROM DEPARTMENTS Step-2: ===== Create Item : P9_DEPT_ID_FOR_EMP_LIST And Creat…
Step-1: Create Classic Report. SQL Query : Select EMPLOYEE_ID , DEPARTMENT_ID , FULLNAME , EMAIL , PHONE1 , PHONE2 , NID , PERMANENT_ADDRESS , PRESENT_ADDRESS , BASIC_SALARY , null X From EMPLOYEES WHERE EMPLOYEE_ID= 1003 Ste…
Step : 1 ===== Create Button Step : 2 ===== Go to Page Inline CSS -->> #retailbtn , #camp , #gold , #order , #delivery , #retailsales { height: 80px; width: 100%; } #retailbtn,#retailsales { border-radius: 12px; cursor: p…
Step: 1 ===== Create IR Report And Entry Form Same Page. Step: 2 ===== Select Entry Form. Appearance : Template : Inline Dialog Step: 3 ===== Create Button. (New Entry) Dynamic Action: Name : New_Department_entry Event : Click True Actio…
Select Report Region PK id Column (Ex: Department_Id) HTML Expression : <a href="javascript:$s( 'P9_DEPARTMENT_ID ','# DEPARTMENT_ID #'),$s(' P9_DEPARTMENT_NAME ','# DEPARTMENT_NAME #')"># DEPARTMENT_I…
Step : 1 ====== Create PL/SQL Dynamic Content. PL/SQL Code : HTP.P('<!--DOCTYPE html-->'); HTP.P('<html lang="en" dir="ltr">'); HTP.P('<head>'); HTP.P('<meta charset="U…
