Sun. Oct 24th, 2021

Requirement: In an Interactive Report in Oracle APEX, if the cell does have any value or say it has NULL, then in such cases, the cell is display with dash (-) instead of the NULL or blank.

Thus, now the requirement is, we should not display the cell with dash (-), instead the cell should be shown blank.

Screenshot of the problem statement: Here we will have dash (-) displayed in the cell instead of blank for NULL.

Screenshot of the solution: Here it will simply display the cell as blank for NULL.

Solution: For solution of the above requirement follow the steps as shown below:

Step 1: Go to the Interactive Reports

Step 2: Click on Attributes > Go to the Property Palette > Appearance > Go to the Show Null Values as property.

By default the value for Show Null Values as property is as below. That is it has a dash (-) in it.

Step 3: Simply remove the dash (-) and instead keep it as blank.

Step 4: Save and run the application. Thus, the ran application will now display blank instead of dash (-) for NULL cell.

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 965 total views,  2 views today

By Susanto Paul

Susanto is an Oracle ACE, a qualified MCA, MBA, and a highly-skilled Senior Oracle Specialist. He is an enthusiastic Blogger and YouTuber who helps learners to solve their complex problems more efficiently. He has 9+ years of experience in multiple technologies like AWS, Oracle ADF, Oracle APEX, Oracle JET, Oracle VBCS, Oracle IDCS, Oracle PL/SQL, Oracle Integration Cloud, Java, JDBC, Servlets, JSP, Spring, Hibernate, HTML5, CSS3, JavaScript, TypeScript, NodesJS, Angular, MySQL, Oracle WebLogic Server, JUnit, JMeter, Selenium Web Driver, etc. He is a certified: Oracle Certified Professional Java SE 6 Programmer, Oracle ADF 11g Certified Implementation Specialist, Oracle Cloud Platform Application Integration 2020 Certified Specialist, Oracle Cloud Infrastructure Foundations 2020 Certified Associate, and Oracle Cloud Infrastructure Developer 2020 Certified Associate

Leave a Reply

Your email address will not be published. Required fields are marked *