We are considering using Servoy to connect to a SQL database tracking manufacturing operations (BellHawk). The managers want to be able to create quick and easy reports showing trends of machine usage, productivity, etc, WITHOUT calling up a developer each time to configure the report. In Servoy, how would I, as the developer, set up their solution so all of it is locked except a reporting file in which managers can make their reports?
I'm coming from FM in which I'd use the SQL plugin to pull the data in (this file would be locked) and then export the data out to another table that would be open for users to play with, create reports, mess up, etc.
Thank you!