Jump to content
Changes to the Jaspersoft community edition download ×

How to get report SQL / intercept filling ?

2004 IR Help

Recommended Posts

By: Martin - mbuch

How to get report SQL / intercept filling ?

2005-09-13 07:42



I would like to intercept the report filling and retrieve the report SQL command Jasper will send to the database. This must be done after setting the parameters. After parsing the SQL the filling process has to be stopped under certain conditions.

Any ideas how to do that, eventually without changing Jasper sources ?












By: Matihost - matihost

RE: How to get report SQL / intercept filling

2005-09-13 08:04

You cannot stop filling report but you can stop showing its effects, setting <printWhenExpression> on details band.


You can do similar effect before filling report. You can get query from JasperReport object (getQuery()) and if it contains parameters replace them by its values myself. And then you can choose to generate report or not.


I hope this helps.


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...