Jump to content
Changes to the Jaspersoft community edition download ×

PASSING A SQL SENTENCE To A REPORT by PARAMET


Recommended Posts

By: mar - jjmarin

PASSING A SQL SENTENCE To A REPORT by PARAMET

2003-11-10 07:47

Hello we are already here again with another problem, I before nothing forgive my groins. You are that I need to substitute the SQL sentence that takes a report, pass it from JAVA thanks to the JASPERREPORT bookstores. I would like to know if one could carry out this operation without having to carry out the change physically on the XML file, by PARAMETERS, and so speed up the JAVA code and give you better humility to the report that I am carrying out.

 

it is say, what I need am pass the SQL sentence via parameter to the [report].

 

Or the only way is modifying the XML file and the label< [queryString]> substitute it for the SQL sentence so that everything works how it is owed.

 

Thank you and pardon for my groins

 

 

 

 

By: Ryan Johnson - delscovich

RE: PASSING A SQL SENTENCE To A REPORT by PARAMET

2003-11-11 09:30

In my reports, I never use the [queryString] - I always use a custom datasource that my Java code fills and hands to the report.

 

That way, the report doesn't need to worry about where the data comes from - that's the application's job, not JasperReport's job!

 

If you would like to see the code for the custom datasource, let me know

 

Ryan

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