Updating saved adhoc report

[mhl]

I'm using JasperServer Pro 3.5.1.  I want to know if there is some way to update a saved adhoc report that was created thru a topic report if the topic report is changed.  For instance, in the sample topic reports included in JasperServer Pro 3.5.1, I created a 'Sample Report' derived from 'demo for adhoc' topic report.  I updated the queryString in the jrxml of 'demo for adhoc' topic report and uploaded it in jasperserver. Is there some way that the queryString in 'Sample Report' will also get updated?

[mrcaffeine]

Not as far as I know. As soon as you save the report a copy of the topic is stored as report resource. this prevents the report from being broken caused by future changes of the topic. The query is directly related to the contained topic - not a copy of the topic's SQL.

[swood]

You could create a Query object in the repository, and have multiple reports refer to that query. Then when the query is changed, all reports access that Query will pick up the change.

 

Sherman

Jaspersoft