Ask Your Question
1

Last modified date in Base report

asked 2016-07-03 18:04:27 +0100

branestawm gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-07-14 03:01:25 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-07-03 18:04:27 +0100

Seen: 85 times

Last updated: Jul 14 '16