2002 JI Open Discussion

September 3, 2006

By: TesTech - testech

API to incorporate subreport in mainreport???

2005-10-25 02:08

Is there any API for incorporating the subreport in main report ? pls tell us about that API and the jar where the API is present.

September 3, 2006

By: Aniruddh - aniruddh

Internationalizarion in iReport

2005-08-15 11:58

Hii All,

I have create all necessary property files required for internationalization. But i dont know the process to view such report. All times it is giving english text only is there any special setting to set Locale to french. Even what to do from Java side while calling such report .. how to specify Locale?

By: jane_lim - jane_lim

RE: Internationalizarion in iReport

2005-09-26 06:23

Hi,

I am now looking into the internationalization in iReport as well, have you got any solution on this issue ??

thanks

September 3, 2006

By: kunchito - kunchito

i can't compile with ireport 0.5.1..

2005-08-30 15:27

Hello friends:

I downloaded the last version of iR., unzipped, pasted the tools.jar, and it starts but don't compile.

I'm using jdk 1.5 and win xp prof.

is this a bug???.... The 0.5.0 version compiles but throws me the jdt and classNotFound exceptions.

I have no problems using the 0.5.0 version in win98se, but that is not my objective...

Any advice???...

Regards

September 2, 2006

By: SweetCreek - sweetcreek

I need an iReport Programmer!

2005-12-13 17:57

I need two reports created using iReport, and I don't have the time to learn to do it myself. So I need someone to do it for me. Any help in finding someone capable of such a thing would be greatly appreciated.

By: zac - zemerli

RE: I need an iReport Programmer!

2005-12-30 10:30

You are the most welocome.

How can I reach you?

September 2, 2006

By: Shammi Hettiarachchi - shammif2
New tutorials
2005-12-15 09:50
do any one know about new ireport tutorials regarding to IReport 0.5.0 and above.
do any one willing to share a copy of ultimate user manual for free.

if you have the manual why dont you make a good tutorial(s) out of it. specially sub-reporting

September 2, 2006

By: akalehzan - akalehzan

MS SQL SERVER jdbc.sqlserver error

2005-12-08 12:25

Hi All,

I just installed iReport tool on MAC OSX 10.4 and tried to connect MS SQL server from Connection prosperities, but I'm getting error"

ClassNotFoundError:" Check your class path!

Which file I need to add the class path and what should I add in that file?

Thanks in advance,

Abrahim

By: Sherman Wood - sgwood

RE: MS SQL SERVER jdbc.sqlserver error

2005-12-09 06:37

The drivers can be downloaded here http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&displaylang=en

You will need to put the following JARs on your classpath:

msbase.jar

mssqlserver.jar

msutil.jar

Also there is the jTDS open source driver that connects to MS SQL Server and Sybase at:

http://jtds.sourceforge.net/

Sherman

JasperSoft

September 2, 2006

By: hyzom - hyzom

groovy compiler overrides a final method

2005-11-08 01:23

I tried iReport 0.5.2 under jdk 1.5 update 5 on suse 10.0. when I compile reports using groovy as the default exepression language I get an error from the class loader saying that the Groovy compiler overrides a final method. I tried it on WindowsXP and got the same error message.

By: jthevenoux - jthevenoux

RE: groovy compiler overrides a final method

2005-12-07 06:12

Same Pb

with same report, i have three result :

iReport 0.5.0 :

All is OK

iReport 0.5.1 : error :

java.lang.NoSuchMethodError: net.sf.jasperreports.engine.JRExpression.getName()Ljava/lang/String;

iReport 0.5.2 : error :

java.lang.VerifyError: class net.sf.jasperreports.compilers.JRGroovyCompiler overrides final method

That's not very cool ...

September 2, 2006

By: Sandeep - skadyan

Generate Multilingual Report

2005-11-29 00:50

Hi,

I want to generate the report with mulit-lingual support.My problem is that I want to fill the labels (Static-text) field with the translated text (in other language).My transalted text will come from DataBase .But I can not join the Table,which has the transalted text, with in the ReportQuery.Can any one help me filling the transalted text value for the label which I have used in the report.

Thanks

Sandeep

By: ODIM - odim

RE: Generate Multilingual Report

2005-12-06 09:54

Hi,

itÂ´s better to use Textfields, because you can work there with fields ($F{..}) or Variables or Parameters ($P{..}).

