Pentaho

 Report Designer: Can I run a UPDATE sql script

Ole Mygind's profile image
Ole Mygind posted 04-07-2022 17:05

I would like to be able to update a table from my report.

Is it posible to add a SQL containing an UPDATE command that is runned along with calling the report - or function added to a custom button - to accomplish this?

I have tried to incooperated an UPDATE command into my existing SQL scripts but it fails.