I found them to be very easy to install. The learning curve is in learning how to use JasperAssistant. Not because JasperAssistant is difficult, but because you have to learn Jasper Reports and and how banding, and grouping and such works. If you happen to have Crystal experience, it won’t take as much time, but I didn’t. Installing them is trivial.

I have not used them from within Cocoon. Jasper Reports should be easy to use from within Cocoon, but I don’t think you’d be able to use Open Reports from within Cocoon. It is its own separate web application. We are keeping it separated from our intranet/extranet, and just linking to it (and integrated the security between the two). It uses WebWork as a web framework. The time to port that to Cocoon would be massive.

Good luck with setup, and let me know if you have any other questions.

1. If I recall correctly, Open Report Designer did not allow filling a report with data from a Collection of business objects, which JasperAssistant did. Also, since I’m a huge fan of Eclipse, I very much enjoy having my Jasper report designer be fully integrated with Eclipse.

2. I have the open report web application as a project in Eclpse. The reports are in a reports folder in the web application. I just double click on them in Eclipse, and edit them. Then you can use deploy them however you normally would from eclipse (personally, I use the MyEclipse plugin for web app deployment).

3. Open Reports is a web appliation that should work with any application server, including WAS, Tomcat, JBoss, etc.

Jasper Reports is the reporting engine. Open Reports is a web gui front end for that engine, and Hibernate is an “object/relational persistence and query service for Java”.

Jasper Reports can fill a report from a Collection of Business Objects, which were filled with data from a relational database via Hibernate. Open Reports is a web gui which allows users to select a report, enter parameters for a report, and then schedule to report to be run, or run the report in real time, and view the results in PDF, HTML, CSV, etc.

All three work together to provide a wonderful reporting solution for a Java environment. You can do without the Hibernate if you don’t need to fill the report from business objects, and just use standard JDBC to fill the reports.

Setup issues – you say “I found them to be very easy to install”. I have not had any success with Open Reports. I tried to follow their less-than-minimal installation guide; got to the point where I dropped the expanded web app into Tomcat, rerstarted and then… the guide does not even say what you should see or expect or the app should start up. There’s also no way to know what and how to populate and use all the tables (report_* ). Is there a more comprehensive and step-by-step guide anywhere else?

Hi there,

I will only make 2 annotation to the previous postings …

To posting 3, about how to deploy the Reports … in OpenReports there is the possibility to upload the JasperReport-Templates (not the xml, but the precompiled templates) into the configured directory which stores the JasperReport-Files …

So if, like in my case, the “OpenReport-Server” is located on another machine, thats no problem, you can just upload the compiled reports over the OpenReports-Interface and than use them to show your Reports .

The second is the hint to iReport … it’s a GUI for creating JasperReport-Templates too … is easy to use and nearly uptodate with the current JasperReport-Version …
It’s a standalone-java-application so that someone who don’t use eclipse could use iReport without any other software (except java of course).
It’s also possible to bind the Template at the develop-time to several DataSources like any relational database with jdbc-support, JavaBeans, xml- and csv-files and show the filled report in all the possible output-formats (pdf, html, csv, excel and in the JRViewer itself …).

So i use iReport since a while and i think thats a realy nice program to create the needed templates to use in OpenReports (or whatelse programm .

Have a nice day …
Steffen

Re: Post 9
Yes, I did read the [minimal] installation guide (as I mentioned in my previous post) and worked through all the steps. The point was that then nothing happened, and its not clear at all what additional steps are required to have a complete application running under Tomcat. Perhaps you could write up some of the “missing steps” and post them on a blog. Failing which, where else can I look for more detailed information?

I interested with this software and I’ve download it. but i dont know how to use it
because i dont have OpenReports Administration Guide because i dont have credit card to pay it. if u dont mind can you
tell me how to use this software.
what is the function of ORD for OpenReports?

Would you tell me how to do the crosstab report in Jasper Reports?

Will be if real help

Hi Brian

Thanks for the report. One more question. How to populate the column dynamically in Jasper

I have following colunms
Name Jan-04 Feb-05…. Total

Month Column will either increase or decrease

Can we do the same in Jasper report. Do u have a sample for the same

Data comes from Database in the below format

Name Date Amount
***************************
Dis1 10/04 5000
Dis1 11/04 2000
Dis2 10/04 3000
Dis1 11/04 3000

I am rearranging the same using Arraylist and hashmap like this format

Name 10/04 11/05
**********************
Dis1 5000 2000
Dis2 3000 3000

In the above example dates are dynamic
Will have 2 months of date or one year depending on user selection

Currently we are planning to user Jasper and we use J2EE (EJB, Servlet and JSP) and for passing the result to jsp we are using Arraylist of Hashmap

Do you have any sample code that will get the value in Arraylist of Hashmap and pass the same to Jasper report?

Can you paste one example in your web site?

I am also attaching a sample ArrayList/Hashmap object

[{Dec 04=559230, Jan 05=530845, Name=4Spine, LLC, Total=1888085.0, Feb 05=396010, Nov 04=402000},

{Jan 05=23000, Name=Act 2 Medical, Total=44800.0, Feb 05=21800},
{Dec 04=56615.2, Jan 05=83141.6, Name=David Tyre, Inc., Total=215895.2, Feb 05=51889.6, Nov 04=24248.8},
{Dec 04=103258, Jan 05=78625.25, Name=Gilman Surgical, Total=359186.75, Feb 05=68564.2, Nov 04=108739.3},
{Dec 04=159679, Jan 05=93790, Name=Gulf Coast Orthopedics Inc., Total=568842.3, Feb 05=107253.3, Nov 04=208120},
{Dec 04=201400.6, Jan 05=162199.2, Name=ISpine, Total=606636.2000000001, Feb 05=104127.8, Nov 04=138908.6},
{Dec 04=37655, Jan 05=83998, Name=Intramedix Medical Inc., Total=275657.0, Feb 05=92740, Nov 04=61264}]

I haven’t tried that before, so I really don’t know. In the class I’m currently writing, I convert a HashMap to an ArrayList (the values of the HashMap), and send that to Jasper, but I’m not sure if you could access an ArrayList of HashMaps.

I’m sure using CSS is possible, however, generally the point of the Jasper XML file is to describe to Jasper how you want to the report to look. It then creates the HTML or the PDF, or whatever your export type is, and ensures that export type looks like you’ve described in the Jasper XML. All the GUI’s like JasperAssistant and iReport, allow the user to describe the look. CSS is used by Jasper in the HTML it creates, but changing that would be counter to how Jasper is designed.

Hi Brian,

I’m writing a Swing based desktop application that needs to produce a 10 page PDF document. The document is composed of various sections containing paragraphs of text from various different datasources.

I’ve tried to produce the document using Jasper and iReport, however I’m reaching the conclusion that the format of my document is too complex for Jasper/iReport.

I’ve constructed various custom datasource classes that implement the JRDataSource interface to return the contents of the various sections within the document. In iReport, I’ve created a collection of subreports for each of the different sections. Each subreport is associated with a custom datasource.

The problem I’m experiencing is that the layout of the resultant PDF does not reflect what I’ve designed in iReport. The subreports appear overlapped instead of appearing in the sequence I’ve designed in iReport. I’ll need to produce about 8 of these subreports for the entire document.

Do you think its possible to produce this type of multiple page documet with various subsections using Jasper/iReport or is this too complex? Would JasperAssistant be more suitable?

I’m thinking maybe I should be using a framework like iText?

Thanks in advance.

Yes, Open Reports is fantastic because it is a good simple reporting framework. I come from a Visual FoxPro background and have a some conversion program to translate a FoxPro report directly into the band based XML definition. It works like a dream because both reporting methods use bands and it is only a matter of converting the band scaling between the two types of reports. The SQL to drive the report is simply inserted into the XML.

The problem I have found is in the use of American date format in Open Reports but I am sure that this can be solved.

Regards

Anton

A few of the reports I had to create, required a form of cross tab reporting. So I created a framework within Open Reports to accomplish this. It is report specific, but is very simple to implement per report. It works on the premise that Jasper can populate the report from a Collection of objects. So instead of populating from a JDBC results set, a CrosstabAction is used to convert the JDBC result set into a generic Collection which the Jasper report uses to fill itself. The Action reverses the data from column to row, or performs any other type of “rearrangement” of the data that you may need to do that can’t be done via SQL. We have used it now for two reports and once I figured out the idea and the framework in the first report, the second report only took a few minutes to implement.

Hi,
I am using Jasper Reports for my current project. Things are working fine except for one thing.
When i generate a Jasper Report, it opens up on the server not on the client.
Please tell me what I need to do to open up a Jasper Report on the client.
Right now it is opening up in the server, I need to open it on the client.
My code is as follows:

JasperDesign gratuityReportDesign = JasperManager.loadXmlDesign (“../server/default/deploy/reports/GratuityConsoleReport.jrxml”);

JasperReport gratuityJasperReport = JasperManager.compileReport (gratuityReportDesign);

Map parameters = new HashMap ();

parameters.put (“Title”, “Gratuity Report”);

parameters.put (“FromDate”, ( (GratuityConsoleInputDataVO) data )
.getFromDate ());

parameters.put (“ToDate”, ( (GratuityConsoleInputDataVO) data )
.getToDate ());

parameters.put (“LOGO”,
“../server/default/deploy/reports/logo.jpg”);

conn = DataAccessUtil.getConnection ();

JasperPrint jasperPrint = JasperManager
.fillReport (gratuityJasperReport, parameters, conn);

JasperViewer jasperViewer = new JasperViewer (jasperPrint, false);

jasperViewer.show ();

This code opens the report on the server. Please tell me how to open it on the client.

Thanks alot
Sandeep

Hi,

there is a user requierement to be able to generate ad-hoc reports. Something like user may decide which columns to render, or even decide the font size, padding, and so.

Do you know any solution, which will satisfy this requirement?

(we’re using jasperreports)

JasperReports is not intutive enough, you need to have allot of knowlegde of JAVA to run for example your own applet implementation, this is the fact with most opensource tools (not php, apache, they are really good documented, but this)

I’ve been evaluating JasperReports and found it almost answers all our requirements. For us to commit to it we need to know the following:

- How easy it would be to add a feature that would allow to save instances of report templates, preferrably in a database table? In this case, an instance would be a group of parameters values.

We need a mechanism for users to 1) define this group of parameters 2) save the instance parameter values in the database 3) pull up this instance (predefined values of parameters) from the database. This feature would allow users to avoid specifying parameter values every time through the UI.

The workaround is to save every instance as a separate report file. But this solution isn’t scalable when targeting an ASP market.

performance issue in jasperreports , jaspereports is fine for reports contain minimum number of records , when go for large number of records application performance will down , any one can help me , please very urgent

As for adding or removing columns, there are two options. First, you can use conditionals as the column expression to dynamicaly choose which field to populate a column with. I used this in one report that can have three different looks. It checks a passed parameter to determine which report it is, and from that alters the header for each column, and the value for each column.

The second method would be to alter the jasper report xml based on your critera, then compile it and run it. I do a lot of xml creation, so that part of it I don’t have a problem with. However, I have not compiled a Jasper report on the fly and I would worry that doing so would be a performance hit.

Other than that, I do not believe that Jasper has any features for dynamically designing reports on the fly.

Del Thompson – the best way to get started with Jasper Reports is to download the demo project, put it in Eclipse, and play around with running the reports. That is how I got started.

To get the samples, go here: http://sourceforge.net/projects/jasperreports

Click on jasperreports, and then choose to download the jasper project zip file.

hi,
I am planning to use Jasper Reports insted of Crystal Reports in my new project can u plz tell me Jasper Reports suported to .net technology

VJ,

When I first did an export to CSV/Excel I was just as surprised as you were about the result. And to my knowledge, there is nothing you can do about, other, than to add in a suppression expression for every element you wouldn’t want in the CSV/Excel (which I think is way too much work). But, keep one thing in mind before you label this a bug. JasperReports is not a database tool. It is a reporting tool. All the XML that describes a Jasper Report would be worthless if all you wanted was a data dump from an SQL statement.

That can be done so easily without JasperReports, that it really makes no sense to use a reporting engine for a simple dump like that. I’m not sure who uses the CSV/Excel versions, as they strike me as very useless, but once I remembered what the point of Jasper Reports is, it didn’t surprise me as much.

Brian

You pass in a parameter to the Jasper Report that tells it how its being exported (PDF, XSL, etc). Then in the Print When Expression for each element, you check that parameter to decide if you want it printed.

Brian,
To build jasper for reports that have dynamic columns, i am building the jasper using java code.But if the value is null its throwing,
net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : null
Source text : $F{col8}
at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:407)

but the same design works with non null values data.

This is the code thru which i build detail part.
public static JRDesignTextField buildTextField(Class clazz, int xcorod,
int ycoord, int width, int height, JRFont fontType, String fieldName) {
JRDesignTextField textField = new JRDesignTextField();
textField.setBlankWhenNull(true);
textField.setStretchWithOverflow(true);
textField.setX(xcorod);
textField.setY(ycoord);
textField.setWidth(width);
textField.setHeight(height);
textField.setTextAlignment(JRTextElement.TEXT_ALIGN_RIGHT);
textField.setFont(fontType);
JRDesignExpression expression = new JRDesignExpression();
expression.setText(“$F{” + fieldName + “}”);
expression.setValueClass(clazz);
textField.setExpression(expression);
return textField;

}

Kindly let me know where the problem is..
Thanks
VJ

hi,
We are using Jasper Assistant for generation of reports, it is a good tool as an eclipse plugin to generate reports, but we are having problem with it that is The reports which we print does not have a line in the header which we require,how to print lines in our report.

Please help us.
Bye

Is the Jasper Assitant free ?
Which took can i use to create reports.
Jasper Assitant or Open report designer

Hi Brian,
Should I try to declare more of my methods to be static?How would i know i am overusing static methods? What are ideal scenarios where i can use static methods? Say in my module, i have a separate database entity file wherein i put all the methods which access database.Is it ok to declare all the methods static?
Say i have ReportDb.Java and i have
public static ResultSet getDataResultset(String storeprocName){
//Code to access DB and return resultset
}
kindly let me know..

Sunil,

There is a JRXlsExporter() in Jasper.

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, ds);
JRXlsExporter exporter = new JRXlsExporter();

