BI Publisher (MOSC)

MOSC Banner

How to Add a dynamically changing column header based on the year (ex. 20XX)

in BI Publisher (MOSC) 3 commentsAnswered ✓

For my BI Publisher report I need to have a column heading (not the report header) change based on the year returned by my SQL statement.

Example: the column header was hard coded in the past as 2018, then 2019 now 2020.

My modification needs to eliminate the hard code and dynamically change the last 2 digits of the year to 2021 when the report executes beginning 1/1/2021.

What do I need to do to make the last 2 bytes of the year dynamic? (ex. 20XX), as stated the year is returned by my SQL statement in the Data Model.

We have BI Publisher version 12C.

Thank you,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center