Last modified date in Base report

[branestawm]

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.

[Ratslinger]

You are correct about one data source in Report Builder and there is no LastModified() function.

Having looked around at various other Report generators for LO Base, the one I find which allows multiple data sources is DataVision: click here. It hasn’t been updated in a while (good or bad?) but seems to work pretty well. Allows multiple table sources but not queries. However it does use Views so that should take care of the query problem.