ByteArrayOutputStream xlsReport = new ByteArrayOutputStream();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, xlsReport);

exporter.exportReport();
System.out.println(“Sixe of byte array:”+xlsReport.size());
bytes = xlsReport.toByteArray();

response.setContentType(“application/vnd.ms-excel”);

response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();

Brian

Dear Brian,
I am really very thankfull for your co-opration,
But the problem still remain, because i could’nt found JRXlsExporter() in my jasper code, So could you please guide what should i do to solve this problem.
Thanx a lot.

Sunil

Does anyone have experience with using an html document as a source field? I have database text items that store html documents that need to be included into a report. The report currently prints out the tags.

I changed the field to styledtext=”true” which stops the tags from printing but does not produce the proper result. For example, if the html has a tag I would expect a new line. Currently, nothing happens. Any idea how to make the work.

Thanks for your help.

John

hi all

i have the same problem with a html field source, i try to with the styledtext=”true” clausule and it print a blank line for each html tag. I try with the last version of JasperReport and nothing.

Thanks a lot for your help.

Franklin

I’m working with Jasperreport-1.1.0 and i’m using JasperAssistant. Whenever i try to create a custom data source i get the following error:

Data Source failed
Reason:
Failed to load the specified provider class:
datasource.ExampleDataSourceProvider

The location of the file in my project folder is webapp/WEB-INF/classes/datasource/ExampleDataSourceProvider

This is my code:
public class ExampleDataSourceProvider extends JRAbstractBeanDataSourceProvider{

public ExampleDataSourceProvider() {
super(CustomBean.class);
}

public JRDataSource create(JasperReport report)
throws JRException {
ArrayList list =new ArrayList();
list.add( new CustomBean(“Berne”, new Integer(9), “James Schneider”, “277 Seventh Av.”));
list.add( new CustomBean(“Berne”, new Integer(22), “Bill Ott”, “250 – 20th Ave.”));
list.add( new CustomBean(“Boston”, new Integer(23), “Julia Heiniger”, “358 College Av.”));
list.add( new CustomBean(“Boston”, new Integer(32), “Michael Ott”, “339 College Av.”));
list.add( new CustomBean(“Chicago”, new Integer(39), “Mary Karsen”, “202 College Av.”));
list.add( new CustomBean(“Chicago”, new Integer(35), “George Karsen”, “412 College Av.”));
return new JRBeanCollectionDataSource(list);
}

public void dispose(JRDataSource dataSource)
throws JRException {
// nothing to dispose
}

}

I’d really appreciate your help. Thanks in advance.

Cherry

Subject: localized resources

Hi all,
Is it possible to use a field value as input to a localized resource value.

I have a code coming from the database $F{CODE}.

I want to retrieve the resource bundle value for this code using something like $R{CODE} or $R{$F{CODE}, but neither seems to work.

Has anyone managed to do something similar ?

Thanks,
Alan

Hi team

I am using jsp to generate pdf. i generate the pdf file on the server, but i would like it on a outputstream.

But in JSP i am unable to open the output stream.
also i need to open the pdf in a new window with out distrubing the application.

jasperPrint = JasperFillManager.fillReport(report, parameters,conn);
byte[] pdfasbytes = JasperExportManager.exportReportToPdf(jasperPrint);

JRPdfExporter exporter = new JRPdfExporter();
ByteArrayOutputStream pdfReport = new ByteArrayOutputStream();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, pdfReport);

exporter.exportReport();

pdfasbytes = pdfReport.toByteArray();
response.setContentLength(pdfasbytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(pdfasbytes, 0, pdfasbytes.length);
ouputStream.flush();
ouputStream.close();

Subhashini, you need to set the “Content-Disposition” header in your response object. In doing this you then have the ability to tell the browser that the response content is an attachment (causing it to open in another window).

Like so:
response.setHeader(“Content-Disposition “, “attachment; filename=”+theFileName);

using the filename, your client should be able to open/save the report using a more friendlier filename rather than the page name (which would be the default).

Does anybody know how to tell when a generated report contains no data before sending it to the client?

Hai Brian,

how to create on the fly query in JR ?

example :

1: SELECT * FROM user a
2: inner join tables_priv b on b.host = a.host
3: Where user = ‘anyone’

i would like to change line 2 in this query to become
inner join host b on b.host = a.host

why i use like that because i like to use one JR file and i can get two result report, of course i must use an alias for field name.

TIA,

andy

I how to create a matrik Report like this

Jan Feb April
=========================
David 1 2 3
Guest 2 5 1

TIA,

Andy

Hi,

I have seen few questions above asking about how to send a collection object (Hashmap, ArrayList) to fill a report; but there is no reply on this.
I can do this by passing data source, Result set but my requirement is to send data in any collection object to fill in report as my results are out come of many queries.

Please share your thoughts.

Thanks,
Sandeep

Hai Brian,

you have given this code for create pdf file at client side..

ReportWriteProvider reportWriteProvider;
byte[] pdfByteArray = JasperExportManager.exportReportToPdf(jasperPrint);
response.setContentType(”application/pdf”);
response.setHeader(”Content-disposition”, “inline; filename=” + report.getName() + “.pdf”); response.setContentLength(pdfByteArray.length);
ServletOutputStream out = response.getOutputStream();
reportWriteProvider.sendPDFToStream(pdfByteArray, out);

in the above code what type of obeject “report”(report.getName())..

don’t mind could you explain it…

thanks in advance..

regards,

Brahma

Hello,
I have been using jasperreports for some time now.
I am facing some problems while designing my report.
1. My report has varied no.of columns i.e. it could contain 2,3 or 4 columns. I cant figure out as how to adjust the no.of columns dynamically within the same page width.
Say, if my page width is x, then x should be sum of either c1+c2 or c1+c2+c3 or c1+c2+c3+c4.
2. Second problem is a similar one, only difference would be that the no.of columns is fixed i.e but their width is supposed to the varied.
3. Finally, 2 sets of data to be displayed in MainHeaderGroupFooter, with varying no.of rows.
Now if I give a fixed height, both these overlap.

Your help is much appreciated.
Regards,
Dev

mi problem is with the query

i’m using ireport but i do not know how write the sql syntax for LIKE, y tried all the ways and when excute the report show me nothing, totally blank

SELECT [_Empleados].EM_Nombre, [_Empleados].EM_RFC, BienesMuebles.BM_Descripcion, BienesMuebles.BM_NumeroInventario, BienesMuebles.BM_NumeroSerie1, BienesMuebles.BM_NumeroSerie2, BienesMuebles.BM_Observaciones, [_Departamentos].DP_Descripcion, BienesMuebles_Empleados.BMEM_FechaInicio FROM BienesMuebles INNER JOIN ((_Empleados INNER JOIN _Departamentos ON [_Empleados].DP_ID = [_Departamentos].DP_ID) INNER JOIN BienesMuebles_Empleados ON ([_Empleados].EM_ID = BienesMuebles_Empleados.EM_ID) AND ([_Departamentos].DP_ID = BienesMuebles_Empleados.DP_ID)) ON BienesMuebles.BM_ID = BienesMuebles_Empleados.BM_ID WHERE ((BienesMuebles_Empleados.BMEM_FechaFin) Is Null) AND BienesMuebles.BM_NumeroInventario Like $P{INVENTARIO};

some ideA?

Edgar,

To do a like statement using a parameter you have to do it like this:
like $P{INVENTARIO} + ‘%’

This should work.

hai,

in my client computer i can not show print dialog from JasperReport.

i am using a Tomcat 5.5.x, is there something wrong in Tomcat. Because if i running Tomcat from eclipse printdialog will showing

any suggestion ?

TIA,

Andy Susanto

Hi, i am getting this exception when trying
to save the report to pdf using the “save as” button in JasperViewer.
(i have itext-1.3.jar)

Exception in thread “AWT-EventQueue-0″ java.lang.NoSuchMethodError:
com.lowagie.text.pdf.PdfContentByte.transform(Ljava/awt/geom/AffineTransform;)V
at
net.sf.jasperreports.engine.export.JRPdfExporter.exportText(JRPdfExporter.java:1469)

part of the code :

Statement stmt = database1.createStatement();
ResultSet rs = stmt.executeQuery (wsql);

JRDataSource jrRS = new JRResultSetDataSource( rs );

HashMap hs = new HashMap();
JasperPrint prt = JasperFillManager.fillReport(pathRelatorios +
relatorio + “.jasper”, hs, jrRS);
JasperViewer jrviewer = new JasperViewer(prt, false);
jrviewer.setVisible(true);

Thanks

Can you help me setup Openreports.

I am using Linux (RH). What do I need to do.
I downloaded Open Reports and Open Reports -Tomcat , but it seems like it is setup for the windows platform.

help!

Anirban,
Did you follow all the steps for setting up the database? The install guide lists out all these steps, and that error you are getting seems to imply that you don’t have the tables its looking for.

andy susanto,

I’m not really sure what print dialog you are looking for. Are you using a graphical interface like JasperAssistant, or are you running a report from within Tomcat? Any report you want to print from within Tomcat would use your browsers print functionality.

hi there, first of all, im glad to see an active thread about jasperreports. their own sites seem abandoned (can you blame them…). my problem had come a few times across but no answer. i have a fully working program (servlets/ireport/jasperreports) but i cant get the export pdf and print dialog to go to the client side. always it comes up on the server.

what can i (we) do to send it to the client. can we keep a central topic here?

please help, it is driving me insane in the membrane…:-)

