ireport

why supreport overlapped by page header in ireport ?

I design a report in iReport with windows + weblogic, and there is a page header and detail column, and I place a subreport in the detail column. It works well in windows + weblogic! But when I deploy it to linux + weblogic, I found that whenever there is a new page in Detail column, the subreport content in detail column will be overlap...

How to make Jasper iReport groups start on new page only when needed?

Hi, I'm using Jasper iReport (output to PDF), and I have a problem with a certain report: Inside the report I have defined a group. On average, each "instance" of that group only contains a small number of detail rows, so I don't want each of them to start on a new page, since it would be a waste of paper (the output is printed on pape...

how to filter Lastname from a Fullname with the help of iReport

hi i am using iReport 3.7.3 and i am making a project, it has a field called-"Name" . it contains the full name of the Employees Ex.-"Robert Jones". i want to get the details of the Employees with the help of their Lastname Ex.-"Jones". is there any genralized query with the help of which i can get the details of all the Employees. ...

How sets the jdni.properties on ireport

hi i'm using ireport 3.7.2 with ejbql connection my problem is that when i test the connection, fails because Could not find datasource, in the log says: Caused by: org.hibernate.HibernateException: Could not find datasource Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property,...

Simple variable calculation in ireport

I am new to ireport. How can I do simple calculations like adding subtracting multiplications and dividing two variables and storing the result in the third variable. The result of thrird variable is to be displayed in report. ...

Can I make the Column section not expand to fill the page in iReport

Hi, If my report only generates a handful of rows of data (not pages, just rows) then I would like to have my totals row appear immediately after the last row of data, instead of being forced to the bottom of the page. How do I do that? I have tried a page footer and a column footer and they both appear at the bottom of the page rathe...

Jasperreport incomplete print page...?

The report is viewed correctly with SWTJasperViewer but when it's sent to printer from the SWTJasperViewer dialog, the printed document is incomplete. I can't find what's the problem. I need your help, please ...

How to make "High Low" chart with DynamicJasper?

Hi, I could not find a way to create a "High Low" chart using DynamicJasper 3.1.5 (it is available in iReport). Is it possible to make such chart type? Or, can this type of chart be simulated using some other chart type? ...

Rename the fields of ejbql query in ireport

Hi, im using iReport 3.7.3 with ejbql connection my problem is when i want get the fields from the query, the ireport sets the name of the fields with "COLUMN_1", "COLUMN_2" even if i use the sentence "as" the ireport get's me that name to the fields. Here's an example of my query select doc.docId as DocumentID, doc.transactionDate as T...

problem related to subreport in i-report with xpath

if i use 1st expressino given bellow then master report shows sub report with null value at every place ((net.sf.jasperreports.engine.data.JRXmlDataSource) $P{REPORT_DATA_SOURCE}).subDataSource(".") and if i write 2nd expression starting from main the root node then it shows my sub report blank 2. ((net.sf.jasperreports.engine.data.J...

Relative path for the Subreport

Hi, I'm working with iReport 3.5.0, and I'm using a subreport inside my main report. I don't want to give the absolute path for the subreport expression, but for example if I just give "bpSubReport.jasper" as the subreport expression (because sub and main are in the same directory), then iReport can find bpSubReport.jasper and compile th...

ireport run in client problem

I am using Ireport 3.0.0 in Eclipse. I call a servlet to show the Ireport viewer, but it shows my report in JasperViewer itself. My code: //////////////////////////////////////////////////// import java.io.IOException; import java.sql.*; import java.io.PrintWriter; import java.util.HashMap; import java.util.Map; import javax.servlet.Se...

Print label with repeating record using IReport (Jasper Report)

Use Case: Would like to use IReport to Label item sold in my shop. The thing with labels is that for each product there can be multiple items that need to be labeled. So let say product CarToy is 1 record in database (field name, description, price). Question: To label CarToy item in my shop I will have to print a report containing th...

each xml record created in separate detail band ,why ?

im fallowing the tutorial about the xsl datasource in the ireport site : IReport xml data source tutorial when i preview /compile the to pdf it seams that each xml record that the xpath match get printed in its own separate detail band and what i need is to be printed one under the other . what im doing wrong here ? ...

iReport ,why i can't place group of nods. group ander group.

Hi im new to iReport and i try to do simple thing without much success i have this xml <addressbook> <person> <name>ETHAN</name> <phone>+1 (415) 111-1111</phone> </person> <person> <name>CALEB</name> <phone>+1 (415) 222-2222</phone> </person> <car> <firm_name>fiat</name> <year>1...

How to compile a subreport while the main report is executing in ireport?

I am trying to compile a sub-report from on the fly from java. I placed the subreport expression in the MAIN report as follows. <subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[SubReportCompiler.getCompiledReport("reportId")]]></subreportExpression> My subreportcompiler code is as follows: public class S...

Jasper Reports iReport connection to MS Access DB

Has anyone successfully connected to their MS Access db using Jasper Reports iReport? I am running windows XP and have downloaded the North Wind .mdb example file. Can someone provide the steps/config file pastes or links to tutorials on how to connect to that file and start building queries and reports? Info I am using in JDBC Data...

Null 'key' argument error

Hi, I'm using IReport 3.5.0 and my java GWT application uses the compiled .jasper file, to create a report. I'm creating the datasource in the java application and use fillReport() method to fill the report. It works fine, it fills the fields that I have defined both in the .jrxml and Java application. However, I want to use those field...

How to create gantt chart in iReport 3.7.*

I recently download iReport 3.7.4 after seeing that it has gantt chart feature. However, after creating a new report with gantt chart, i am stuck on how to get the dataset. anyone out there have done gantt chart before with iReport 3.7.* ? please share. Thanks! ...

problem related to subreport in i-report

Hello friends i am developing report containing sub report using i-report and i am passing two external parameters in master report one week called CurrWeek and Year Called CurrYear and the same parameters are also passed in subreport in Both report i declared parameters as BigDecimal and when i run it shows Error shown bellow Error ...