Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to display Ordinal Number in small font in RTF Layout

Received Response
83
Views
2
Comments

Summary

Unable to display Ordinal Number in small font in RTF Layout

Content

Hi,

Am trying to display date in my report in the format "1st June 2017" which is of a rtf output but the system prints as 1st June 2017 instead. Can anyone guide me on how to get the rtf out with the format which am looking for.

Tried below options

<?xdoxslt:sysdate(‘ddth Month YYYY’)?>

to_char(sysdate,'fmddth Month YYYY')

Not able to get the required format.

Thanks,

Manju

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    You want SYSDATE to print like this or there is some other dates?

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    For this you need to add FO code to your rtf. Please split date in three formats 'DD', 'th' and 'MON YYYY', for all three add BI publisher tag and add the below code for each tag

    image

    DD : <fo:inline><xsl:value-of select="xdoxslt:sysdate('dd')"/></fo:inline>

    th: <fo:inline baseline-shift="super"><xsl:value-of select="xdoxslt:sysdate('th')"/></fo:inline>

    MMM YYYY:  <fo:inline><xsl:value-of select="xdoxslt:sysdate('Month YYYY')"/></fo:inline>

    Regards,

    Brajesh