2006 JR Open Discussion

August 22, 2006

By: meenamca - meenumca

To generate report

2006-01-23 19:27

hi,

Good Morning,

I am new to this forum and this is my first question.I am doing a project with NetBeans IDE4.1

and MS-Access.My OS is Windows Server 2003.Can I use Jasper Report for my project?

Can I download Jasper Report and use well with the softwares used by me?

By: Alexander Wallace - aows

RE: To generate report

2006-01-23 19:40

As far as Netbeans 4.1 and JasperReports, Certainly. The other elements you mention are unknown to me. But if they both run in the same enviroment as you are running netbeans, it should work fine.

By: meenamca - meenumca

RE: To generate report

2006-01-23 20:35

hi,

Thank you so much for your quick reply.I saw your reply and dwonloaed the following

1.jasperreports-1.1.1-applet.jar

2.jasperreports-1.1.1.jar in the following directory.

C:Documents and SettingsAdministrator.

When I open this file I got the following error message.

Failed to Load Main-Class manifest attribute form

C:Documents and SettingsAdministratorjasperreport-1.1.1-applet.jar

What is my error.Please help me to solve this,then only I can start report module of my project.

Thank you so much.

Is any mistake in my way of downloading?

By: Vinod Kumar Singh - vinodsingh

RE: To generate report

2006-01-24 01:03

Look at the tutorial at: http://jasperreports.sourceforge.net/tutorial/index.html

jasperreport-1.1.1-applet.jar does not have a main class.

Try to dig in deeper in the documentation.

Vinod

By: venz98 - venz

RE: To generate report

2006-02-08 17:00

Ive also encountered the same problem, when i try opening the file.

I've even try to redownload the two files, because i thought their is something wrong with my download. But when i try opening it again..still the same problem i encounter.

Venus

By: venz98 - venz

RE: To generate report

2006-02-19 18:26

I've already found a solution to our problem:

The error means that this jar file(jasperreport-1.1.1-applet.jar) is not an application. Since on Window platform you can create a jar file and allow it to be launched by double-click on it by specifying the "Main-Class" attribute in the Manifest file.

This jar file is just a regular jar file, technically it is a zip file since it uses the same compression method. You can use a WinZip utility on Window to open and extract it or using the jar command to extract its content.

To extract the content of the jar file by using the Java's jar command type the following at the command prompt(Make sure your PATH contains the path to you Java JDK):

jar xvf jasperreport-1.1.1-applet.jar

venz

By: stone_cold - bssai

RE: To generate report

2006-02-19 22:03

Guys relax,

U got the latest version of JR 1.2 relased 10 days ago..try to download that.

http://sourceforge.net/project/showfiles.php?group_id=36382&package_id=28579

I had downloaded it and had no issues with it.

Austin

August 22, 2006

By: stone_cold - bssai

Using Jasper Reports with Hibernate

2006-02-17 01:10

I have a query or concern with respect to the JasperDesign class of the Jasper reports.

Let me be more clear on wat i would like to say, If u see the examples or samples which are under the samples folder of JSR/demo/samples/noxmldesign/ provided along with the binary , this particular struture has been given for those who does nt want to use the designing tool or to be precise the .jrxml file.

I am ok with creating my own structure. But the problem i am facing is In the program u have to pass the query to fill the report.But i already have the data in the form of objects using Hibernate. Now if at all i pass on the query again..Does it mean that i am doing a repeatition of the code by executing the query twice.

Let me show us with example.

This part of the code is in jsr/demo/samples/noxmlDesign/noxmlDesignApp.java

//Query

JRDesignQuery query = new JRDesignQuery();

query.setText("SELECT * FROM Address $P!{OrderByClause}");

jasperDesign.setQuery(query);

Here is the click I dont want to send a query string again coz i have already got the queries data..i mean the result.

I hope u got my point.

Looking ahead for ur reply,

By: Teodor Danciu - teodord

RE: Using Jasper Reports with Hibernate

2006-02-17 02:11

Hi,

Supplying a query in the report template is optional.

If you already have you data in-memory, you could

wrap it using JRBeanCollectionDataSource implementation and pass this data source to the

report filling process.

Look at the supplied /demo/samples/datasource

sample provided with the project.

I hope this helps.

Teodor

August 22, 2006

By: venz98 - venz

Why use jasper reports?

2006-02-08 16:55

Hi!

I've just heard about jasper reports. My immediate boss wants to know my recommendation regarding this matter. Please help me

Can you give me the reasons why you are using jasper reports.

Thanks,

Venus

By: jasperkan - jasperkannan

RE: Why use jasper reports?

2006-02-10 17:02

the best available reporting tool in opensource at the moment.

full support of the Open source industry with SourceForge

GNLU licensed

Very flexible and powerful with features like subreports eg master /detail reports

easy database support with the data source customizable from a JDBC , Collection etc .

Can easily plugin custom java code for processin business logic of the returned data using Scriptlets

Very fast Features addition with full feature request support

Very good response/mailing support / user groups community with direct mails from Teodar (father of Jasper Reports)

can make Dynamic reports at run time which is a big advantage compared to Crystal reports .

PS : I work in a product development company in insurance/benefits and use this tool. we were using crystal reports and switched to jasper since crystal wasnt allowing us to generate dynamic reports on the fly.

By: raffimd - raffimd

RE: Why use jasper reports?

2006-02-13 01:05

Hi Kannan,

Can you please share little more on how do you make use of jasperReports to define the dynamic reports. Is it by passing parameters?

Thanks,

Raffi

By: jasperkan - jasperkannan

RE: Why use jasper reports?

2006-02-14 09:50

u can conditionally show/hide a field based on PrintWhenExpression

dynamically change the label of a column by using a java expression which check for a flag and display the field header differntly.

$P{REPORT_FOR}.equals("A")?"MEMBER":"BILLING"

August 22, 2006

By: amodg - amodg

IllegalArgumentException Sheet name cannot...

2006-02-14 05:50

Hi,

I am trying to export my report in MSExcelSheet using net.sf.jasperreports.engine.export.JRXlsExporter class.While doing that, I am getting an Exception as...

java.lang.IllegalArgumentException: Sheet name cannot be blank, greater than 31

