Jaspersoft Community 'Read-Only' as of July 8, 2022
Transition to New TIBCO Community Just Weeks Away
You can still search, review wiki content, and review discussions in read-only mode. Please email email@example.com with questions or issues requiring TIBCO review or response.
is it possible to use a sql alter table statement in a report?
Have to change a View before receiving Input through another query in a subreport.
JasperServer has a security setting that will only allow select statements to be sent trough the JDBC connection. That can be configured or disabled (Not Recomended) in webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties/validation.properties
Still I do not think that sending an 'Alter table' in a report is a good practice, and must be avoided, this is a Reporting Tool :) Imaging somebody ading a DROP Table or TRUNCATE in your report :P. I will strongly encourage you to rethink the problem you are trying to solve.
I'm the only one who can change the reports on the jasperserver. So there is no problem with it ;) You have to know that I use mysql-Views to simplify my queries. Also the Report depends then only on the view and not on many other tables which can change.
My Solution: I wrote a Scriptlet with an alter-querie :)
But thanks for your help!