thanx in advance

Frederik

Hi there,

I found a solution to my problem: the client side doesnt get a printdialog but the server side does. i used this code to export it to a pdf in the client sides browser. now the client can save and print it. only thing is that the font is standard (all my bod texts are normal now), but it works. i hope someone finds this usefull.
if someone has an addition or improvement please tell.

JasperPrint print = JasperFillManager.fillReport(bestandsnaam, reportParam, c);
//JasperPrintManager.printReport(print,true);
//JasperViewer jv = new JasperViewer(print);
//jv.viewReport(print);

byte[] pdfasbytes = JasperExportManager.exportReportToPdf(print);

JRPdfExporter exporter = new JRPdfExporter();
ByteArrayOutputStream pdfReport = new ByteArrayOutputStream();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, print);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, pdfReport);
exporter.exportReport();

pdfasbytes = pdfReport.toByteArray();
response.setContentLength(pdfasbytes.length);
//response.setHeader(“Content-Disposition”, “attachment; filename=”);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(pdfasbytes, 0, pdfasbytes.length);
ouputStream.flush();
ouputStream.close();

Hi all,
are anyone work with resource bundle in combination jasper report and ireport.
If anybody has some simple example of it, please send me the reference.

Thanks in advance.

Hi everyone

Im working with a javabean set datasource
my bean has a java.util.ArrayList with beans inside and i need to iterate the arrayList in a group to show the details, can you help me?

Thanks

pls tell me how to call a stored procedure/function from jasper report

hey,
Im using jasperreports and facing 2 probs…firstly the inputstream doesnt seem to read the jrxml; file and the compile manager throws an exception…secondly the query needs to b satisfied wit a parameter which i have given as follows[CDATA[select distinct a.ArticleNumber,a.Name,a.Note,b.ProductSpecification,b.ProductionDate,b.ExpirationDate,b.LotNumber,c.ColorLevelName

,d.TrueValue,e.Name as UnitName,f.Name as ParaName,f.Calculated,g.ProductionOnlyParameter,h.Name as StatusType from QCColorLevel as c inner join QCType as a on

a.IDQCColorLevel=c.ID inner join Lot as b on a.ID=b.IDQCType inner join LotParameterUnit as d on b.ID=d.IDLot

inner join ParameterUnit as e on e.ID=d.IDParameterUnit inner join QCTypeParameterUnit as g on e.ID=g.IDParameterUnit

inner join Parameter as f on e.IDParameter=f.ID inner join StatusType as h on h.ID=b.IDStatusType where b.LotNumber like $P[LotNumber]….yet it throws an exception of an error in preapring the statement…any ideas ppl

Hi,
subject: Custom Datasource – Subreports
situation: The master report uses a JRDataSource (say MasterDS) with fieldA and fieldB. While filling the master report, the MasterDS also fills a bean which must serve as a custom datasource for a subreport with fieldC. This subreport is called in the report Summary . problem: It’s strange but when running, Jasper needs getFieldA() and getFieldB() in the bean although these fields are not needed in the subreport.First I’ve tried to use a second JRDataSource instead of a bean but with the same result.
Questioin: Is there some way to use multiple total independant datasources within the same report-subreport. If so, please any hint would be welcome as this whole thing keeps me busy for 2 days.

Thanks and have a nice day,

Rose

concerns my post of 21th april:Custom Datasource – Subreports.
My problem is solved, i’ve made a very stupied error. Meanwhile: Jasper – iReport is great, thanks!
Rose

Hi
i am using iReport to create reports.
i am unable to fill the subreport with data. it compiles but when i execute, it gives the error
” [subreport subreport filler] WARN query.JRJdbcQueryExecuter – The supplied java.sql.Connection object is null.”
when i run the subreport independently with a default value of the parameter, it gives the error
“Error filling print…
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘{EMPID}’ at line 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
…”

How do i solve this ?

when i use jasper for filling crosstab reports i get the fillowing error:
NESTED BY :
net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset
at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:638)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134)
at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at com.tcs.rdv.rdm.rdc.XYZ.reportgenerator(XYZ.java:108)
at com.tcs.rdv.rdm.rdc.XYZ.main(XYZ.java:143)
Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed.
at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280)
at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634)
… 11 more

Hi,
I try export report to pdf file but i met this error

>>java.lang.IllegalAccessError: tried to access >>field org.apache.commons.digester.Digester.log >>from class >>org.apache.commons.digester.SetNestedProperties>>Rule$AnyChildRule

I haven’t found the way to fix it yet. Can anybody help me ?

Regards,

Tu

Hi everyone

Im working with a javabean set datasource
my bean has a java.util.ArrayList with beans inside and i need to iterate the arrayList in a group to show the details, can you help me?

Thanks

Hi Frederik,

Even i am facing the same problem printing the report in the client side..
Can you please explain it little briefly about printing it in client side

With Regards
SeshaGiri.V

Regarding AUTHOR COMMENT for stored procedures
127. by Brian Burridge, @ May 26th, 2006

I am doing a research for using Jasper with stored procedures. Here are some ideas:

1. JavaBeans datasource could be used instead of queries. You can fill JavaBeans objects external to jasper calling stored procedures and pass this to jasper xml templates. Hibernate/Jasper integration is using it. For example:

http://www.jroller.com/page/wakaleo/?anchor=using_hibernate_queries_with_jasperreports

2. There is something written in the ‘JasperReports Ultimate Guide’ http://jasperreports.sourceforge.net/more.docs.html you can see table of contents 9.4.2

The problem is you have to pay to see the content. I didn’t buy it yet.

Vector abcd[] = new Vector[3];
abcd[0] = new Vector();
abcd[1] = new Vector();
abcd[2] = new Vector();

abcd[0].add(“srikanth”);
abcd[0].add(“naga”);
abcd[0].add(“vani”);
abcd[1].add(“subadhra”);
abcd[1].add(“subadhra”);
abcd[1].add(“subadhra”);
abcd[2].add(“devui”);
abcd[2].add(“devui”);
abcd[2].add(“devui”);
Object os[] = abcd[1].toArray();
System.out.println(“this is os length”+os.length);
JRMapArrayDataSource vd = new JRMapArrayDataSource(os);
parameters.put (“Title”, “Gratuity Report”);
parameters.put(“Logo”,”C:/Documents and Settings/srikanth.ETG/Desktop/World_s_Tallest_Man.jpg”);
jasperReport = JasperCompileManager.compileReport(“C:/Documents and Settings/srikanth.ETG/Desktop/d.jrxml”);
//jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,ac);
jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,vd);
//JRPdfExporter exporter = new JRPdfExporter();
setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);
setParameter(JRExporterParameter.OUTPUT_FILE_NAME,”C:/Documents and Settings/srikanth.ETG/Desktop/classic1.pdf”);
System.out.println(“{{{{}}}}}}}”);
//exportElements(tm);
System.out.println(“{{{{}888}}}}}}”);
exportReport();

JasperViewer jasperViewer = new JasperViewer (jasperPrint, true);
jasperViewer.show ();

}
catch(Exception e)
{
e.printStackTrace();
}
}
public void addVectorToReport(Vector Elements)
{
try
{
//
}
catch(Exception e2)
{
e2.printStackTrace();
}

}

public static void main(String args[]) throws Exception
{
example e = new example();
System.out.println(“AFTER”);
}
}

I am adding the elements in mapArrayDataSource & MapCollectionDataSource it is compied successfully & executed successfully but the objects are not adding in thr report

We report to an organization on a complex form that they provide — the form is available as a pdf. In moving the report to Jasper, can work the of duplicating all of the graphical elements be avoided by pasting the pdf into the background and layering the data fields on top as unframed transparent objects? If this could be done, the data (mainly checkmarks) would appear in the right place in the printed view.

how to sequence of number in each column in IReport(ie. Serial number of each column)

java.lang.NoClassDefFoundError
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:141)
java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:62)
net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:58)
net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:404)
net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:92)
net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:74)
net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:113)
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:83)
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:428)
com.etisbew.rezengine.report.JSPReports.processRequest(JSPReports.java:579)
com.etisbew.rezengine.report.ReportController.processRequest(ReportController.java:371)
com.etisbew.rezengine.servlet.REServlet.doPerform(REServlet.java:502)
com.etisbew.rezengine.servlet.REServlet.doPost(REServlet.java:237)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

To Brian Burridge,

yes, i will try this. i want the each line number
in the detail band, when each line is created

by sunil

i m getting ….java.lang.NoSuchMethodError: com.lowagie.text.pdf.PdfContentByte.transform(Ljava/awt/geom/AffineTransform

at net.sf.jasperreports.engine.export.JRPdfExporter.exportText(JRPdfExporter.java:1512)
at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:523)
at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:487)
at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:452)
at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:260)
at net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfStream(JasperExportManager.java:1

when i m going to show report in a PDf format as a servlet response .My code is as follows.

InputStream i=cl.getResourceAsStream(“itemReport.jrxml”);

jasperReport = JasperCompileManager.compileReport(i);
jasperPrint=JasperFillManager.fillReport(jasperReport, new HashMap(), new JRResultSetDataSource(resultSet));

JasperExportManager.exportReportToPdfStream(jasperPrint,out);

here out is OutputStream object passed by a servlet.
Please help me out.i have deployed all the required jars also.

[last post got cut off...sorry]

, etc.

Any ideas or suggestions would be greatly appreciated.
-eric-

When i create crosstab report…

The following types of error occurring:

Error filling print…

net.sf.jasperreports.engine.JRException: Crosstab data has already been processed.
at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280)
at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134)
at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)
at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674)
at java.lang.Thread.run(Unknown Source)

NESTED BY :
net.sf.jasperreports.engine.JRException: Crosstab data has already been processed.
at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280)
at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134)
at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)
at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674)
at java.lang.Thread.run(Unknown Source)

NESTED BY :
net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset
at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:638)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134)
at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:248)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:747)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:644)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)
at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:674)
at java.lang.Thread.run(Unknown Source)
Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed.
at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:280)
at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:634)
… 12 more
Print not filled. Try to use an EmptyDataSource…!

After this i write “crosstab-1″ in summary band
Then 3 error occurring:

Errors compiling D:\inteacc\reports\crosstab1.jasper! it.businesslogic.ireport.ReportClassLoader@f3ff7d

net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
1. crosstab cannot be resolved
value = (java.lang.Boolean)(crosstab-1);

2. crosstab cannot be resolved
value = (java.lang.Boolean)(crosstab-1);

3. crosstab cannot be resolved
value = (java.lang.Boolean)(crosstab-1);

3 errors

at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193)
at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:131)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127)
at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109)
at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:473)
at java.lang.Thread.run(Unknown Source)

Please help with proper instruction
Thanks
mainur

Hi,

is it possible to set the number of items to show in the detail band in one page.?
Any ideas or suggestions would be greatly appreciated.

Does anyone know of any tutorial for using Jasper Reports with Struts??

hi,
i am developing a web application in struts using ‘Myeclipse’ .Now i have developed a jasper report using ireport tool but i dont know how to integrate with a JSP page(or to export it to pdf format).
can anyone help me??

I am trying to filter a string variable that looks like this {Value} in the text field box of a report.
For instance, I want to only return records that have the entry “Force” in the database record field.
Does anyone have any suggestions?

Thanks for your reply for the solution’ How to use Oracle function’ in Jasper.
But How can I use Oracle function in report desiners like iReport, JasperAssistant. Or should we use this directly in Jasper file without using any Designers? When I am suing your syntax to call the function it is showing invalid identifier error.

Hi Brian Burridge,

I understood that you have incorporated some reports which calls the oracle stored procedure. But I am getting the following error while executing the report which calls an oracle stored procedure. I want to know where should I edit to evoid this exception?

Error creating report: net.sf.jasperreports.engine.JRException: No query executer factory class registered for plsql queries. Create a propery named net.sf.jasperreports.query.executer.factory.plsql.
Please help me!

Thanks
Nuruthin Ahammed

How can genereate dyanamic columns in jasper reports using iReports

