Evaluate Consulting Services

Month: January 2021

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1: Go to page footer and copy and paste the below script. <fo:page-number>: This is the object, which is used to represent the current page-number. Step 2: Load the XML and preview the result. Output: That’s it. References:

Oracle APEX Chart Conditional Bar Colors

   Here I am giving an example to change the chart bar colors based on the conditions in Oracle APEX. Step 1: Create a new blank page. Step 2: Create a bar chart region and your bar chart series query would then look something like this, SELECT fund_id,         fund_name,         to_char(start_date,‘DD-Mon-RRRR’) start_date,         case when percent_complete >= 75 then ‘#d1f5e0’ –light green             when percent_complete >= 50 then ‘#fff4dd’ –light orange             when percent_complete <= 50 then ‘#fdd5cc’ –light red        else ‘blue’         end as color,        percent_complete …

Oracle APEX Chart Conditional Bar Colors Read More »

Embed a Tweet/Timeline to your Oracle APEX Application

  Embed a Tweet:  Note: Embedding Tweets is only available via twitter.com. Step 1: Click “…” the icon located within the Tweet. Step 2: From the menu, select Embed Tweet. Step 3: This will open publish.twitter.com where you can customize the look of the embedded Tweet by clicking set customization options. Step 4: Once you like the look of the embedded …

Embed a Tweet/Timeline to your Oracle APEX Application Read More »