Jump to content
Changes to the Jaspersoft community edition download ×

How to create Dynamic query in Jasper

Recommended Posts

By: Pronab - pronabb

How to create Dynamic query in Jasper

2006-01-12 05:39

My requirement is like that:

From jsp(Frontend) user may select different columns to get the report.If user select 2 colums(UserID,UserName) and select pdf then on pdf file 2 columns will be displayed with data.

If user select 4 columns(UserName,UserAddress,UserId,Email)then on pdf/html it will display a report with that columns and sequence of columns also can be changed.



1.How will I send this dynamic columns(database table fields name) to Jasper?


Is it possible any way Using JasperReport and iReport tool


Please help me.





By: Denny Valliant - xenden

RE: How to create Dynamic query in Jasper

2006-01-12 22:00

What has worked for me in the past is to dynamically generate the XML for the report. I don't know of any way to do this in iReport or another GUI.


Tom has a project that might interest you: http://ussrp.sourceforge.net/


It isn't too hard to set up a jrXML "template" of sorts and then doing a find/replace prior to compile & filling, but it is not very scale-able.




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...