I would like to put a “last modified” date in the header or footer of my Base reports. I can source this date from a simple table in the database (mySQL) or a SELECT query from some of the bigger tables. However it seems that Report Builder works with only 1 data source (query or table) so do I really have to put the “last modified” date into every record of every table or query for my reports?
Or is there an undocumented “LastModified()” function like Pagenumber() & Pagecount()? I can find no way to create one.