In StaticTextFields you canÂ´t do that.

greetz

ODIM

September 2, 2006

By: allfonsaravanan - allfonsaravanan

problem with line graph

2005-11-28 03:48

hi folks,

i need to mention in line graph x axis as a string in ireport designer tool.

it was working those categories(String),series,values in Bar graph.but it is not working on line graph.i m getting the exception Numberformat exception.cause i m giving y axis as a string format.y it cant take as string in line graph ..but it took as in bar graph.i need explanation ....and i need to call a proceduire from Oracle data base...not for SQL Server.

September 2, 2006

By: Jhonny Bravo - ac48

calling SP containing Temp table in IReport

2005-11-09 06:17

hi folks

i m trynig to call a stored procedure using IReport and there is no

problem with that and the procedure gets called ....

but if that procedure has a temporary table then I cannot get the records in my Report....

So if any one of you have tried the same plz let me know

thanx in advance

By: TesTech - testech

RE: calling SP containing Temp table in IReport

2005-11-10 23:04

hi ,

Check whether the SP is actually returning any records ?

call the procedure with the required parameters.

For example if ur using SQL server

exec <procedure name> <parameters>

if the above stmt returns any record , then it will be reflected to Report wizard.

thats all my suggestion abt.

Regards

Varun Chakravarthi T

By: allfonsaravanan - allfonsaravanan

RE: calling SP containing Temp table in IReport

2005-11-28 03:39

i m trynig to call a stored procedure using IReport and there is a

problem with that and the procedure have to call from oracle database not from sql server...can any one tell me abt that ...how to call procedure with parameter from ireport?.

September 2, 2006

By: mauricio cordero - maucorpat2

org.apache.xpath.XPathException

2005-07-11 03:47

When I compiling no error apear, when I execute the following error apear:

-------------------------------------------------------------------------------------------------------------------------------

net.sf.jasperreports.engine.JRException: XPath selection failed. Expression: /GLOBAL/DAY+usrsAuthenAvg at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:336) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:872) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:116) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:622) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:116) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:428) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:344) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:571) at java.lang.Thread.run(Thread.java:534) Caused by: org.apache.xpath.XPathException: No se puede convertir #NUMBER en una NodeList. at org.apache.xpath.objects.XObject.error(XObject.java:741) at org.apache.xpath.objects.XObject.nodeset(XObject.java:471) at org.apache.xpath.CachedXPathAPI.selectNodeIterator(CachedXPathAPI.java:219) at org.apache.xpath.CachedXPathAPI.selectSingleNode(CachedXPathAPI.java:177) at org.apache.xpath.CachedXPathAPI.selectSingleNode(CachedXPathAPI.java:157) at net.sf.jasperreports.engine.data.JRXmlDataSource.getFieldValue(JRXmlDataSource.java:334)

-------------------------------------------------------------------------------------------------------------------------------

And for connection/database properties is:

xml file = /home/ocordero/documentos/javadoc/JasperReport/reportesAirMonitor/xmlFileGroup.xml

select expresion = /GLOBAL/DAY

---

And for field is :

fieldname = usrsAuthenAvg;

class type = java.lang.string;

field description= /GLOBAL/DAY+usrsAuthenAvg.

---

And my xml file is:

<?xml version="1.0" encoding="UTF-8"?>

</DAY>

</DAY>

</GLOBAL>

some curious is: If I change the """field description= /GLOBAL/DAY/usrsAuthenAvg."" from the data connection. otherwise if I change the simbol "+" for "/", no apear error when I run the repor from the iReport. But show the report wrong, since it shows the first data (DAY) twice without showing the second DAY.

Please help me. I try for two days And I cant found the solution.

Oscar from spain.

By: Wal Millard - walmillard

RE: org.apache.xpath.XPathException

2005-11-23 14:14

Ur xpath statement is incorrect. the + is the probelm i suggest you remove it and set your description to just simply

usrsAuthenAvg

and your xml datasource expression to

/GLOBAL/DAY/

(Note this is all case sensitive)

XPath Builds on your Expresion, so at runtime the entire expression (the xml datasource path, and the field description part) should look and point to a valid xml tag or attribute.

i.e

/GLOBAL/DAY/usrsAuthenAvg

luck

walmillard

September 2, 2006

By: acpradeep - acpradeep

subreport in main report with xml data source

2005-11-02 22:18

when the subreport is embedded in main report with xml as datasource, the subreport is displayed as a seperate entity. There seem to be no relationship betweeen the subreport and the main report.

whereas when the database connection is used, the subreport and main report are displayed correctly.

can anyone help us please.

if there is any API to link subreport with main report please tell us.

thanks in advance

acpradeep

By: Wal Millard - walmillard

RE: subreport in main report with xml data so

2005-11-23 14:06

acpradeep,

You need to align the request to the xml datasource with both reports. Can you post the SQL v's the XML Expression you are using.

walmillard

September 2, 2006

By: Giulio Toffoli - gt78

iReport 0.5.2 released!

2005-11-04 07:18

The iReport Team is pleased to announce the new iReport release: 0.5.2.

The following changes have been made to software since release 0.5.1

Partial support for JasperReports 1.1.0 (crosstabs, styles and frames are not yet supported)

Improved log window

Fixed all templates

Serveral bug fixes and improvements

Thanks for your suggestions and your on going support using iReport!

Giulio

iReport site: http://ireport.sf.net

download: https://sourceforge.net/project/showfiles.php?group_id=64348

By: dex wintergreen - wpmadden

RE: iReport 0.5.2 released!

2005-11-04 11:35

I tried iReport 0.5.2 on win2K/sun java1.5.0_05

both the binary and compiled

I cannot create either a Variable or Parameter, gives

NullPointer exception

at it.businesslogic.ireport.gui.ValuesPanel.newParameter(ValuesPanel.java:1989)

at it.businesslogic.ireport.gui.ValuesPanel.newVariable(ValuesPanel.java:925)

anyone else seeing this?

By: C-Box - c-box

RE: iReport 0.5.2 released!

2005-11-06 05:55

Can't share.... also has 0.5.2 with winXP and Java 2 Runtime Environment, Standard Edition (build 1.5.0_05-b05)

so I can create variables and parameters very well - don't know what version you have... I pulled it directly from CVS at november 1st. and don't have those errors.

thanks Guilio for the new release ... have you now more time for developing at IReport like Teodor at JasperReports?

I've a lot of improvement suggestions yet. :-)

C-Box

By: Fabio Patricio - fabio_patricio

RE: iReport 0.5.2 released!

2005-11-08 08:52

Hi

Has some forecast for support crosstab?

Best regards

Fabio

By: bestfriend37 - bestfriend37

RE: iReport 0.5.2 released!

2005-11-17 06:51

hi,

i also need support for crosstabs in ireport, since JasperReport already provide this. is there an intention to support this.

September 2, 2006

By: acpradeep - acpradeep

Group By functionality in Jasper Reports?

2005-11-16 01:22

Hi,

In crystal reports we have the Group-By funtionality.

Do we have the Group By functionality in Jasper Reports?

If Jasper Reports is also having the same functionality then please tell me how to use the Group-By functionality in Jasper Reports.

Thanking You in advance

thanks and regards

A. Christopher Pradeep

September 2, 2006

By: bluerocket - j_simpson

Custom Properties

2005-11-15 01:54

Hi, it appears as though iReport rewrites custom properties from xmlEncoded values to their original values which could break the integrity of the Jasper Report. I've only noticed a problem so far with the > symbol being translated to > and < to < so far but it rewrites all other encoded strings as well.

September 2, 2006

By: Lal V K - lalnec

differentiating Odd and Even row in detail

2005-11-10 05:08

HI,

I have to differentiate odd and even rows with different color in details section.I would like to know how it could be done..I have tried with detail band Print When Expression.Its only accepting Boolean value.How I could set the color for alternative rows.

Pls help me.Its very urgent.

Thanks and regds,

V K Lal.

lalnec@rediffmail.com

By: Daren O - rckrll106

RE: differentiating Odd and Even row in detai

2005-11-10 06:39

I created a rectangle in the background and for the print expression I used:

new Boolean(

($P{LineColor}.booleanValue()) &&

(((int)$P{LineSpace}.intValue() / 2) <= ($V{REPORT_COUNT}.intValue() % $P{LineSpace}.intValue()) )

)

note: I add the option to pass in two parameters. LineColor is a boolean to whether to use the color or not. LineSpace is of a multiple of 2 for how many lines to alternate (meaning the value of 2 will color every other line, 4 will color 2 lines, etc..)

Might be other ways but that is how I do it. Hope it helps.

By: TesTech - testech

RE: differentiating Odd and Even row in detail

2005-11-11 01:05

hi ..

The above posted solution can be simplified , without any parameters.

just copy all the fields in the detail section and paste it on the same location.

Choose one color to one set of fields and choose another color for the other set of fields.

Now , select one set fields and give the following expression (print when expression)for one set of fields

new Boolean((new Integer(($V{REPORT_COUNT}.intValue()) % (new Integer(2).intValue()))).equals(new Integer(0)))

and for the other set of fields and give

new Boolean((new Integer(($V{REPORT_COUNT}.intValue()) % (new Integer(2).intValue()))).equals(new Integer(1)))

Note : All the fields should be in a "Transparent" mode

Test this with only one field on details section.So that you can feel easy to set the property for other fields

This worked for me ! You try it !!

Regards

Varun

September 2, 2006

By: TesTech - testech

Last Page Footer ?

2005-11-09 03:44

Hello ,

Im using iReport - 0.3.0 (JasperReports-0.5.2.jar).I need to display an image only on the last page footer of the report.

Is there any way to do this ?

(Higher version of jasper might have this feature , but i cant use it , because our customers generated numerous reports on iReport 0.3.0 , they dont want to switch.)

Please any one help me !!

Thanks

Regards

Varun

September 2, 2006

By: Aparna - aparnaswami

Subreport got filled only once ??

2005-11-05 04:28

Hello ,

Im using iReport0.4.1 for generating jasper reports.

I got a problem on sub report.

Im passing the datasource(of subreport) through a parameter from mainreport.

But the subreport got filled only once.

For Example : If I placed the subreport in the PageHeader of MainReport, the subreport got filled only on the first pageheader of MainReport.Its not filled on the second , third etc., pages of the main report.(A blank sub report is displaying without any data).This problem is repeating on all the bands.

How to overcome this .Is there any settings has to done on iReport Editor?

Any one please help me ! Its very urgent issue !

Thanks in advance

Aparna

September 2, 2006

By: Kostas Michailidis - mkostas_gr

Attn: Mr.Danciu

2005-11-01 07:01

A bookmarks list viewer inside the JRViewer would be very usefull.

thank you

Kostas Michailidis

September 2, 2006

By: Peter F. - pe_f

JGoodies Looks Update?

2005-10-27 04:26

Hi,

Karsten Lentzsch updated his JGoodies looks library to version 1.3.2.

Could you update the looks library in iReport, too, since Karsten made a change in the naming of the packages (replaced plaf with looks) with version 1.3.*. This prevents a simple exchange of the jars.

TIA!

cu

Peter

September 2, 2006

By: jmarandall - jmarandall

Adding JDBC drivers

2005-10-18 10:55

I'm new to iReport. The mySql driver is the only one that comes standard with the software. Where can I get the Oracle JDBC driver and how exactly do I make it appear in the JDBC Driver drop-down list? Thanks in advance.

By: Kevin - eventronix

RE: Adding JDBC drivers

2005-10-26 12:46

Im not sure where you get the driver for orical, try google, but you can just type it into the field

September 2, 2006

By: casey - fckoffdude

Support for JasperReports 1.1.0

2005-10-26 04:58

When will iReport support JasperReports 1.1.0?

September 2, 2006

By: TesTech - testech

API to incorporate subreport in mainreport???

2005-10-25 02:08

Is there any API for incorporating the subreport in main report ? pls tell us about that API and the jar where the API is present.

September 2, 2006

By: TesTech - testech

SubReport using datasource

2005-10-20 21:44

hi ,

Thanks for every one for giving this support !!!!

I am using xml datasource for launching the reports.

and i am comfortable with that.

Now , I need to embed a subreport with in the main report using xml data source.

Can any one give me any idea about this?

Thanks & Regards

testech

September 2, 2006

By: ccatindia - ccatindia

need help in Hyperlink

2005-10-12 12:02

Dear Friends,

I want to use the hyperlink property in iReport.

I gave the property details.I gave the another reports path at the "Hyperlink Reference Expression".When i'm viewing the report in JRViewer i cannot get the referenced report,But i can see the tool tip text as the reference that i entered.

Anyone please help me....

Balaji

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by 2002 JI Open Discussion

Products

Explore