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:
Recent Posts