BI Publisher (MOSC)

MOSC Banner

BI Publisher 'first' and 'last' column summary functions grab null values

edited Oct 18, 2019 5:02AM in BI Publisher (MOSC) 3 commentsAnswered

As the title suggests, I have discovered that the 'first' column summary function will always grab the first value, regardless of if that value is null or not. Same with the 'last' function. Compare this to the behavior of Oracle Reports where the first/last function grabs the first/last non-null value. Is there a way to change the default behavior of these functions, or ideally change it on a case-by-case basis for each data model?

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