I have been doing some research on trying to get a report in Discoverer that would give the latest Salary Change for the Salary History Table. We have a report where we would like to get the latest Salary for an Employee from the Salary History Table. We have a report on Discoverer that lists all of the Salary Changes. We want to get the latest change as of a certain date as well. I have read and tested using the MAX...KEEP sql statements. These do work and I get the resulsts in SQL that I want. However in Discoverer where would I place the sql MAX statement. I tried placing the statement in the conditions but it did not work and I got all the Salaries.
Thanks for any assistance that can be provided.