martynhiemstra

No there isnt. Somehow the person who created the query designer didnt designed it to work with joins.

As far as I know executeQuery in ResultSet is called. This only accepts Select queries. If you try a UPDATE in executeQuery then you get an error. Why dont you try it yourself? You can create your own jrxml file with an update or truncate query. I find it much more satisfying doing something myself instead of asking others. In the time it toke you to get a response you could of found out for yourself so getting an answer is also faster.

Pass the variable onto the subreport as a parameter. You can set the return value to that same variable for that sub report. Read the iReport manual on how you can do this or search these forums, since it as been answered so many times before.

This has nothing to do with not saving passwords, xml databases or active connections. This is a genuine BUG in iReport. It has been in there since at least 2.0.1. I have tried everything. I even tried a simple query SELECT * FROM {RANDOMTABLE} but nothing. Connection test works fine. The query is OK and the connection is the active connection. I even tried SELECT STRING_FIELD FROM TABLE since someone suggested that it might have to do with Date fields but that didnt work either. I can connect to the database using a client application and using that client I can execute the query perfectly. The fact that no error is displayed or thrown indicates a bug in iReport. Post edited by: martynhiemstra, at: 2007/11/21 12:44

Are you sure the xml you download is valid? My guess is that the xml isnt downloaded correctly or that it was saved corrupt or is being read corrupt. Your code seams correct so I dont think it's a code problem but more a xml problem or download problem. About the download process. If you do get corrupt xml files then that is something you will have to find out for yourself since that has nothing to do with Jasperreports. Then you will have to consult the manual of the application that downloads the xml files.

You can compile your jrxml report and then convert it using the xml exporter. You can search this forum how to do this.

Your story is clear now. You can compile the main report, and I beleive you can retreive a list of parameters from the compiled main report. You can get the name and class of the parameter. If you find a JasperReport class then you know you have found a subreport. You can then download the subreport with that name. This only happens if the previous user used subreports as parameters. It'a also possible to retreive a list of sub reports from the compile main report. But I'm not really sure about that one. You might have to analyse the jrxml file manually to get all the sub report names. After you download all the subreports you can read the ireport manual how to use subreports in the main report or search this forum how to best do that. It depends on how the previous user solved that problem.

To tell you the truth. I didnt understand a thing you said in the first part. Maybe you could improve your English a bit. It makes it easier to understand you. About this part: As regarding the Html, during the converting, how can I get the Stream of the html file and the directory and its files so that I can store them into the database. Maybe you misunderstand how the htmlexporter works. It doesnt save to a directory or save a group of files. You can get the html stream from the htmlexporter. It has an string buffer parameter Code: JRHtmlExporter exp = new JRHtmlExporter ( ); exp.setParameter ( JRExporterParameter.JASPER_PRINT, jasperPrint ); exp.setParameter ( JRExporterParameter.OUTPUT_STRING_BUFFER, stringbuffer ); You can then stream the stringbuffer contents to a remote server

No problem. I know what it's like when it gets late. These things happen. My response was out of frustration how many programmers with a clear mind with hardly no Java knowledge try and get jasperreports going. I really want to help people but when someone tries to fly a jumbo jet when they cant even drive a car that's just asking for problems.

It clearly says: java.lang.ClassNotFoundException: org.apache.commons.collections.SequencedHashMap If you had done some googling you would have discovered that you are missing the apache commons collection package. This, by the way has nothing to do with Jasperreports, and any programmer should know how to handle such an error before even grasping any project.

I am willing to help but first this. Please first learn how to program and use Java. This is a very simple and basic Java error. It says that it can't find a certain package, namely net.sf.jasperreport. If you had searched this forum or visited the jasperreport site you would have discovered that you need to put the jasperreport*.jar file in your classpath. This will solve the problem.

As far as I know, jasperreports generates pdf that cant have these limits. To do this you would need a special license from Adobe so that you may use a different version of pdf ( Where things are limited and allows editable fields etc ). This would make it impossible to release jasperreports for free since such a license is very, very expensive.

I can tell you now that you should stop generating reports with 500 000. I have reports with 25000 lines and that takes 30 seconds to generate imagine how long it will take for your report to generate. Second 1.6GB being swapped on you Harddisk will make the compile time even longer. If I was you I would really create a selection on your query.

