jaumeg Posted October 10, 2006 Share Posted October 10, 2006 Hi all, I have a doubt and I'll appreciatte any help. I have to Select from various Sql Tables and I have to Order an sql result variable with the Last two digits, so I can not do it with a Standard SQL Sentence. I have to make a program that with the result of this select, substring this variable and then create another one with only two digits, etc etc,.. Well, my questions are : Can I pass an ArrayList (LinkedHashMap) for example to the fillreport or I need always to pass the sql Sentence and the connection ? Can I create a LinkedHashMap (Ordened fields) and pass it to the JasperFillManager.fillReport ? is It possible to pass the result of a Select without passing the Connection to the JasperFillManager.fillReport ? What I mean is that I need to do some extra programings after passing the parameter to the Jasper Engine. Sorry for my English. Thank you in advance for your help.. Link to comment Share on other sites More sharing options...
rsilverns.sympatico.ca Posted October 10, 2006 Share Posted October 10, 2006 If you create a custom data source you can pass it anything you want. You could run your SQL query in your java program then do the custom ordering and pass this list into your data source. Check out the JRBeanDataSource and other collection based data sources also. Link to comment Share on other sites More sharing options...
jaumeg Posted October 18, 2006 Author Share Posted October 18, 2006 Yes , thank you ! Problem solved.. Link to comment Share on other sites More sharing options...
jaumeg Posted October 18, 2006 Author Share Posted October 18, 2006 Yes , thank you ! Problem solved.. 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