tarelr

I think, your topic is not in the right place, cause it is a SQL problem and is not a jasper issue. For information,see the query: Code:select table1.schoolName,table2.studentName from table1,table2 where --the joins clause table1.schoolId=table2.schoolId

You can group your pdf files . Take a look to this topic: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=22154#22154 Today , i found no way to set consécutive page number acrosss all pdf files.

in your jrxml file, how do you call your parameter queryString? Be sure you call le the parameter with the $!P{} synthaxe.

hi Rob, You can do that you want under a java app. This was explain in this topic: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=22154#22154 Choose the exporter you want. In this case pdf, there many more. Rémi

update [file name=MutliAxis_iReport.jpg size=34121]

hi, I encountered some problems when using MultiAxis Chart. With the same .jrxml file and the same datasource , i got different reports between iReport and my Java application. My MultiAxis charts is composed of a Line Categorie Chart and Stacked Bar Categories Chart. With iReport, all runs fine, i got the report i wanted. With my java application , the Stacked Bar char is rendered fine but the Line Chart was only rendering the last categories. After sereval tests i made, it appears that the first chart( in my case the Line Categories Chart) defined in the Multi Axis Chart List did not render well, just the last catogories of the dataSource. I found no way to bypass this problem. i checked all the library , the 2 environnements had the same version of each library. I dont understand why i can t be able to generate a report with multiAxis chart. Please tell me , if you have ever succeeded to use multiAxis chart in a java application. Any help would be great for me. [file name=MutliAxis_myApplication.jpg size=63604] Post edited by: tarelr, at: 2007/03/09 14:39

hi, Jasper provide this functionnality . You have to create a list of JasperPrint object : Code: List jasperPrintList = null; JasperPrint jasperPrint = JasperFillManager.fillReport(inputStream, jrParameters, jrDataSource); jasperPrintList.add(jasperPrint); and to export, just set an exporter parameter like this : Code:[code] // Generate the global report. final JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT_LIST, jasperPrintList); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream); exporter.setParameter(JRPdfExporterParameter.IS_CREATING_BATCH_MODE_BOOKMARKS, Boolean.TRUE); exporter.exportReport();

hi guys, i'm working on a report that needs sub report. The problem is: i get my master datasource and sub report datasource from Oracle resultset from my java application. i want to get dynamic data source for my sub report (depends on one master datasource's field) needed for each row of the master datasource. I can't work with the "Filterable JRDataSource " (like explain here http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=4450#4450 because JRResultSetDatasource doesn't implement the JRRewindableDataSource interface. do you get any idea? Ps: my english is quite bad, please don't blame me. EDIT: It would be very easy if I could execute sub report query with Jasperreport engine. Post edited by: tarelr, at: 2007/02/05 16:08