Blog / Oracle Application Blog
RUPEE SYMBOL IN REPORTS IN ORACLE APEX 4.2 USING HTML
Most of the Applications includes Accounts Reports like Employee Payroll Reports, Company Purchase Reports, Invoice Reports,etc. Now using this method user can add RUPEE symbol in your reports.
Step 1: Create Report (Interactive Report (or) Classical Report)
Step 2: Place the below SQL Query in Report Region Source
SELECT ‘<span style=”font-weight:bold;”>?</span>’
|| ‘ ‘
|| CASE
WHEN NVL (SUM (amount), 0) = 0
THEN ‘0.00’
ELSE TO_CHAR (NVL (SUM (amount), 0), ‘99999999999.99’)
END amount
FROM reimbursement_dtls
OUTPUT: