adamb

Both iReport and JasperServer are free to download and use. The only thing that costs money are documents that explain how to use them. You can download the applications at the following links: http://jasperforge.org/projects/ireport http://jasperforge.org/projects/jasperserver The only exception to what I said above is that there is a premium version of Jasper Server, but the prices aren't well defined on the website. You can find more information here: http://www.jaspersoft.com/reporting-server My company uses the free version of Jasper Server (and iReport) and that suits our needs great. Post Edited by adamb at 10/13/2010 13:55

bump

That makes sense to me in theory, but I do not know how to accomplish this in practice. How do I pass some data from a main report to a subreport? If you have an example that would be great. Post Edited by adamb at 09/29/2010 17:04

@kingananth007, thanks for the reply, but I don't think I was clear in my first post. My report is pulling XML data just fine, and using it. However, I only have access to the highest level of data (ie FIRSTNAME, LASTNAME, etc.). My problem is that I need to access both the high level data such as /DATA/FIRSTNAME and be able to iterate through the lower level data (/DATA/ACCOUNTS) in the same report. I tried to achieve this through a table, but couldn't get that to work. Has anyone had better luck with a table? Does anyone know of a way to do this? FYI: I've done this by using a sub report, but the problem is that it calls the database twice, which is doubling the report production time, which I really want to avoid. Post Edited by adamb at 09/27/2010 15:21

I have an XML datasource to a report that looks like this: <?xml version="1.0"?><DATA> <FIRSTNAME>JOHN</FIRSTNAME> <LASTNAME>SMITH</LASTNAME> <PHONE>555-555-5555</PHONE> ... <ACCOUNTS> <ACCOUNT> <NUMBER>5689</NUMBER> <NAME>Account #1</NAME> <BALANCE>111.22</BALANCE> ... </ACCOUNT> <ACCOUNT> <NUMBER>5690</NUMBER> <NAME>Account #2</NAME> <BALANCE>57.85</BALANCE> ... </ACCOUNT> </ACCOUNTS></DATA> The report works great for everything except the account data. Basically, I want a front page that has the non-account data (FIRSTNAME, LASTNAME, PHONE, etc.) and then on the last page I want to list the accounts and their details. So far I've been designing the report using iReport, and I cannot get that account data to be displayed at all. Any ideas would be much appreciated. Thanks!

I've created a PHP based Jasper Client, and it has worked great until now. The problem I am having now is that when I try to get a report with a barcode in it, it doesn't work from my PHP Jasper Client. I can, however, call the report from iReport and get the report just fine. I would appreciate any insight into this problem. Thanks! P.S. Here is some information that might be helpful: When I try to get a report from my PHP Jasper Client I get this error in my Jasper Server logs: java.lang.NoClassDefFoundError: org/w3c/dom/xpath/XPathEvaluator I do not get the above error if I call the same report from iReport My PHP Jasper Client can return any format supported by JasperServer and works well with input parameters I had to add the BarCode4J jar to my JasperServer in order to get those barcodes to work Post Edited by adamb at 08/02/2010 19:51

I wanted to point out all that I did in order to get this to work because throughout the process of getting this to work I wasn't ever able to find all the answers in one spot, so here is the summary of what I did to make remote XML work on Jasper Server: Get some way to produce XML. Perhaps your database already outputs in XML or perhaps you have to write a little web service. Either way you will want to have some sort of address to point Jasper too, I used a web service through apache so it had an http://serviceAddress type of address. If you intend on passing in dynamic information to your database, such as a select statement or other parameters you need to set special parameters in the report itself. The parameters must begin with "XML_GET_PARAM_". So if you wanted to pass a variable on the GET string through http named frank, you would make a parameter called "XML_GET_PARAM_frank". Patch the server to work with remote XML. As far as I understand, this only works for Jasper Server ver 3.7.0. There are two things you must to do make this work: Patch Jasper Server ver 3.7.0 with the remote XML patch Install the xpath2 jar on Jasper Server Setup the remote XML datasource. If the patch has worked correctly, when you log into the JasperServer web interface, you will have new options when you make a new datasource (see attachment 1: ds.png). You will most likely want to use "XML File data source" option and follow the wizard. You may need to tweak settings to get the XML to work correctly, but that depends on how you've setup your XML to work. Deploy. When you deploy your report make sure that you chose the new datasource on the server that you made in step 3.I hope that helps, good luck!

Awesome link Lucian, that was perfect. I don't think I would have found that without you. Thanks!!!

At my work we use a proprietary database and I am trying to figure out the proper way to connect to it through JasperServer. In order to have Jasper talk to my proproetary database I made a web service that returned an XML response. This seemed like a good idea at the time because I saw that iReport has a way to connect to that. After designing the report and using the XML web service, everything works great locally. However, I cannot get it to work on the server, in fact I cannot even define a "Remote XML Datasource" on the server. Am I going about this the wrong way? Is there a way to get Remote XML on JasperServer? The XML web service is just opening a socket to the database application, so is there a better way than the XML route? Thanks in advance.