You can compile the subreports and then pass them on as paramters. and if the output format is HTML, how can I get the inputStream of the folder and the other file so that I can store them to a remote server ? What do you mean? You want to send the html to a remote server. I dont know how you want to communicate with the report server ftp, samba etc.

The excel exporter now includes a filter option in 2.0.2 that allows filtering out headers and footers, actually any band you want. Therefore a seperate report per export option isnt needed. The class name is JROriginExporterFilter. This allows a solution where you only need to set it once in your code. lucianc's idee is great too but you need to add it to each report. Post edited by: martynhiemstra, at: 2007/11/14 13:59 Post edited by: martynhiemstra, at: 2007/11/14 14:15

The error is pretty obvious. It can't find the file D:MVCHospitalManagementwebreportsitem.jrxml. Verify the file exists. Where are your backslahes by the way?

(The system cannot find the path specified) The error is pretty obvious. It cant find the file D:MVCHospitalManagementwebreportsitem.jrxml. Verify the file exists and that the path is correct. Where are your back slahes by the way?

It has to compile the report first and then convert it all to swing. There is a big difference with normal Swing applications where the swing components are drawn directly (Position already known, size etc) and with the reports there is a more server load because of report generation. Post edited by: martynhiemstra, at: 2007/11/14 13:46

It depends on what kind of datasource you are using. If you are using a resultset datasource then it isnt possible. You will have to create your own datasource that extends JRDatasource. http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/JRDataSource.html I realized that it's also possible to do it differently. You can also set the print when expression field for the 3 different fields. The first field can be set to F${DEPOSIT_TYPE} == 1. The second field set to F${DEPOSIT_TYPE} == 2 and the third field set to F${DEPOSIT_TYPE} == 3. This will print the correct field according to the F${DEPOSIT_TYPE} field

Hi csshahie, I can tell you about my experience with Jasperreports. I love jasperreports simply because it's easy to use and also because I wrote my own web application to host the reports which makes me feel more involved with jasperreports. I was unhappy with jasperserver so I designed my own report server. Since then things have been going much better for me and my clients. Jasperreports can do alot, more than you think if you spend some time on it. For example designing your own datasource that will allow you to access the previous row of information etc etc. The jaspreport API is very useable. It allows export of pdf to a stream or a file. The same goes for excel and word export. The forum users are pretty quick to respond. Less than 1 dag response time for most questions. I have never used Crystal so I cant compare, but I wanted to share my expierence. Martyn

You will have to create a variable for each field (SQL column). Each variable must be set up to count the current value of a certain field in the current row. Set the variable expression to the field name, It's also best to initialize the value and set the calculation type to sum. Dont forget to set the reset type to group.

The error is clearly stated in this line of code: java.lang.NoClassDefFoundError: org/apache/commons/beanutils/MethodUtils It can't find the Apache Commons Beanutils. The url is http://commons.apache.org/beanutils/ Please this is very basic Java knowledge and has nothing to do with jasperreports. You can not work with jasperreports if you dont even know how Java works. These kind of error messages should be easly analyzed and should be easly fixed by any Java programmer. I am willing to help anybody with jasperreports but I expect some basic knowledge of Java.

net.sf.jasperreports.view.JasperViewer this package compiler not able to find This means that it cant find the jasperreport.jar file, that contains the jasperreport class files, in the classpath. If this is the error then please first take a course in Java programming. This is pretty basic knowledge. Read this for information: http://java.sun.com/j2se/1.3/docs/tooldocs/win32/classpath.html About your code, it looks alright. First fix the problem menthioned above and then try again. It should work then, if not post any new errors on this forum and I'll see what I can do.

Your situation is clear now. Is it possible to display html on the server? You could generate html using the HTMLExporter. How about loading a pdf on the server? Maybe you could generate a pdf on a samba share and then send the link to the pdf to the client. Apart from this I dont think there is a solution since you want all the work done on the server but the result send to the client. You could also try jasperserver. This is a web application that will allow you to host jasperreports and export them as well to pdf, excel and word. You can allow your clients to view the page.

You can't set the value of another field. You cant call the fields and set there values. You'll have to alter the data from the datasource to allow this.