I'm trying to call a stored procedure that receives a parameter from the iReport plugin wizard of Netbeans 6.1, how can I successfully accomplish this task? Other technical details are: using MySQL 5.0.51a-17, and iReport designer 1.0. Thanks! ...
Just needed to include or exclude a subreport based on a condition when using IReport tool to create Jasper reports. I.e., if a subreport has values, I need to include that subreport, otherwise not. Can anyone please send a sample or tell me how to resolve this. thanks in advance. ...
I'm using iReport and I need to create a sub-report usign a XML DataSource. I will have only one XML for the hole report. Something like: <question> <text>What do you think about SO?</text> <options> <option>Like it</option> <option>Really like it</option> <option>Love it</option> </options> </question> The main repo...
I am working with Jasper and iReport tool. One of the requirements the client wants is that the PDF file will be generated to a 100 page document only. Could you please help me? How can I generated the 100 page PDF document? ...
I am using JSP/Servlets to integrate the JAsper report tool to generate reports in 5 different formats. After getting the output in the HTML or Excel format, Can we sort the fields of the table so that the page is dynamic? I am not sure how to do this since Jasper is already called using servlet and the data is filled. ...
Hi, I have a requirement that needs to have a subreport within a subreport. Is there a sample code which I can refer? Thanks in advance. ...
Hello, Could somebody please tell me how I can configure iReport 3.5 (nb) to use "compatibility mode" and generate report XML for lower versions of JasperReports, ie JasperReports 1.x syntax ? iReport 3.0 had this feature, and now I can't seem to find it in 3.5. Thank you kindly for any responses. ...
Okay, so I've got iReport up and running, and I can now run HQL queries in it, and it will fetch back objects, and put them in the Fields section of the Report inspector. Do I really need to flatten out all my queries so that I only return one "level" of actual data values, and not my entity objects? I'd rather like to just return the ...
Hi, I'd like to start using iReport (netbeans edition) and replace the good old classic iReport 3.0.x. Seems like the classic iReport won't be improved anymore and abandoned at some point. The point is that I need to start iReport from another java application. With iReport 3.0 it was pretty easy and straightforward: just invoke it.bu...
Hi all, I am working on iReport in netbeans IDE . I want to make reports that can be exported in browser in any pdf or excel format . Can Any one show me a good tutorial or solution ?. ...
Hi, I need to create a sub-report within a subreport, I'm using xpath as my query language. Any suggestion on how I can create it. To Illustrate it: Line Details -> 1st sub-report Line Detail Info -> 2nd sub-report Each Line Details can have >1 Line Detail Info. Thanks ...
I now have my jasper reports working from my JRBeancollectionDataSource in my code! I am just a bit confused about some things... When I am designing reports in iReport, I create the fields from a query, which I can do fine and all, since when I am actually running the query I'm using a a code JRBeanCollectionDataSource and so is the h...
I wrote a JRDataSourceProvider and a JRDataSource in order to access a "crippled" JDBC resource from iReport (it's an HP3000 database and the JDBC driver I am using does not support parameters in PreparedStatements, which iReport's standard JDBC datasource seems to require). My JRDataSource needs to access report parameters. How do I do...
So I do now have my working and filling reports. The users of my program can now pass objects from the program to a report object and fill it using the JRBeanCollectionDataSource and that does work. However I can't get all the data in the report I want. I am just very confused about this, how the fields that I declare with a name and...
I am using jasper reports and Struts2 to make to make some reports in my web application . I am doing all this stuff with NetBeansIDE and iReport 3.5.1 plugin for designing purpose. I am configuring my struts2-jasperreports plugin by following xml code. <result-types> <result-type name="jasper" class="org.apache.stru...
Hello, I am using iReport 3.5.2 to create a report using an XML data source. I followed the "Step by step" example from the "Sub-reports" section of "The Ultimate Guide to iReport", and I was able to get the example working with SQL. However, when I try to use an XML data source and XPath, the sub-report comes out blank in the master r...
I'm creating a JasperReport using iReport, and as such, I'm limited* to one SQL query. I have a table 'statistics', with a 'name' (VARCHAR), 'count'(INTEGER), and 'datetime'(DATETIME) columns. It is simple enough to get the sum of the 'count' column when the 'name' was "test" for the last day, and similarly for the last week, and month ...
I am using iReport 1.3.2 The labels in the pie charts are overlapping. Is there any setting in iReport by which I can prevent this? I cannot do any code changes at the moment, therefore, I can only use iReport settings/tweaks to achieve this. Any help will be appreciated. ...
I'd like to integrate existing application with JasperReports. However, when creating report with iReport the wizard is asking me for hibernate.hbm.xml. Since I'm using annotations I simply don't have one. Does iReport work with Hibernate annotations? If so, how can I configure iReport? ...
I need to put images in my Jasper reports that match rows in a database. I have the image data in proprietary archive files which I can easily extract in Java code. I need to know how to connect my Java code to the Jasper report to make the extraction process happen, something like BIRT's onRowSets() method. (I need overview documentatio...