Description:
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:
Summary:
This Post explained what the steps should follow to create a rupee symbol in reports in oracle apex 4.2 using HTML.
Queries?
Do drop a note by writing us at contact@staging.doyensys.com or use the comment section below to ask your questions.
