1. Grand/Group Sum
Advanced : <?sum(current-group()/DEBIT[.!=''])?>
Group Amount in Word: <?xdoxslt:toWordsAmt(sum(current-group()/DEBIT[.!='']))?> taka only.
------------
Advanced : <?sum(DEBIT[.!=''])?>
Grand Total Amount in Word: <?xdoxslt:toWordsAmt(sum(DEBIT[.!='']))?> taka only.
2. Report Call in apex:
--> Create Report parameter items And Button.
--> Select Button And Create Dynamic Action.
--> Execute PL/SQL Code:
BEGIN
NULL;
END;
--> Item To Submit : All parameter items
--> Again Button Dynamic Action
--> Execute JavaScript Code:
window.open('f?p=&APP_ID.:0:&SESSION.:PRINT_REPORT=Cash_Receipt_Voucher','_blank');
=============================================
Modal Open BI Report
==============
Step :1
=====
Create Blank Region. Modal Dialog
Region Type: URL
URL: BI Report Query URL Copy to Paste
Inclusion Mode: width="1300" height="900" frameborder="0" dependent="yes" scrollbar="no" top="0" left="0" resizable="no" toolbar="no" <span id="title">SAK Consumer product Ltd.</span>
-->Create Parameter Items. (P14_P_ID)
Step :2
=====
Create IR report and null column add.
null column type: Link
Target: P14_P_ID = #ID
Link Text: <span class="fa fa-print" aria-hidden="true"></span>