Hi All,
In my report, i’m able to remove the column by using removeColumn() of ColumnTransform class.
My problem is, after removing the column the space remains blank.

I want to arrange the remaining columns dynamically. Is it possible, if so how?

rearrange() is not working properly, means it is not suppressing the space, Have got any idea?

Any idea will be highly appriciated,

Rehgards,
Syed

Hello,

Thanks for the article:

you end the article by saying, and I quote:
“In the end, with JasperReports and OpenReports, the only thing you have to worry about is creating the SQL to get the data. After that, it takes little work to provide a nice looking report in multiple formats on a web site”

So Are you meaning that the best way, easiest and fastest, is to use OpenReports !?
That you only need to download openreports and nothing else ?
If not so, do you mean that the ‘JasperAssistant’ is as easy to use as OpenReports ?

I have never been in contact with a reporting system before, but seeing the benefit when coming in contact with openreports instead of having to write everything else in j2ee.

regards, i
are these reports socalled crystal reports ( if I talk Oracle) ?

Hi,

I am having trouble in executing stored procedure which accepts multiple values to a parameter. I could run if it is single value from iReport1.2.7 and Openreport 2.0, But when I make that MulitValue, I could not execute the stored procedure, I tried appending ‘$P!{Team}’ etc… What I am missing..

Newbie questions. I use iReport to create the jrxml files.

1. Where do I put the jrxml files after I create them? Or do I use the jasper files that iReport makes?

2. When I run the ant script to build the war file, what do I do to make sure my jrxml or jasper files are part of the openreports application?

3. Is it possible to force openreports not to use spacer gif images to lay out the html version of the reports that use the jasper files? I hate spacer gifs.

Hi Brian
I am a software engineer. My company makes a stand alone application. I introduced them to Jasper and implemented it. In the coming future ie. around 2007 we intend to take our application to the web. This would involve a huge effort and we would also want to be able to present our reports over the web. In kind of getting prepared for that I stumbled on open reports which sounds promising. Now the issue.

Our jasperreports do not connect to the database. We supply it with Java’s business objects and it reads them to populate the report. Can open reports accept these objects like an arrayList, hashmap or vector ? It seems from your blog that it cannot and it seems you changed the code of open reports to do so. If so, I do not want to reinvent the wheel and was wondering if you could provide me with your version of open reports. Please confirm my suspicions, thanks for your time.

Do you think Jasper Report is a good tool for export a report as XLS?

I just need to export the detail section of my reports (not title, images, lines between rows, foot section, etc.) The exported sheet should be simple and ready for work.

I’ve heard selective export is a weak point of JRreport. You have to export the whole report, getting a complex sheet full of empty narrow cols to preserve coordinates of non-relevant elements (images, corporative information, decorative lines, etc.) I suppose exporting as CVS is affected by similar limitations…

Do you think this is a real problem?
Thanks in advance,
José Luis

I am using Jasper Reports for my report building it workd completely fine with windows buton Unix platform it gives Broken pipe Error after analyzing more and the thread Dump we found :

– Holding lock: java/lang/NumberFormatException@0×200430d0[thin lock]
at java/lang/Throwable.(Unknown Source)@0×40c8ba13
at java/lang/Exception.(Exception.java:41)@0×40c8b9f5
at java/lang/RuntimeException.(RuntimeException.java:43)@0×40c93655
at java/lang/IllegalArgumentException.(IllegalArgumentException.java:36)@0×40c93645
at java/lang/NumberFormatException.(NumberFormatException.java:38)@0×40c93635
at java/lang/FloatingDecimal.readJavaFormatString(FloatingDecimal.java:983)@0×431b1946
at java/lang/Double.parseDouble(Double.java:220)@0×470de681
at net/sf/jasperreports/engine/export/JRXlsExporter.exportText(Optimized Method)@0×447ecf91
at net/sf/jasperreports/engine/export/JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:367)@0×4709cb23
at net/sf/jasperreports/engine/export/JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:289)@0×47097918
at net/sf/jasperreports/engine/export/JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:135)@0×47096e1a

could you please suggest me Why do we get Number Format Exception that causes Thread Lock and hence Broken Pipe Error

Hi All,

I am using jasper for reporting in my application. The application “war” file is deployed in WebSphere, And it is failing during report initialization.

Can any body plz tell me, why I am getting this error. Probably what are the suspected cause behind this.

Thanks in advance,
Sanjib

[1/16/07 17:53:14:562 IST] 5639e40e WebGroup E SRVE0020E: [Servlet Error]-[reports]: Failed to load servlet: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
1. java.sql.Connection cannot be resolved to a type value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

2. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

3. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

4. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

5. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

6. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

7. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

8. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

9. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

10. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

11. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

12. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

13. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

14. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

15. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

16. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

17. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

18. java.sql.Connection cannot be resolved to a type
value = (java.sql.Connection)(((java.sql.Connection)parameter_REPORT_CONNECTION.getValue()));

18 errors

Hi,
I need generate dynamic columns using JasperReports. In this moment i’m using iReport for create the templates, but this are statics templates, and i need dynamic columns , dynamic xml source that can modified the templates dynamically
if Someone has a solution please, help me.
Thanks!!

I also need to make a report with a pdf as background, so i can write uppon it. Anyone knows how this is possible ?

Thanks in advance

Nuno Silva

Hi Brian;
I have used jasper reports before in JBOSS and had no problems, however, when trying to generate a simple report in websphere, I get the following error:
TRAS0014I: The following exception was logged java.lang.reflect.InvocationTargetException: java.lang.NoSuchMethodError: com.lowagie.text.pdf.PdfContentByte: method transform(Ljava/awt/geom/AffineTransform;)V not found

I have chopped and changed the code and the report six ways from Sunday, yet the same error occures.

Here is the code:
try{
JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile);
JRCsvDataSource ds = new JRCsvDataSource(new FileReader(dataSourceFile1));
ds.setColumnNames(getFAISColumns());
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, ds);
int read = 0;
System.err.println(“TOTAL PAGES = “+jasperPrint.getPages().size());
byte [] bytes = new byte [1024];
ByteArrayInputStream is = new ByteArrayInputStream(JasperExportManager.exportReportToPdf(jasperPrint));
response.setContentType(“application/pdf”);
response.setHeader(“Content-disposition”, “inline; filename=report.pdf”);

outputStream = response.getOutputStream();
while((read = is.read(bytes)) != -1){
outputStream.write(bytes, 0, read);
}
outputStream.flush();
outputStream.close();
} catch (Exception e) {
e.printStackTrace();
}

I have to change dynamically the number of columns in report.The problem is like the following.
There is a list box in jsp page,that contains the column names.User selects columns in list box that are printed in report.Therefore,i must create report dynamically.How can i organize this report using jasperreport?

Hi Brian,

I am trying to call a DB2 stroed procedure from Jasper Reports.

I can successfully call a stored procedure which only requires input parameters but can’t work out how to call one which requires both input and output parameters.

Any ideas?

Hi

Have you tried working with the Velocity templates? I’m drowning at the moment – I got OpenReports up and running and it is displaying reports via Stored Procs. Now I need to add drill-down reports with Velocity it seems, but I can’t upload the .vm files – do I need to precompile them somehow? I can’t even seem to upload normal .jasper files – I’m using v2.2 of OpenReports and v1.3.0 of iReports to compile my JasperReports.

