danblackhurst Posted November 30, 2009 Share Posted November 30, 2009 Hi, I have come across a problem were by I need to access rows ahead of the current detail row. They way I attemted to do it was to copy the current row into an object and then display 3-4 behind dependant on some logic. This got incedibly messy and in the end I abandoned it.As far as JRDefaultScriptlet describes you dont have access to such a thing. Does anyone know any different or has anyone rebuilt jasper to provide this functionality succesfully? Thanks, Dan Link to comment Share on other sites More sharing options...
Teodor Danciu Posted November 30, 2009 Share Posted November 30, 2009 Hi, It depends on what kind of data source you have. If it is a data source that wraps in-memory arrays or collections, you could access records ahead.If it is not, and you just have a query, then you simply need to create a custom query executer which produces a custom JRDataSource which is able to fecth records in advance and give you the posibility to access them. I hope this helps.Teodor Link to comment Share on other sites More sharing options...
danblackhurst Posted November 30, 2009 Author Share Posted November 30, 2009 Hi, Im using a MYSQL data source. Just had a breif look at the Jasper Ultimate Guide and it does mention a QUERY EXECUTER API and SQL QUERY EXECUTER. Would this require implementing all of the interface methods? Also do you know where I could find some more detailed examples of this? Sorry little new to the Jasper project. Thanks for your response, Dan Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now