ireport

How to call a stored procedure from iReport?

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! ...

Inclusion and exclusion of subreports (IReport-Jasper)

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. ...

How to create sub-reports using XML DataSources in Jasper?

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...

Break the PDF document after 100 pages

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? ...

Using Jasper Report

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. ...

Subreports within a subreport (IReport-Jasper).

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. ...

How to configure iReport 3.5 for JasperReports compatibility with lower versions ?

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. ...

iReport and Hibernate.. trying to understand please and thank you!

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 ...

How to run iReport-nb 3.x.x from whithin another java application?

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...

Can anyone show me good tutorial about how to make complex iReport reports and exporting them to browser ?

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 ?. ...

Subreport within Subreport

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 ...

understanding JasperReports and JRBeanCollectionDataSource...

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...

Access to report parameters from a custom JRDataSource

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...

JasperReports JRBeanCollectionDataSource still confused...

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...

stucked with Getting null values in iReport,JasperReports,Strts 2 plugin , what is the problem ?

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...

iReport: Sub-reports using XPath (XML Data Source) show up blank

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...

How to query multiple SUMs of the same item using SQL in iReport

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 ...

Labels overlapping in jasper report pie chart

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. ...

Does JasperReports/iReport work with Hibernate annotations?

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? ...

How can I extract and use images from an archive in a Jasper report?

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...