chars, or contain any of /*?[]

at org.apache.poi.hssf.record.BoundSheetRecord.setSheetname(BoundSheetRe

cord.java:175)

at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:458)

at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:452)

at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.j

ava:369)

at net.sf.jasperreports.engine.export.JRXlsExporter.createSheet(JRXlsExp

orter.java:126)

at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport

ToStream(JRXlsAbstractExporter.java:279)

at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport

(JRXlsAbstractExporter.java:154)

Could you plzzzzz.... help me out...?

I am eagerly waitng for any reply....

Thanks in advance !!!!

-Amod

August 22, 2006

By: Per Nyfelt - per_nyfelt

jasperreports-portal

2006-02-04 06:03

Hi,

I would like to get the jasperreports-portal working on jboss-portal 2.2.1. Deployment descriptor among other things has changed. also it would be nice to upgrade to use the latest JR release. I wanted to check if someone had already started to look at upgrading but I cannot find jasperreports-portal in CVS. Cound someone please point out where to find it?

Best regards,

Per

By: Barry Klawans - bearklaw

RE: jasperreports-portal

2006-02-07 13:56

Hi Per,

Looks like the source didn't get added for some reason. I'll track it down and put it on SourceForge.

-Barry

By: Barry Klawans - bearklaw

RE: jasperreports-portal

2006-02-07 14:55

By the way, the source is available from the files download area, its just not in CVS currently. Download jasperreports-portal.src.zip.

-Barry

By: Teodor Danciu - teodord

RE: jasperreports-portal

2006-02-08 06:42

Hi,

The JasperReports Portal application is now

on the public Sourceforge CVS repository here:

http://cvs.sourceforge.net/viewcvs.py/jasperreports/jasperreports-portal/

Thanks,

Teodor

By: rrogger - rrogger

RE: jasperreports-portal

2006-02-10 11:02

Excuse, please. Sorry for poor English. What is license for jasperreports-portal. Not found in CVS or download.

Cheers,

-R

By: Barry Klawans - bklawans

RE: jasperreports-portal

2006-02-10 13:46

LGPL. I'll make sure it gets added in the immediate future.

-Barry

August 22, 2006

By: jessica - zhou527

Reports can't be viewed with running portal

2006-02-10 08:34

I followed JasperReports Portal installation guide and I deployed two war files. The jrxml files can be uploaded, but I have the problem of viewing the report: nothing shows up to the report viewer. I checked my report file, which does contain a-few-page data.

JBOSS runs fine except some warnings. I can't figure out the problem from the warnings, but I still post them as following in case any of you need them to see a problem.

Thanks for your kind help.

2006-02-09 17:15:26,796 WARN [org.jboss.portal.core.invocation.StrategyInterceptor] No strategy name found, using 'default'

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] looking for strategy with name: default

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] found strategy to use: org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] adding region: center

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] adding region: left

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating portlet context for: ReportDisplayPortletWindow

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating portlet context for: ReportListPortletWindow

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.StrategyFactory] creating strategy context for: 2ColumnLayout jasperreports-portal front

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl] evaluating strategy for: org.jboss.portal.core.theme.impl.PortalLayoutImpl@11cbec9 />2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl] evaluating portlet: ReportDisplayPortlet

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.theme.strategy.impl.DefaultStrategyImpl] evaluating portlet: ReportListPortlet

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] setting layout URI: /layouts/twoColumns.jsp

2006-02-09 17:15:26,796 DEBUG [org.jboss.portal.core.invocation.StrategyInterceptor] done analyzing layout strategy

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.servlet.CoreServlet] requesting theme: null

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.servlet.CoreServlet] using layout returned from the strategy: 2ColumnLayout uri: /layouts/twoColumns.jsp

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.servlet.CoreServlet] got layout to use [2ColumnLayout] in app [/jasperreports-layout] uri [/layouts/twoColumns.jsp]

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.theme.LayoutDispatcher] got request dispatcher for layout resource: true

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] rendering theme ...

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] got theme to render: null

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] requested theme not found. Is there a theme attribute in the tag ? jasperreports

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.impl.ThemeServerImpl] get theme jasperreports

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.impl.ThemeServerImpl] found theme jasperreports

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] Found valid theme to render: null

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] get link ...

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] returning: <link rel='stylesheet' type='text/css' href='/jasperreports-layout/jasperreports.css' media='screen' />

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] writing theme link: <link rel='stylesheet' type='text/css' href='/jasperreports-layout/jasperreports.css' media='screen' />

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] get link ...

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.impl.ThemeLinkImpl] returning: <link rel='stylesheet' type='text/css' href='/jasperreports-layout/jasperreports.css' media='screen' />

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.ThemeTagHandler] done rendering theme

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] rendering left [vertical]

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] done rendering page region

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] rendering center [vertical]

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.core.theme.tag.RegionTagHandler] done rendering page region

2006-02-09 17:15:26,828 DEBUG [org.jboss.portal.server.theme.LayoutDispatcher] done with the layout

2006-02-09 17:18:20,015 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000

2006-02-09 17:25:50,015 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000

By: jessica - zhou527

RE: Reports can't be viewed with running portal

2006-02-10 08:54

By the way, my environments:

iReport-1.1.0

jboss-portal-2.0.1-jboss-4.0.3SP1

JBoss Reporting Portal JR 1.0.3

Note: since iReport-1.1.0 is using jasperReport-1.1.1 to generate reports, I changed jasperReport-1.0.3 for JBoss Reporting Portal JR 1.0.3 to jasperReport-1.1.1.

August 22, 2006

By: jasperkan - jasperkannan

Subreport path in a Web App

2006-01-20 07:03

i have a main report with a subreport and its working fine in the Ireports env .But when i deploy it to the WebApplication , the

SUBREPORT_FILE_NAME has to specified as a relative URL ie /reports/subreport.jasper.

this doesnt seem to work and its expecting the absolute path to be specified !!!!! . i tried all options like going one directory down

ie

subreport.jasper

./subreport.jasper

../reports/subreport.jasper

/WEB-INF/resources/reports/subreport.jasper

Is there any way to make jasper understand the relative URL ?

Thanks n advance.

By: Lucian Chirita - lucianc

RE: Subreport path in a Web App

2006-01-24 01:10

JR resolves reports (including subreports) locations as fs paths or class loader resources.

If you specify a relative file path it will be interpreted relative to the current user directory.

You can alternatively add the reports directory to the classpath and specify the subreport location as resource name.

HTH,

Lucian

By: William Baker - wlbaker

RE: Subreport path in a Web App

2006-02-09 07:48

I use a different method. My reports use a parameter "BaseDir", which is "prompt=no" and populated by the report generating JSP. It has a default value that allows for good behavior in JasperAssistant. The subreport is then referenced as new File( $P{BaseDir}, "subreport.jasper" );

bbaker

August 22, 2006

By: kamal - kamalakarareddy

Why my datasetRun not accepting dataSourcePar

2006-02-08 12:15

Why my datasetRun is not accepting dataSourceParameter

Do you think my template is not set with this?

<!ELEMENT datasetRun (parametersMapExpression?, datasetParameter*, (connectionExpression | dataSourceExpression)?)>

</datasetParameter>

</datasetRun>

By: Lucian Chirita - lucianc

RE: Why my datasetRun not accepting dataSourc

2006-02-09 00:11

What do you mean by not accepting dataSourceParameter? Do you have an error?

Regards,

Lucian

August 22, 2006

By: venz98 - venz

MySQL

2006-02-07 22:46

Ive just heard about Jasper Reports, i just want to ask if it supports MySQL database.

thanks

Venz

By: Barry Klawans - bklawans

RE: MySQL

2006-02-08 08:44

Yes it does. JasperReports works many different data sources, and comes with a JDBC data source that works with MySQL (as well as most other RDBMS).

We also have a sample application you can download that monitors multiple MySQL instances and then reports off the usage, table growth, etc.

-Barry

By: venz98 - venz

RE: MySQL

2006-02-08 16:54

Thanks Barry

Venz

August 22, 2006

By: Rajender - rajender_anand

Show SubReport on click

2006-02-08 09:48

I have created a Master which has hyperlinks in it. I want that on click of teh hyperlink a value will be passed to the Subreport and it will show the SubReport. Otherwise No subreport should be displeyed.

Thanks

Rajender

August 22, 2006

By: Rajender - rajender_anand

Show SubReport on click

2006-02-08 09:48

I have created a Master which has hyperlinks in it. I want that on click of teh hyperlink a value will be passed to the Subreport and it will show the SubReport. Otherwise No subreport should be displeyed.

Thanks

Rajender

August 22, 2006

By: tommy - tommy2381

how to add custom datatype

2006-02-07 05:39

i need to add a new datataype for variables, fields and textfields and i want to used it for sums.

We need to make some sums that cannot be done with doubles(precision is lost); we have a custom framework for decimal numbers.

What I have to extend/modify?

Thanks.

By: Lucian Chirita - lucianc

RE: how to add custom datatype

2006-02-08 00:17

You'll have to implement JRIncrementerFactory and for JRVariable.CALCULATION_SUM implement a JRIncrementer (you can take JRDoubleSumIncrementer as an example).

Then, for all your sum variables of this type you'll have to set incrementerFactoryClass to the class name of your JRIncrementerFactory implementation.

HTH,

Lucian

By: tommy - tommy2381

RE: how to add custom datatype

2006-02-08 00:28

yes.

thise "for all your sum variables of this type" - what type i have to put to those variabiles?

Thanks.

By: Lucian Chirita - lucianc

RE: how to add custom datatype

2006-02-08 00:47

I guess that the type of the sum variables will be your custom datatype - I assume that your framework by adding two values produces a value of the same type.

Regards

By: tommy - tommy2381

RE: how to add custom datatype

2006-02-08 00:52

When i declare a variabile I have something like this :

<variable

name="PricingMatrixItemCustomerPrice_customerPriceAfterDiscountInEUR_SUM_General_group" class="java.lang.Double" calculation="Sum" resetType="Group" resetGroup="General_group"

<variableExpression>$F{PricingMatrixItemCustomerPrice_customerPriceAfterDiscountInEUR}</variableExpression>

</variable>

the problem is "class" atribute because jasper does a design verification (dtd validation), and i can choose only from java data type (double, boolean ans so on).

so what class i have to put there ? Object ?

Thanks.

By: Lucian Chirita - lucianc

RE: how to add custom datatype

2006-02-08 01:19

Which JR version are you using? I don't think there is a restriction on variable typs. What is the exact error you're getting?

By: tommy - tommy2381

RE: how to add custom datatype

2006-02-08 01:26

yes you are right.

but i want to used this also for fields , and textfields.

so there is this problem. i think.

thanks again.

By: Lucian Chirita - lucianc

RE: how to add custom datatype

2006-02-08 02:09

The restrictions on field types have been removed since 1.0.0. With 0.6.6, you should use Object.

With textfields, you could format the value to a String or, if your type extends java.lang.Number, use the text field pattern to format it.

HTH

By: tommy - tommy2381

RE: how to add custom datatype

2006-02-08 03:50

ok .thanks. this is the answer.

By: tommy - tommy2381

RE: how to add custom datatype

2006-02-08 01:28

sorry..

i'm using jasperreports 0.6.6

and this from dtd

<!ATTLIST field

name NMTOKEN #REQUIRED

>

August 22, 2006

By: sreenathv@global.com - sreenathv

How to add Arial Narrow to pdf output

2006-02-06 02:44

Hi All,

I want to add Arial narrow font to pdf generated by iReports. I am not getting the Arial narrow in the font list box. Even I tried with changing the XML code to Arail narrow but it is giving font could not be loaded. Can any body help?

Thanking you

August 22, 2006

By: Giulio Toffoli - gt78

[ANN] iReport 1.1.0 released!

2006-02-02 17:57

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

- Full support for JasperReports 1.1.1

- New crosstab wizard

- New crosstab editor

- New draggable panes

- Barcode improvments

- Serveral bug fixes and improvements

And much more...

See details on iReport 1.1.0 What's new? page!

(http://ireport.sourceforge.net/index.php?p_module=page&pageid=28)

iReport home page:

http://ireport.sf.net

Download it now:

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

August 22, 2006

By: ramesh - ramesh2410

Need to create worksheet in excel

2006-02-01 01:19

Hi Pals,

The data retrieved from the databse need to be shown in different worksheets of excel.if anyone is aware to create worksheet,please provide the solution.

Thanks for the effort.

By: ramesh - ramesh2410

RE: Need to create worksheet in excel (Urgent

2006-02-01 02:37

Using Jasper Reports i need to create the excels multiple work sheet

Thanks for the intrest and effort

August 22, 2006

By: ramesh - dramesh

Hi Teodor pls Look this requirement

2006-01-26 01:25

Hi ,

here i'm using jasreports+ireports.

i have a new reuirement i don't know how to design it pls help on this. My reqirement is like this

BAFPT 2005/08 ACTIVE

MS SEOW LEY WEE,

BLK 948 JURONG

#10-679

SINGAPORE 640948

BAFPT 2005/08 ACTIVE

MS QUEK HUI YING

BLK 611 ANG MO

#10-2807

SINGAPORE 560611

BAFPT 2005/08 ACTIVE

MS NEO CHENG BEE

BLK 841 YISHUN ST

#12-260

SINGAPORE 760841

.

like this i'm getting output from my report but i want

1 2 3

4 5 6

like this here i given numbers insted of addresses.

pls let me know how can i write the code

thanks in advance

ramesh

By: jay - jay21

RE: Hi Teodor pls Look this requirement

2006-01-30 18:42

Use the Columns in reports properties to get output in label format.

Have not tried, but should work.

By: avantrik - avantrik

RE: Hi Teodor pls Look this requirement

2006-01-31 02:50

Hi Ramesh,

Firstly please download Jasper Source and look at samples, where Teo has worked on all samples.

Please check Datasource.jrxml file in sample.

I hope it helps.

August 22, 2006

By: gabe12 - gabe12

JRHtmlExporter OutputStream Issue

2006-01-30 02:06

Hi.

I'm using JRHtmlExporter (jasperreports 1.1.1) to generate my reports and write the images to a directory within my webapp.

If I stream the HTML to my ServletResponse outputstream. The html code is flushed to the stream but the images are not jet generated so my report is empty after hitting the reload button in my browser the image appears.

How about changing the generation order? Move line 424 to 519 in JRHtmlExporter to the top of the method.

Another solution is not to flush the buffer after the HTML code is generated.

greez gabe

August 22, 2006

By: ramesh - dramesh

Any one pls look on this (urjent)

2006-01-24 02:05

HI ALL,

i'M USING JASPERREPORTS+IREPORTS IN STRUTS APPLICATION. AFTER DESIGN MY APPLICATION I'M CALLING THE .jrxml file from my action class at the time of .jrxml compilation i'm getting follwing error.

Exception: net.sf.jasperreports.engine.JRException: Error at (71, 18: null

only when i'm given the pageHeader Band and cloumnHeader band(contain all static fields ) i'm getting this error. If i given only detail section it is executing fine. any one aware of this pls let me know.

thanks in advance,

Ram

By: sreenathv@global.com - sreenathv

RE: Any one pls look on this (urjent)

2006-01-27 00:07

Post Exception with details

By: Slobodan Kasterovic - kaster

RE: Any one pls look on this (urjent)

2006-01-27 00:55

Maybe compare jrxml file before (still compile) and after (erorr). iReport is a little buggy!

Kaster

August 22, 2006

By: slowfinger - slowfinger

sub reports data source isn't seen

2006-01-20 03:50

Hi,

I have 2 simple reports which will show it's data in single mode but if I put one of them as an subreport in the other one the subreport will not show it's data. I work with jasper reports 1.1.1 from java and the data come from beans collections. Reports and code are following:

1. master report:

</subreportParameter>

</subreport>

2. sub report

3. the java code:

JasperReport reportCar = ((JasperReport) JRLoader.loadObject(new File(carReportFile + ".jasper")));

JasperReport reportCarParts = ((JasperReport) JRLoader.loadObject(new File(carReportPartsFile + ".jasper")));

Collection dataCar = new ArrayList();

dataCar.add(new AutoReportBean(new Integer(1), "audi", "red", new Date()));

dataCar.add(new AutoReportBean(new Integer(2), "golf", "blue",new Date()));

Collection dataCarParts = new ArrayList();

dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Lenkrad"));

dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Batterie"));

dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Auspuff"));

dataCarParts.add(new AutoTeileReportBean(new Integer(1), "Sanikasten"));

dataCarParts.add(new AutoTeileReportBean(new Integer(2), "Kurbelwelle"));

dataCarParts.add(new AutoTeileReportBean(new Integer(2), "Ganghebel"));

Map mapCarTeile = new Hashtable();

mapCarTeile.put("dataSource", new JRMapCollectionDataSource(dataCarParts));

JasperPrint printAuto = JasperFillManager.fillReport(reportCar,mapCarTeile, new JRBeanCollectionDataSource(dataCar));

JasperViewer.viewReport(printAuto);

The data of the master report will be shown but not the subreports data. What's wrong here. What I want in the end is to display a one to many relation on the report using the sub report mechanism and this easy trial doesn't work.

Any helps ;-)

Bye Rico

By: jasperkan - jasperkannan

RE: sub reports data source isn't seen

2006-01-20 06:58

I have encountered the same problem .these are the solns for this .

1: make both reports as subreports and then add them to a main report .

2: put the subreport into the summary area and then set the option show summary data in a new page .

By: Lucian Chirita - lucianc

RE: sub reports data source isn't seen

2006-01-20 09:20

Hi

First an observation: you don't have an subreportExpression for your subreport. This will obviously cause the subreport not to show. Also you load the subreport in the Java code but you don't use it.

Now regarding the report you're trying to produce. Usually in JR when you have a subreport that appears multiple times in the master report, the subreport would have a different data source (I mean the same data source type but instantiated with different parameter values).

In your case this means that the usual way to do it is to have separate part lists for each car and when you call the subreport to pass the list for the current car (the list could be a member of the AutoReportBean bean). I'm don't know whether you can fetch the data in this manner, but it's the canonic way to use master-detail subreports.

Your dataCarParts data source would have to be used by several subreport instances, based on some key matching logic. This not (yet) supported in JR, see this enhancement request:

https://sourceforge.net/tracker/index.php?func=detail&aid=1045435&group_id=36382&atid=416706

HTH,

Lucian

By: slowfinger - slowfinger

RE: sub reports data source isn't seen

2006-01-20 12:45

Hi Lucian,

thanks for your answer. A subreportParameterExpression I have it is the 'autoId'. So that all car parts should be listed to each car. Your answer sounds clear but how I can solve that. The demo sample of subreport which shows an example of using the subreport mechanism makes exactly what I want in the first step, but it does that unfortunatly with a database connection. So the question keeps how I can do that procedure with bean collections.

Thanks in forward

Rico

By: Lucian Chirita - lucianc

RE: sub reports data source isn't seen

2006-01-24 01:25

Let me first ask you again: do you have a subreportExpression for the subreport? Does the subreport show any data at all?

Regarding the autoId parameter, how is it used in the subreport?

As I was saying in previous post, the easiest way to construct your master-detail report is, if possible, by changing the way you retrieve the data. Currently you have a dataCarParts collection containing parts for all the cars. You need to have a parts collection per car.

If you can't fetch your data in this manner, you can process your consolidated parts collection and break it into per car collections. You can do this easily using a parts collection map indexed by the car id or, if both the dataCar and dataCarParts collections are sorted by id, use a faster merge-like algorithm to break down the parts collection.

After you have the parts collection broken down per car, you'll have to use for each car the collection of its parts as a data source for the subreport.

Regards

Lucian

By: slowfinger - slowfinger

RE: sub reports data source isn't seen

2006-01-24 05:11

No, I have no subreport expression and the subreport doesn't show the data, only the master report shows it.

The autoId parameter is only defined in the report definition I never used it outside. The problem in my understanding is I need some more information over the normal way which use database connection. So I adapt the database sample for subreport. But it doesn't really help.

I understand your explanations but what me really help would be a short example how to do that all in the right manner.

Thanks

Rico

By: Lucian Chirita - lucianc

RE: sub reports data source isn't seen

2006-01-25 11:30

Ok, you can try this:

1. Break down car parts per car (I'm assuming you're not able to fetch the data like this directly):

Map carParts = new HashMap();

for (Iterator it = dataCar.iterator; it.hasNext(); )

{

AutoReportBean car = (AutoReportBean) it.next();

carParts.add(car.getAutoId(), new ArrayList());

}

for (Iterator it = dataCarParts.iterator; it.hasNext(); )

{

AutoTeileReportBean carPart = (AutoTeileReportBean) it.next();

List parts = (List) carParts.get(carPart.getAutoId());

parts.add(carPart);

}

2. Send both carParts and reportCarParts to the master report as parameters.

3. Define your subreport like this:

<dataSourceExpression>new JRBeanCollectionDataSource((List) $P{carParts}.get($F{autoId}))</dataSourceExpression>

<subreportExpression class="net.sf.jasperreports.engine.JasperReport">$P{reportCarParts}</subreportExpression>

</subreport>

HTH,

Lucian

By: slowfinger - slowfinger

RE: sub reports data source isn't seen

2006-01-26 08:50

Thanks Lucian,

it works great. This is an starting point to more.

Bye

Rico

August 22, 2006

By: ramesh - dramesh

ERROR! pls Help

2006-01-25 18:26

hi all,

when i'm trying to execute my report it is throwing follwing exception. my report have one sub report it will generate the rows dynamically.

can any one pls help.

Thanks in advance

Ramesh

Error filling print...

net.sf.jasperreports.engine.JRRuntimeException: Subreport overflowed on a band that does not support overflow. at net.sf.jasperreports.engine.fill.JRVerticalFiller.addPage(JRVerticalFiller.java:1120) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1216) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1241) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:250) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:697) at net.sf.jasperreports.engine.fill.JRFillSubreport.run(JRFillSubreport.java:444) at java.lang.Thread.run(Unknown Source)

Print not filled. Try to use an EmptyDataSource...!

August 22, 2006

By: ramesh - dramesh

Hi I'm getting This Error pls Help

2006-01-24 17:07

Hi All,

when I'm trying to compile my jrxml i'm getting follwing error , here i'm sending my .jrxml file also if any one know pls let me know

Thanks in advance,

Ramesh d

ERROR--->Exception: net.sf.jasperreports.engine.JRException: Error at (67, 18: null

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

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="MyReport"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="535"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

</variable>

</band>

</background>

<title>

</band>

</title>

<reportElement

mode="Transparent"

x="162"

y="13"

width="167"

height="25"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-1"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Transparent"

x="410"

y="14"

width="100"

height="13"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</pageHeader>

<reportElement

mode="Transparent"

x="153"

y="7"

width="38"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-2"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Transparent"

x="270"

y="8"

width="51"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="staticText-3"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

</band>

</columnHeader>

<reportElement

mode="Transparent"

x="255"

y="21"

width="100"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="128"

y="23"

width="100"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Transparent"

x="67"

y="27"

width="32"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</lastPageFooter>

</band>

</summary>

</jasperReport>

By: nsorochan - nsorochan

RE: Hi I'm getting This Error pls Help

2006-01-24 17:43

I had no problem compiling it.

I use the jdt compiler

System.setProperty("jasper.reports.compiler.class", "net.sf.jasperreports.engine.design.JRJdtCompiler")

then I just compile it

JasperCompileManager.compileReportToFile([jrxml file], [jasper file]);

hope this helps

August 22, 2006

By: Marco - mbon

Elements list in a column?

2006-01-24 15:01

Hi, I need something like this in a multicolumn report:

Element Name

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

weight

prize

part: part1, part2, part3, ..., partN

Whats the best structor for build the "part list"?

I really need a sub report?

Tanks

- mabo

August 22, 2006

By: Alexandre Gomes - alegomes

0.6.4 vs 1.1.1

2006-01-24 09:08

Why JasperReports 0.6.4 takes about 120 seconds to generate a report while 1.1.1 version takes 3547 (29 times slower) seconds to generate the same one?!

regards

August 22, 2006

By: Alexandre Gomes - alegomes

Best Practices

2006-01-24 09:04

Is there some kind of pattern for JasperReports usage? Maybe some tricks ou designs for better performance..... For example, is the JasperPrint.fillReport(String, Map, Connection) worst than JasperPrint.fillReport(String, Map, JRDataSource) ? WhatÂ´s the fastest solution?

thanks

AlÃª!

August 22, 2006

By: tvan66 - tvan66

Problem of parameter of multi values

2006-01-23 05:30

Hi,

I have a problem when my application passes a parameter of multi values from a web component such as Listbox to the SQL inside the xxx.jrxml file.

For example, I have 1,2 values of parameter journalistId. I pass journalistId to SELECT * FROM... WHERE TABARTICLESJOURNALISTS.ID_JOURNALIST IN($P{journalistId}), Jasper launch the exception that this is not a valide number. But I tried to test with the direct values in the SQL: ...TABARTICLESJOURNALISTS.ID_JOURNALIST IN(1, 2) that works, even with ...TABARTICLESJOURNALISTS.ID_JOURNALIST IN('1', '2') that works too.So I think that Jasper does not parse correctly the parameters of multi values to the SQL.

Thank you in advance for your help.

Tvan

By: Teodor Danciu - teodord

RE: Problem of parameter of multi values

2006-01-23 06:04

Hi,

Those are not query parameters that you could

be used with a PreparedStatement in JDBC, where

we put a ? for each parameter.

Using the IN function in SQL is like modifying

the query. Is like executing a different query

each time, if the list of values changes.

So you need the $P!{} syntax to include that

part of the query.

Check the /demo/samples/query sample provided

with the project.

I hope this helps.

Teodor

By: tvan66 - tvan66

RE: Problem of parameter of multi values

2006-01-23 08:47

Hi Teodor,

Thank you for the answer. You are absolutelly right. I have just changed $P to $P! and that works. The $P! means "to dynamically modify portions of the SQL query".

Thank you again.

Best wishes

Tvan

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by 2006 JR Open Discussion

Products

Explore