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:
I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle APEX .Actually I was looking for the same information on internet for Oracle APEX and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDeleteThanks for sharing this useful information this information will be very helpful for us.
ReplyDeleteLearn Oracle