Any help would be greatly appreciated.
Thanks!

Hi,
I have tried Jasper reports and BIRT reports in last 2-3 months. I found BIRT reports are far more better than the Jasper reports with many types of drill down capability..which Jasper report doesnt have

Hi Cau u please provide me a sample report Project Source Code the i can understand more Can apply for my customer.I am trying to create a report Which will List All available Fields and User will choose the fields and It will generate the Report

Iam using jasperreports in my project.I used jasperViewer to generate the reports.when i save the report as .csv.The alignment is not proper?.Is there any solution for this?.

It’s urgenttttttt

hi guys ..pls help me how to congigurejasper report using eclipse ide ..

i have to insert serial numbers at report but problem is that ther will b multilple subreport’s data at each column.how to insert serial no then if possible………….

Hi

Sorry for the long delay, got sucked into another project. I created a very basic .vm file where I only rename the column headers. I am uploading the file from my pc to the server (into the Base Directory). I retrieve my data via a stored proc (mssql2000). I do not have any JasperReport files there. I can see the file in the dropdown box when I create a new report, but when trying to access the report, I get a resource not found exception.

Thanks,
Cobus

Hi Brian,
JasperFillManager.fillReport(jasperReport, parameters, new JRBeanCollectionDataSource(dataList)) is taking lot of time to execute. Do you have any idea how this can be tackled?

Thanks,
Priti..

Does Linux machines support Printing of jasper reports?

Can we include css in the jasper reports

Hi Brian,

Could you teach me how to embed a report using jasper reports in java into web, i’ve tried to solve this problem several days ago but it didn’t work at all, could you give a simple project, pleaseeeee

I am a newbie. I just created my first subreport and within the iReport application, it works. I am using the connection expression: $P{REPORT_CONNECTION} and am passing 2 parameters. As I said, within iReports, the appropriate data is retrieved and displayed. But when I execute the report within the web application, no records are retrieved / displayed. I know that the subreport is being found because, to debug, I added a display of the parameters that are being passed and they are displaying accurately. But the detail of the subreport remains blank, which makes me think that the query in the subreport is not being executed. Any clues to a solution would be appreciated. Thanks.

i am new to jasper reports using jasper asistant and eclipse 3.2and i want to use dynamic reports…
such as:- select empName from employee_master where city = someValue, and i want to pass value of city at runtime, so how write such a program…plesae provide me with some sample , i have never created ant report in java….

Printing Problem in Client Machines(Printing Permission)

Hello, I came across a problem. I could display my report in applet which I have created with iReport tool. The problem is at the time of printing on the client machine,an error dialog box appears with message “Error In Printing”. I have to configure my java.policy file with some extra code for printing permission. So this has become a problem. If I give this report online how can I configure infinite clients on the web for pritning the report. Is there any other way to do so without configuring the java.policy file in the client machine?

Please Help..

Thanks in Advance

Hi im using jasperAssistant..I want to integrate several subreports to 6 pages..what i’ve done is tnat I customized the page height to the sum of a sixpage layout so that I can properly arrange the subreports I wanted on each page..However, when previewing, I was able to view the whole custom page height I’ve made,including those blank spaces since I am using page breaks…any help so that I can view only the printable area and not the whole customized page?

URGENT : What is the best way to inject a composite Hibernate Set into a Jasper Report e.g.
public class Employment {
private Set jobs;
}
public class Job {
private String jobName;
}

I retrieve via a Hibernate Query which has a left join on Job jobs which returns data OK. I then push the Employment object to the JRBeanCollectionDataSource. In the jrxml I have
jobs.jobName as a field to be displayed in the Detail band. I get a message stating that property cannot be found.
URGENT is much appreciated.

Hi,
Anyone knows abt how to access sqlsever stored procedure in iReport1.3

To Brian Burridge,

I want the each line number
in the detail band, when each line is created

by aik

Hi,
I get following error.
Would you tell me about this to solve it?
Please send me Answer.

org.xml.sax.SAXParseException: Attribute “class” with value “java.sql.Date” must have a value from the list “java.lang.Boolean java.lang.Byte java.util.Date java.sql.Timestamp java.sql.Time java.lang.Double java.lang.Float java.lang.Integer java.lang.Long java.lang.Short java.math.BigDecimal java.lang.Number java.lang.String “.

Hi Brain,

I am desinging jasper reports using ireport 1.3.3
and my requirement is to dynamically displaying the columns and i am able to do this by placing the condition on the required field and text box but i am not able to remove the blank spaces after removing the columns .So i want to remove the blank spaces and columns should be rearranged, is it possible in ireport or not please let me know.

Regards
Suresh

Hi!,
How can I reference a Parameter into the SQL Query with OpenReports?

For example: SELECT * FROM table WHERE column=”parameter”

How can I reference to the parameter added in OpenReports.

Please, HELP ME !

Hi Brian, i’ m realy thankful with you and your software OpenReports, but i have a problem with the number of parameter per report, i need define 15 parameter in one report, but when i define the parameter number 11, the aplication don’t show me the upload dialog again.

after hy
i need to develope an application thats dponds on reports and ihave some problems so ihope if you can help me

at first ican’t do adynamic report i’m usng netbens 6
and ireport2
h’m waiting foryour reply

hi…im a undergrad who is currently working on tis openreports. I need to modify some of the functions in order 2 fulfill my requirements but i don hv any idea how 2 modify d codes as it uses tag lib and im nt familiar with tat, even i wanted 2 change a small thing lk header and footer are complicated for me..pls help..

thx in advanced.

wendy

Hi Brian,

I have read some of your postings, very helpful, I have a question here, hope you can help

I am using OpenReport as my front end to display jasper report, all the reports are done in ireport, it works fine, the Open report is really helpful and works nicely. But now I need to add a search function into the report, and there is no way I can have a input field in the report, so I am thinking to run the report inside the open report, keep the menus on top of the open report page and display the report inside the main frame of the open report, this way, I can simply add a search menu, then any time, user can bring in the search screen and do a search. I know how to make the html report inline, but I don’t know how to keep the header, the menu bar, that contains “Report” “Administration”, etc.

Do you think it is possible to do it? if yes, could you please give me some instruction?

Thank you very much!

Meiren

…

Hello,
I have a little problem about iReport.I have made 4 reports and I want to join them as a single report.
And all reports have their page header and column header and their own queries.Either is this possible to combine the reports with all their page header and column header that they show like the same as they individually.

Hi,

How to ignore the count part from the cross tab report in jrxml.Kindly mention the syntax.

Thanks in advance.

how can i use a chart in a query report? using a freemarker template, without using jasper

thanks in advance

bnbg

Hi

I have created the report “.jrxml” by using the ireport. How i can integrate the generated report(.jrxml) with open reports.I am using “WAMP”(PHP) SERVER.Is it possible to use in wamp???

Thanks in advance

Hi,

