In CR8.5 you could do an SQL expression field that would return a different value for each record.
For example a report showing a list of Films (film.id in the report) could have an SQL expression field to show the first date it was booked out.
(Select Min(LT."Start_Date") from LENDING_TABLE LT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.