Jump to content
We've recently updated our Privacy Statement, available here ×

2006 IR Open Discussion

Members
  • Posts

    776
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by 2006 IR Open Discussion

  1. By: Francesco - francesco334

    iReport problem

    2006-09-11 08:22

    Hello all,

    I'm new in iReport. I have seen a tutorial to use iReport from an XML Datasource:

    http://jasperforge.org/sf/wiki/do/viewPage/projects.ireport/wiki/UsingTheXMLDatasource

     

    The xml that I have tested in iReport is addressbook.xml

     

    The Record path is: /addressbook/category/person

     

    <addressbook>

    <category name="home">

    <person id="1">

    <LASTNAME>Davolio</LASTNAME>

    <FIRSTNAME>Nancy</FIRSTNAME>

    <hobbies>

    <hobby>Radio Control</hobby>

    <hobby>R/C Cars</hobby>

    </hobbies>

    <email>email1@my.domain.it</email>

    <email>email2@my.domain2.it</email>

    </person>

    <person id="2">

    <LASTNAME>Fuller</LASTNAME>

    <FIRSTNAME>Andrew</FIRSTNAME>

    <email>email3@my.domain3.it</email>

    <email>email4@my.domain4.it</email>

    </person>

    </category>

    <category name="work">

    <person id="4">

    <LASTNAME>Peacock</LASTNAME>

    <FIRSTNAME>Margaret</FIRSTNAME>

    <hobbies>

    <hobby>Toy Horse</hobby>

    </hobbies>

    <email>Peacock@margaret.com</email>

    </person>

    </category>

    </addressbook>

     

    I have tried the example and all works. Then, I have changed the xml adding a different tag on the same level of the tag category,for example :

     

    <addressbook>

    <authors>

    <author>John XXX</author>

    <author>John XXX</author>

    </authors>

    <category name="home">

    <person id="1">

    <LASTNAME>Davolio</LASTNAME>

    <FIRSTNAME>Nancy</FIRSTNAME>

    <hobbies>

    <hobby>Radio Control</hobby>

    <hobby>R/C Cars</hobby>

    </hobbies>

    <email>email1@my.domain.it</email>

    <email>email2@my.domain2.it</email>

    </person>

    <person id="2">

    <LASTNAME>Fuller</LASTNAME>

    <FIRSTNAME>Andrew</FIRSTNAME>

    <email>email3@my.domain3.it</email>

    <email>email4@my.domain4.it</email>

    </person>

    </category>

    </addressbook>

     

    and when iReport create the PDF document I see the value null in the cycle of the tags category. Seems that iReport doesn't read exactly only the path /addressbook/category/person but read even the tag authors that is not correct!!

     

    I can I solve this problem???

     

    Than, the last question :

     

    in the first example of xml addressbook the category tag has the attribute "name".

    If I want only show the categories that have name="work", how can I do in iReport??

     

    Thanks for all your response,

    Francesco

     

     

     

    $P{SUBREPORT_DIR} +

     

    new Boolean($V{CATEGORYTYPE}=="home")

     

    .getValue()

  2. By: spoorthi - spoo_anu

    Re: Report Instance ganeration and retrieval

    2006-07-24 23:18

    Dear all,

     

    Can any body expalin me how exactly report instances are generated, stored and retrieved from the database. I need table level explanation...

     

    with

    shivaraj

     

     

     

     

    By: T Kavanagh - tkavanagh

    Re: Report Instance ganeration and retrieval

    2006-07-26 14:54

    I'm not sure exactly what your question means... however..

     

    A report is a JasperReport (based on jrxml). A report unit is a report inside of jasperintelligence (which includes such things as datasources, images and other resources).

     

    We have a jasperintelligence repository and this is implemented as a database (database "jasperserver"). All of the metadata around a report unit is stored in the database (ie all the resources: jrxml, datasources, images, etc).

     

    If you want to see what goes where in the db it is best to look at the database itself with a db viewer tool and look at a database that is populated with the sample data.

     

    Also, keep in mind that all forum activity is moving to jasperforge.org.

  3. By: spoorthi - spoo_anu

    Re: Isolating Jasper Server from MySQL

    2006-07-23 22:25

    Dear all,

    I want to isolate jasper server from mySQL at Jasper server installation time.So that i can install the jasper server system data base(MySQL, Oracle) later.

    Can any body tell me some solution to achieve this plz..

    I am waiting for the solution at the earliest.

     

    with thanks and regards

     

    SHIVARAJ

     

     

     

     

    By: T Kavanagh - tkavanagh

    Re: Isolating Jasper Server from MySQL

    2006-07-26 14:37

    Shivaraj,

     

    You will not be able to not effect the database when you are doing an installation.

     

    However, you can use the jasperintelligence-1.0.1-bin.zip which is a "stand-alone" war file archive. In this zip you will find a jasperserver.war (this is the stand-alone war). You can follow the instructions in the jasperintelligence-warfile-install-guide.pdf to do the installation/configuration (ie drop it into Tomcat). Then all of the database configuration is done by hand.

     

    Please note that all forum activity is moving to jasperforge.org

  4. By: Sherman Wood - sgwood

    JasperIntelligence is moving!

    2006-07-18 21:04

     

    See the news at:

     

    http://sourceforge.net/forum/forum.php?forum_id=592538

     

     

    Forum: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=showcat&catid=10

     

    We will start referring JasperIntelligence SourceForge posters to the JasperForge forum, and

    will stop answering questions on the JasperIntelligence Sourceforge.net forums in the next week.

     

     

    We look forward to working with you in our new home!

     

     

     

    Sherman

    JasperSoft

  5. By: Sherman Wood - sgwood

    Windows and Linux Installers are available

    2006-07-08 09:26

     

    Linux and Windows installers are now available for JasperIntelligence 1.0. This 195MB download joins the Linux installer and standalone WAR file distributions that were previously released and includes:

     

    * iReport 1.2.4 with plugin that interacts with the server to edit and run reports via Web Services with attachments

     

    * JasperServer OS 1.0

     

    - Scheduled reporting with generated email

    - Content repository for generated output

    - Integrated browser UI for metadata and content

     

    * JasperAnalysis OS 1.0

     

    - OLAP ‘slice and dice’ user interface

    - Managed OLAP server

    - Secure remote communications via Web Services (XML/A)

     

    * Pluggable data sources for reports

     

    * Security enhancements

     

    - Folder and object level security by role or individual user

    - Improved integration with external authentication services like LDAP

     

    * Metadata repository import/export tool to migrate data between repositories

     

    - This tool is used by the installer to load examples

     

    * Example reports, OLAP views and data – SugarCRM (open source) and FoodMart data mart

     

    * Expanded documentation for all components (80+ pages)

     

    As before, the installers come with bundled Java 1.5, Tomcat 5.5 and MySQL 5.0. The installer can install these components, or use pre-existing instances.

     

     

    Enjoy!

     

     

     

    Sherman

    JasperSoft

  6. By: Sherman Wood - sgwood

    JasperIntelligence 1.0.0 Released

    2006-06-28 01:27

    We are pleased to announce this release that significantly broadens the platform into the following areas:

     

    * Scheduled Reports with email notifications

    * Content Repository for scheduled report output

    * OLAP User interface

    * OLAP Server

    * Custom Data Sources for Reports

    * Fine grained Security

    * Enhanced iReport plugin for JasperIntelligence

    * Expanded Documentation

    * Scheduled Event Viewer

    * Installers covering reporting and/or analytics

     

     

    Release notes are here: http://jasperintel.sourceforge.net/index.php?p_module=page&pageid=45

     

     

    Downloads are here: http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243.

     

    We will get the installer versions out in the next couple of days.

     

     

     

    Sherman

    JasperSoft

     

     

    By: W. Stewart - wstewart

    RE: JasperIntelligence 1.0.0 Released

    2006-06-30 09:04

    Is 1.0.0 what I get if I check out the "trunk"

    from the Subversion repository?

     

    I don't see any tags/branches for 0.9.2. Is

    this correct? ... or is my Eclipse Subversion

    plugin, Subclipse, just not showing me the

    correct state of the project?

     

     

     

     

    By: Sherman Wood - sgwood

    RE: JasperIntelligence 1.0.0 Released

    2006-07-01 06:56

     

    We have not released the latest source into SVN just yet. The source is included in the src distribution for now.

     

     

     

    Sherman

    JasperSoft

     

     

    By: W. Stewart - wstewart

    RE: JasperIntelligence 1.0.0 Released

    2006-07-01 21:25

    Does JasperSoft have any documentation on their use of

    Subversion? With some open source projects the publicly

    accessible CVS or Subversion repository is *the* development

    repository. This does not seem to be the case for JasperServer.

     

    Is the JasperIntel Subversion repository on SourceForge just

    another release avenue, like downloadable .zip or .tar.gz files?

    Do releases via the Subversion repository lag behind those on the

    downloadable files page? Some clarification on this would be

    very helpful, since many people are used to seeing the "latest

    and greatest" in the code repositories of "Open Source" projects.

     

     

     

    By: Sherman Wood - sgwood

    RE: JasperIntelligence 1.0.0 Released

    2006-07-03 05:33

     

    We started developing with a JasperSoft internal SVN repository and have continued along that way, just due to time. Once we get the installers released, we will get the 1.0 source out to SourceForge SVN.

     

    In a few weeks, we will be moving the source repository and documentation to JasperSoft's new Forge, jasperforge.org, where JasperReports, iReport and JasperIntelligence will live.

     

     

    Sherman

    JasperSoft

  7. By: T Kavanagh - tkavanagh

    Source Code Build Document Added

    2006-05-05 17:00

    The JasperServer source code is in subversion and has been available for checkout for a few days. On the Documentation page of the http://jasperintel.sourceforge.net home page there is a new link "Source Code Build Guide" which is an html version of this document. In addition, there is a PDF version available for online viewing or download.

     

     

    By: Jeffrey Fredrick - jfredrick

    RE: Source Code Build Document Added

    2006-05-08 23:36

    a couple of things you might want to fix:

     

    1. the "create database x" commands are missing the ';' at the end of the line

     

    2. there is no FoodMart-MySQL-032006.sql in the scripts directory (at least not that I can see). perhaps this isn't yet in the public SVN?

     

     

    By: Jeffrey Fredrick - jfredrick

    RE: Source Code Build Document Added

    2006-05-09 01:01

    oh, and

     

    3. under "Build JasperServer Source Code" you reference a couple of directories that I don't see locally, "jasperserver-repository-hibernate/build-db" and "jasperserver-unit-test".

     

     

     

    By: Sherman Wood - sgwood

    RE: Source Code Build Document Added

    2006-05-09 12:03

     

    Sorry - these instructions include changes we have made to the build process internally and have not released to SourceForge SVN yet. In the next release, the default top level "mvn clean install" will just build, not build the DB and run the test suite. Also the Foodmart database is part of the test suite for the OLAP functionality we are working on.

     

     

    Sherman

    JasperSoft

     

     

    By: W. Stewart - wstewart

    RE: Source Code Build Document Added

    2006-06-30 09:27

    > ... include changes we have made to the build process internally and have not released to SourceForge SVN yet.

     

     

    Does JasperSoft have any documentation on their use of

    Subversion? With some open source projects the publicly

    accessible CVS or Subversion repository is *the* development

    repository. This does not seem to be the case for JasperServer.

     

    Is the JasperIntel Subversion repository on SourceForge just

    another release avenue, like downloadable .zip or .tar.gz files?

    Do releases via the Subversion repository lag behind those on the

    downloadable files page? Some clarification on this would be

    very helpful, since many people are used to seeing the "latest

    and greatest" in the code repositories of "Open Source" projects.

     

     

     

    By: W. Stewart - wstewart

    RE: Source Code Build Document Added

    2006-06-30 13:22

    > In the next release, the default top level "mvn clean install"

    > will just build, not build the DB and run the test suite.

     

    ??? Here's what the latest build document says:

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

     

    BUILD JASPERSERVER SOURCE CODE

     

    A "complete" build means building the source code as well as

    populating the jasperserver database with the schema that

    JasperServer needs. To do a complete build, you will do the

    following steps:

     

    cd jasperserver/trunk

    mvn install

     

    Description of build execution:

     

    The single mvn install command will download all dependent jar

    files (from Maven2 repositories), compile all source code,

    generate database schema, execute schema create within the

    database, populate the database with sample data (for testing),

    build the jasperserver war directory and the jasperserver-ws war

    directory.

     

     

     

    By: T Kavanagh - tkavanagh

    RE: Source Code Build Document Added

    2006-05-10 21:45

    Oh, and good suggestion on having the semi-colons ; at the end of the sql lines, since people will do cut and paste in order to run commands.

     

     

    By: T Kavanagh - tkavanagh

    RE: Source Code Build Document Added

    2006-05-09 12:26

    Jeffrey, thanks for the feed back. I ran through a test yesterday after posting the doc earlier and noticed that the source was before our most current refactoring.

     

    <p>I just updated the documentation on the web site. Sorry for the confusion.

     

     

    By: W. Stewart - wstewart

    RE: Source Code Build Document Added

    2006-06-30 11:24

    Unfortunately the docs/JasperServer-Source-Code-Build.htm distributed with the 1.0.0 source

    release still has the problems pointed out by

    Jeffrey; e.g.:

     

    cd jasperserver/trunk

     

    mvn install

    cd jasperserver/trunk/jasperserver-repository-hibernate/build-db

    mvn install

    cd jasperserver/trunk/jasperserver-unit-test

    mvn install

  8. By: spoorthi - spoo_anu

    Connecting -JasperServer & Oracle

    2006-06-22 21:28

    Hi,

     

    Am shivaraj currently working for infosys,

     

    presently am working on jasperserver....

     

    my problem is simple

     

    am trying to connect the jasper server to oracle databse ...

     

    presently the jasper server system is using default MYSQL database for user-role management and for updation.

     

    Now am trying for making the jasper server to completely interact with the Oracle database ...

    For this i have made modification in

     

    context.xml --------altered connection strings

     

    hibernate.properties------- changed the dialect class

     

    For am getting the following exception

    SQL state

    some oracle....error -----Invalid table name

     

    Here the major problem is there is a table in mysql database called User used by the jasper server system.

    This table cannot be created in oracle, becoz it is a reserved word in oracle.If i create alternate table i need to modify it in the jasper server product core functionality itself .... which might be a critical approach..

     

    Also tell me how i can get the source code for jasper server ?

     

     

     

    plz try to understand my problem specifically if possible try send the solution as early as possible....

     

    with thanks and regards

    SHIVARAJ

    spoo_anu@rediffmail.com

     

     

     

     

     

     

     

     

     

    By: M d ric RIBREUX - medspx

    RE: Connecting -JasperServer & Oracle

    2006-06-24 02:12

    We gat exactly the same problem with postgreSQL. Actually, by using a table named "User", I was able to create a complete database but I've got the same error than you: jasperserver cannot run with such a named table...

    But perhaps the new release will fix it !

     

     

    By: Sherman Wood - sgwood

    RE: Connecting -JasperServer & Oracle

    2006-06-24 10:44

     

    You can change the Hibernate mappings to deal with these DBMS specific naming issues. In 0.9.2, we used XDoclet to generate some of the mappings. In 1.0.0, which we are wrapping up now, the mapping files are not genrated and are in a separate JAR, so you can change everything for your particular DBMS.

     

     

    Sherman

    JasperSoft

  9. By: Sherman Wood - sgwood

    JasperIntelligence Announcement and Webinar

    2006-04-24 07:42

    Announcements

     

    Coinciding with the JasperServer 0.9.2 release, JasperSoft is announcing the

    roadmap for JasperIntelligence to make it a complete business intelligence

    solution. Check out:

     

    http://www.jaspersoft.com/downloads/jspressrelease/JasperIntelligence_d3.pdf

     

    and

     

    http://www.jaspersoft.com/downloads/jspressrelease/JasperServer_d11.pdf

     

     

    More details are at http://www.jaspersoft.com.

     

     

     

    Webinar

     

    On May 9, I am giving a free webinar giving a technical overview of

    JasperServer. See details and register at

    http://www.jaspersoft.com/nw_webinars.html

     

     

     

    Sherman Wood

    Director, Business Intelligence

    JasperSoft

     

     

    By: Seth Grimes - grimes

    RE: JasperIntelligence Announcement and Webin

    2006-04-25 09:47

    Sherman, your links are bad. The URLs are truncated at the underscore character.

     

    Seth

     

     

    By: Sherman Wood - sgwood

    RE: JasperIntelligence Webinar

    2006-05-04 07:41

     

    The webinar on May 9 is proving to be popular. Here is the agenda I have planned. Let me know if there is anything else you would like covered and I will try and include it in the hour.

     

     

    Introduction

     

    Aims of JasperIntelligence

     

    Usage Scenarios

     

    What is it now? Demonstration

    * Web user interface

    * PHP

    * iReport integration

     

    Architecture

    APIs

     

    Web User Interface

     

    Web services

     

    Security

     

    Developing and extending JasperIntelligence

     

    Roadmap (with some additional demonstrations "from the lab")

     

    Q&A

     

    Sign up at http://www.jaspersoft.com/nw_webinars.html (Sorry the "_" throws off SourceForge - you will have to cut and paste the URL into your browser.

     

     

    Cheers,

     

     

    Sherman Wood

    JasperSoft

  10. By: Sherman Wood - sgwood

    iReport plugin for JasperServer released

    2006-04-27 10:43

     

    (Now that SourceForge forums are back online....)

     

    Giulio Tuffoli, the iReport lead, has been working with us to create a plugin for iReport that allows iReport to browse the JasperIntelligence repository, downloading and uploading reports and other resources. This works with the JasperIntelligence Web services WAR.

     

    Check it out at http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=184084&release_id=412356

     

     

     

    Sherman Wood

    JasperSoft

  11. By: Sherman Wood - sgwood

    Installer Updates

    2006-04-12 20:01

     

    Both Windows and Linux installers (v0.9.1) have been updated to better deal with existing MySQL installations.

     

     

     

    Sherman

    JasperSoft

     

     

    By: openross - openmax71

    RE: Installer Updates

    2006-04-14 07:20

    I have try your new installer on gentoo linux , now no problem all OK.

     

    Thanks

  12. By: Sherman Wood - sgwood

    Update to Linux Installer

    2006-04-09 10:39

    With some testing after the initial release, we realized that installing over an existing MySQL installation had a problem. I have just uploaded a new version of the Linux installer which has been fixed.

     

    Sherman Wood

    JasperSoft

  13. By: flavio - flavio_toledo

    Report with 2 pages

    2006-08-31 18:32

    Hi,

    I need make a report with 2 pages with 2 images (one in each page), but the ireport show only 1 page.

    How i should do this?

    The iReport don't show more than one page?

     

    Thank you.

    Flávio

  14. By: tcloonan - tcloonan

    JasperSoft / MySQL / PHP Meetup

    2006-08-23 22:04

    Monday, September 11, JasperSoft will host a meetup of the local chapter of the MySQL /PHP User Group at the JasperSoft office in San Francisco.

     

    The meetup will feature special guests Teodor Danciu and Giulio Toffoli. We have an exciting agenda for the September meetup:

     

    1) Roadmap Presentation on MySQL

    2) Demonstration of a System for Tracking and Reporting Bugs that runs on MySQL and JasperReports

    3) Special guests Teodor Danciu and Giulio Toffoli

    4) Prizes for NEW ATTENDEES!

     

    Please RSVP if you plan to attend, http://mysql.meetup.com/30/events/5066357/.

     

    Thank you!

     

    Tim

  15. By: MichelleH - michellehayes

    Page Break issue

    2006-08-22 23:24

    Hello,

     

    Can someone help me?

    I have created a large master report, which includes many subreports and am outputting to a pdf format.

    I am trying to force page break within the report without any luck.

     

    My main report page height is 5842 (huge I know) but it has to be to include all the subreports.

    Have read sommething about introducing a dummy group to force a page break - how is this done?

     

    Any examples would be greatly appreciated.

     

    Thanks you,

    Michelle.

  16. By: infotech3i - infotech3i

    iReport Jasper export to Excel

    2006-08-17 22:43

    Hi all,

     

     

     

    We are trying to use JasperReport from our Java based web application. We are using JDBC Data source. And Report is rendered through a Java Servlet.

    To create the report xml file we are using iReport tool.

    But we are facing problem while exporting report to Excel format.We are getting one field in exponential format. We tried using TO_CHAR in SQL query, but not able to resolve problem.

     

    For eg. we have SQL query as follows :

     

    select column1 from xyz

     

    column1 is containing values in format 11581000029014400

     

    but when report is exported to excel, value in cell is shown in exponential format.(Formula bar in excel show 11581000029014400 ).

     

     

     

    Kindly provide a solution to remove exponential format, and show value in proper number format in excel report

     

     

     

    Thanks in advance,

  17. By: Giulio Toffoli - gt78

    NEW OFFICIAL IREPORT FORUM!!!!

    2006-07-18 01:17

    Hi guys,

     

    iReport is moving to a new home. Many things will stay on SourceForge still for a big while, but the new home, http://www.JasperForge.org, is waiting!

     

    To start to play with the new forum, post your messages here:

     

    http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=showcat&catid=9

     

    I'll reply to the first 20 messages posted here Today (I have to do a bit of practice).

     

    Soon I'll move the home page of iReport too.

    The new home page will point presumably here: http://jasperforge.org/sf/projects/ireport

     

    We look forward to seeing you at JasperForge.org!

     

    Giulio

    iReport Project Administrator

     

     

     

    By: shohan_db - shohan_db

    crosstab Problem in details

    2006-08-09 01:10

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

     

     

     

     

    By: Chelle - rachele51

    Is this the new forum

    2006-08-10 11:40

    I have a question and I want to make sure I'm in the right place for asking it

  18. By: Chelle - rachele51

    class file has wrong version

    2006-08-10 10:49

    I'm a newbie. I started yesterday. I downloaded ireport 1.2.5. I put the tools.jar in the classpath for (j2sdk1.4.2_12. I get the clas file has wrong version when I compile. 49.0 should be 48.0.

     

    Saw other posting with the same problem but still don't know what to do to fix it.

  19. By: liumiao - liumiao

    crosstab

    2006-07-21 03:29

    I want to create a crosstab.It pass compiling,when running,ireport hint:

     

    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:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:643) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:144) 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:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) 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:716) at java.lang.Thread.run(Thread.java:595) NESTED BY : net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:643) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:144) 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:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) 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:716) at java.lang.Thread.run(Thread.java:595) NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:647) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:144) 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:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) 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:716) at java.lang.Thread.run(Thread.java:595) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:643) ... 12 more

     

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

    Why? my sql is error?

     

     

    By: shohan_db - shohan_db

    RE: crosstab

    2006-08-09 01:14

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

  20. By: dfailla - d_failla

    Dynamic band height

    2006-07-24 07:05

    Has anyone ever tried to change or access the band height property of a band on the fly? I would like to set bandheight based on style-defined font size. That would allow report page size to shrink as the font is reduced.

     

     

    By: zaic - zaic20

    RE: Dynamic band height

    2006-07-29 14:26

    I have the same problem but I would like to know how I can set page height dynamically. Thanks

  21. By: dfailla - d_failla

    What happened to version 1.2.3?

    2006-07-24 07:00

    What happened to the download for iReports 1.2.3? It is no longer shown as available for download. Has it been condemned?

     

     

    By: dfailla - d_failla

    RE: What happened to version 1.2.3?

    2006-07-24 12:37

    Never mind. I found it.

  22. By: nour - compiere2005

    PieChart3D

    2006-05-18 08:08

    hi,

    i have a problem when i excecute a process from compiere(if it contains graph ,pie3D)

    and the problem is:"Element type "pie3DChart" must be declared."

    somebody knows where i must change in RusReportStarter

     

     

    By: Rozario Mariadassou - rozariopm2006

    RE: PieChart3D

    2006-07-03 22:11

    Please let me know if u have found a soluntion to the above problem. I am getting the same problem. i am running iReport 1.2.3 and Compiere 2.5.3c.

     

     

     

    By: Danilo M - zeustuk

    RE: PieChart3D

    2006-07-17 14:06

    All of us are trying to deploy the report but with or without include the libraries can we get a solution. If some of you have the answer please share it.

     

     

    By: egwada - egwada

    RE: PieChart3D

    2006-07-23 23:39

    I think that you must verify if you have the good version of the jasperReports library. I use Compiere and in my mind it did not include the last jasperReports version !

    Other point is that new Jasper version uses "commons-javaflow" library to generate java file. Check if you have this in your Compiere lib directory.

     

    I hope that can help you...

     

    Have a good day.

×
×
  • Create New...