thanks for the very informative article. This and other finds has led me to go for the same solution. However, as a noobie, am finding it really difficult to find a simple start to finish step by step guide to installing openreports with jasperreports on Leopard? I posted the question on a couple of forums including (http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=8&id=42002#42002)
, but perhaps if you have a couple of minutes, just give me a few pointers. thanks

hi brian,
I want to use my own date pattern to my jasper, i passed $P{userDatePatter} Parameter to the report and using SimpleDateFormat to convert my own date pattern(for every reports iam doing like this) , what iam asking is, instead of doing like i want to declare common datepattern to my all reports..

thanks in advance
SIVA

hi,
i am developing reports using i-reports , i cannot convert (matrix with group above-oracle reports) to i-reports, and not able to do sum of the resultant fields.
help me

how to display “Continued” message at the end of every page using iReport 3.0

hi
I faced a problem on ireports while creating reports on pdf formator on text format.
Actually it leaves spaces after the rows.Even adjusting band size & minimising d field size has not removed d problem completely.
please suggest something.

Thanks & Regards
Tamal

Hi Brian,
How to print row number in the detailband.
I want the 1st column to display the row number or record number. Starting from 1 & incremented by 1 for each record frtched.

these questions and the solutions are greatly useful but how to post quetions regardng can any one please guide me.
Thnx in before.

Hi,
I have created a cross tab report using iReport.
Now the output is getting exported to JR Viewer, but the same is not getting exported in PDF Format. Help me pls.
Thnx in advance,
Karthi

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Passengers_list
How to solve this problem

Hi there,
look, i’ve a problem with the jasperserver instalation, I installed jasperserver locally without problems but then i did in a UNIX server and after installed when i’m trying to open the login.html, the server show me the next Exception:

16:27:04,641 ERROR [jsp],http-80-Processor2:711 – Servlet.service() for servlet jsp threw exception
java.lang.IllegalArgumentException: InputStream cannot be null
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:94)
at com.jaspersoft.jasperserver.war.common.SiteMenu.parse(SiteMenu.java:74)
at com.jaspersoft.jasperserver.war.common.SiteMenu.getMenu(SiteMenu.java:63)
at org.apache.jsp.WEB_002dINF.decorators.main_jsp._jspService(main_jsp.java:221)…

i unzipped the jasperserver folder into webapps on tomcat, but i don’t know if i need to do something else? can you help me?

tnks

I would like to know whether I can use Jasper reports on a separate machine independent of my web application, which will help me to reduce the overload on my web application server.
I am using Hibernate for my web application and I would like to use the same connection for my jasper reports which will be on separate machine, is it possible?

Respected sir

I am trying to display reports in Marathi but pdf dose nit support it actually in my table contain Marathi and English data but it only display English Why its happen i cant understand so please give me solution

than you

Hi,

I am working in ireports 2.0.2. I am new to this tool. I have been search for hyperlinks topic(remote page,remote anchor and local anchor). I have gone through the documents but it is having only the definitions. I did practical no output. Please If any body is working on the same please help.

Please do the needful…

Regards,

vidya.

Do you need to have a particular Adobe Reader version for viewing PDF’s generated from iReport 1.3.3 / Jasper Reports 1.3.3? Does it work with any version?

We have someone having problems opening up a PDF report and is thinking it could be because of an older version of Adobe reader.
Thanks.

Hi Brian,

I have created a jasper report which includes a sub report. It works fine on iReport but when I deployed my Jasperreport on jasperserver then i get this error , “parameter DATABASE_TIMEZONE does not exist” .

Please give me some suggestions in order to solve this problem.

Thank you for your time.

Best Regards,
Sushmita

Aspose is going to introduce “Aspose.Cells for JasperReports” in near future to convert reports from JasperReports in Excel format. Currently, Aspose enables JasperReports developers to export their reports in PowerPoint (PPT, PPS) and Word document (DOC, DOCX, HTML and TXT) formats. I hope this reference URL will help http://www.aspose.com/categories/jasperreports-exporters/default.aspx

Hi there , Can one use OpenReports for serving up report form BIRT?

hi
i have generated a pdf report using ireport.
in the report i have 7 columns and some records.
i want to sum the row wise means need to add first 4 rows and next 3 rows seperately and i need to subtract both the values in the end of the row

How to generate serial no in jasper report

I am using jasper report in my application. In the table has 4 fields like code,name,address,phone number. If i generate the report i need to display the serial number like1,2,3…. for each record. I don’t know how to set. So please help me.

Hi Brian,

In your post you commented:

“I have made some improvements to OpenReports, including the Collection/List functionality to use Business Objects which JasperReports supports, but OpenReports currently doesn’t. At some point I’ll pass that code on to the original developers.”

I’ve tried to upload a jasper file to OpenReports with JavaBeans as data source (it works perfectly in iReport), but it seams OpenReports can’t handle that kind of data sources because I only got “null” as ouput in my fields.

Do you still have those code improvements? Or can you pinpoint me where to look, read or improve myself.

Thanks in advance!!

Luis M. Gallardo D.

Answer for andy susanto or any other people that have this problem!
The thing is that the tomcat intalled as a service has diff options configured than the other tomcat.
So, for being able to show the print dialog just execute the tomcat6w file in bin folder and go to Log On tab. There you have to check the “Allow service to interact with desktop” since jasper is showing the print dialog as a separete dialog…

I hope this helps…

I have 2 questions:

We are using openreports which we plan to integrate with an application. Is there a way to suppress the open reports login, since we have an oblix login for the application itself.

Secondly, is there a way to hide some of the reports from the user?

Appreciate your help!

Thanks
Venky

I have a question related to the use of Collections datasources.
i want to remove all the querys from jasperreports and provide all the data needed using my domain object previusly retrieved using hibernate as the dataaccess layer.
my domain object structure is like this:

class A {
Long id;
Set b;
String data;
}

I retrieve by id an instance of class A using hibernate, and I want to supply to the filling process of the report the collection A.getB() to generate a table for every B.getC() Collection as a dataset of the table.
I can’t figure out what this functionality may be adquired in JasperReport.
Someone has any points on this?

I have tried to run the java class file and using netbeans IDE.i get the following error.i am trying to create a report using jasperreport

Below is the code

package jasperreportsdemoapplication;

import java.sql.SQLException;
import java.util.*;
import net.sf.jasperreports.engine.JREmptyDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperFillManager;

public class RepJes {
public static void main(String[] args) throws ClassNotFoundException, SQLException {

try
{
System.out.println(“Compiling report…”);
JasperCompileManager.compileReportToFile(“./report/template/HelloW.jrxml”);
System.out.println(“Done!”);
System.out.println(“Filling report…”);
JasperFillManager.fillReportToFile(“./report/template/HelloReportWorld.jasper”,new HashMap(), new JREmptyDataSource());
System.out.println(“Done!”);
}
catch (JRException e)
{

e.printStackTrace();
}

Exception in thread “main” java.lang.IllegalArgumentException: Null ‘key’ argument.
at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:225)
at org.jfree.data.general.DefaultPieDataset.setValue(DefaultPieDataset.java:187)
at net.sf.jasperreports.charts.fill.JRFillPieDataset.customIncrement(JRFillPieDataset.java:126)
at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169)
at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:228)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:492)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:448)
at jasperreportsdemoapplication.RepJes.main(RepJes.java:87)

how can i print the report in client machine;

how to pass Collection object value in jasper report paramter for example I want to send parameter value “1,2,3″ in jasper report in jasper assitant
Paramter type is String