wegnerk

Hi, I have to generate a report which includes two different lists (the datasource is the same, so that's no problem). It should look something like this: (ColumnHeader) Name Adress CustomerId (DATA) (second ColumnHeader) Surname Lastname Birthdate Income ... (DATA) is something like this possible without using subreports or do i have to use them? (i wanted to know this before i start realizing it) I hope someone has a hint for me, because i can't yet imagine how to realize that report as required ;-) thanks in advance

hey Sherman, thanks a lot for your answer!!! that was exactly the information i was looking for ;-) Post edited by: wegnerk, at: 2007/05/11 07:49

Hi, i am a newby to jasperserver and i have to evaluate some possibilties for our new project... so, is it possible to use an oracle database for metadata / users and so on instead of a mysql database? When installing JasperServer, i can only choose to install mysql or to use an existing mysql db. Thanks in advance for your answers...

Hi, thats not a strange behavior, because the export to csv is gridbased... so you have to watch the alignment of the fields... look here for more information: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=8&id=23618#23618

is that really wanted? Code: InputStream reportStream = getServlet().getServletConfig().getServletContext(). getResourceAsStream( "/jrxmls/jasperreports_demo.jasper.jasper" ); seems not to find the correct file or did you get the output of Code:[code] System.out.println("Done Reading jrxml file !!!"«»);Post edited by: wegnerk, at: 2007/04/17 13:47

Hi alltogether... i have to make an overview over the possibilities that JR offers for Reporting and the question arose, if there is any possibility to use JR not with Java, but with other languages such as .Net or Ruby or something. Does anyone has experiences with this or ideas/meanings... and can share them with me? That would be great! Post edited by: wegnerk, at: 2007/04/17 13:56

You can use the printWhenExpression of the textfield. In IReport, go to the properties of the field and under "common", you can find it... the printWhenExpression needs a boolean value. for example: if you only want the field to be print when it is empty you could write something like: ($F{field} != null) (depends on the datatype, what you have to write exactly...)

look for IReport under projects...

linux and windows are both no problem, it is completely implemented in java... i don't know aix and as400, so i can't say anything about that.

you could set the response like this: Code: response.setContentType("application/pdf"); response.addHeader("Content-Disposition", "attachment;filename=report.pdf"); the bold part is the important thing, so you get a popup window which asks if you want to open or save the file. But it opens the pdf in the appropriate application, adobe reader for example. of course you can choose another filename... Don't know, how to open it in a new browser window... are you working with jsp or what? perhaps you could give the button a target="new" or something... hope this helps... Post edited by: wegnerk, at: 2007/02/07 13:39

it would be easier to understand your problem, when you post some code or more information here. do you get an error or something? if you have enough data, the report should not stop at 5 or 6 pages, i had some reports with more than 30 pages without problems...

We solved it by changing the sql-view itself, not the report... ____________________________________________________ Hi all... my problem is a bit complex, but i try to explain it, so i could be understood. I have three reports (monthly, quarter, yearly) which displays data for some forecasts. The structure is obvious; so in the quarter report the months are taken together in quarters; and in the year report, the data for the whole year is displayed (grouped). Now, it could be, that a month has a specific value, like "no forecast entered", which should be displayed in the monthly report like all the other values. But in the quarter or year report, it should only be displayed, when there does not exist another dataset for that quarter or year. If there are datasets for that quarter/year, the dataset "no forecast entered" should NOT be displayed. I tried it with a variable, which counts the real datasets in one year, but that does not work properly, because it is set too late for me. does anyone has an idea of how i could define that variable or something? i use jr 1.3.0 and a hibernate connection in a java web application. Post edited by: wegnerk, at: 2007/02/07 13:53

i also had that problem and for me, it worked like this: Code: PrinterJob job = PrinterJob.getPrinterJob(); PrintService service = job.getPrintService(); PrintRequestAttributeSet printRequestAttributeSet = new HashPrintRequestAttributeSet(); printRequestAttributeSet.add(MediaSizeName.ISO_A4); JRPrintServiceExporter exporter = new JRPrintServiceExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRPrintServiceExporterParameter.PRINT_REQUEST_ATTRIBUTE_SET, printRequestAttributeSet); exporter.setParameter(JRPrintServiceExporterParameter.PRINT_SERVICE_ATTRIBUTE_SET, service.getAttributes()); exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PAGE_DIALOG, Boolean.FALSE); exporter.setParameter(JRPrintServiceExporterParameter.DISPLAY_PRINT_DIALOG, Boolean.TRUE); exporter.exportReport();

the jrxml file is necessary, because this is where you define, what your report looks like. You can open IReport and generate a new report, where you can set your fields (database fields) and variables and parameter as you like. in java, that jrxml template is compiled and filled with data. If you really want to work a lot with jasper, it would be very good to buy the documentation or a book about it, because at the beginning it could be quite tricky...

Hi Yael, if you want to use jasperreports in your java-application, download JasperReports (the newest Version is 1.3.0), take the project.zip. the jar is in the DIST/subfolder. under demo/samples, you find some example reports with java classes and jrxml files, where you can see how to use jasperreports in java. For creating a report, install IReport, there you can visually design a report, create a database connection and query and test the report. hope, this helps a bit