Skip to Content

Suppress only the maximum line value

I have a report that I am filtering out certain values. In the details section I would like to only show the highest valued that is associated with the highest line. I have tried the suppress option in Selection Expert>Suppress (No Drill-Down) and put in this formula:

if {NOTE_EDIT_TRAIL.LINE} <> maximum({NOTE_EDIT_TRAIL.LINE}) then true

else false

This will suppress values that should not be suppressed. I think what is happening is there are higher values associated to the record that I am filtering out in my Select Expert. Should I use a whileprintingrerords formula?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 31, 2016 at 01:30 PM

    Hi Doug,

    Here's what you can try:

    1) Insert a Group on a primary key field

    2) Go to the Record Sort Expert and insert a 'Descending' sort on the LINE field

    3) Place all fields on the Group Header

    4) Suppress the Details section

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded