Oracle Application Express (MOSC)

MOSC Banner

Refreshing dynamic column headers along with data

I have written a faceted report for actuals v. budget for up to the last years, including current year[CY].

facets include department, period_year and period_num[month]. rows are by period_num

I dont want to hard code the column headers, so using dynamic column headers so the reports would auto-update as years change — for column headers

so i created page items for each year e.g:

P34_CY has attached sql: select extract(year from sysdate) from dual

p_34_CY1: select extract(year from sysdate) - 1 from dual and so on…

the column headers label will be defined as: &p34_CY. YTD_NET, &p34_CY1. YTD_NET…

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