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

2002 JI Open Discussion

Members
 View Profile  See their activity

  • Posts

    1,481

  • 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

Everything posted by 2002 JI Open Discussion

  1. 2002 JI Open Discussion
    By: Max Po - maxpo Error in Subreport 2003-01-10 03:15 Hi, I´ve modified the sample that you have in the website, but it doesn´t work. I get this error when I try to use subreports: Error: dori.jasper.engine.JRException: Error executing report query If I split them in two different reports, they work fine. Thank you very much. By: Teodor Danciu - teodord RE: Error in Subreport 2003-01-10 04:24 Hi, The stack trace must be longer than that. Without seeing the entire exception, I cannot tell you what went wrong. Only that there is some problem with the query, probably due to parameters. Thank you, Teodor
  2. 2002 JI Open Discussion
    By: lovish Durbha - lovish Data Source as XML 2003-01-10 01:19 I have a huge junk of data in a XML file and need to generate a report, I have gone through the examples but didnt find one. I was wondering if any of you have suggestions. Lovish By: Teodor Danciu - teodord RE: Data Source as XML 2003-01-10 01:33 Hi, You'll have to implement a custom JRDataSource in order to wrap the XML data that you have, so that JasperReports could make sens of it and be able to generate reports. Simple JRDataSource implementations can be found in the "datasource" sample provided. Thank you, Teodor
  3. 2002 JI Open Discussion
    By: Muralidhar bp - pmurli Report encountered this error : 2003-01-08 22:21 Hello, I am running the application in weblogic and i am getting the error. I think it is the problem with the classpath. The classpath which i gave is classpath=D:BEAwlserver6.1libjasperreports.jar;C:JasperReportslibjasperreports.jar;D:BEAWLSERVER6.1LIBweblogic.jar Do i have to give anything else, please help me, It is very urgent. Thanx Murli Report encountered this error : dori.jasper.engine.JRException: Errors were encountered when compiling report design: D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:4: package dori.jasper.engine does not exist import dori.jasper.engine.*; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:5: package dori.jasper.engine.fill does not exist import dori.jasper.engine.fill.*; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:17: cannot resolve symbol symbol : class JRCalculator location: class CustomerReport public class CustomerReport extends JRCalculator ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:24: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_CONNECTION = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:25: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_BaseDir = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:26: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_SCRIPTLET = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:27: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_PARAMETERS_MAP = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:28: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_ReportTitle = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:29: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_DATA_SOURCE = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:31: cannot resolve symbol symbol : class JRFillField location: class CustomerReport private JRFillField field_CustomerCount = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:32: cannot resolve symbol symbol : class JRFillField location: class CustomerReport private JRFillField field_BranchName = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:33: cannot resolve symbol symbol : class JRFillField location: class CustomerReport private JRFillField field_BranchCode = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:35: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_PAGE_NUMBER = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:36: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_COLUMN_NUMBER = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:37: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_REPORT_COUNT = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:38: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_PAGE_COUNT = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:39: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_COLUMN_COUNT = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:40: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_TotalCustomer = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:50: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport JRFillVariable[] v, ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:51: cannot resolve symbol symbol : class JRFillGroup location: class CustomerReport JRFillGroup[] g ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:52: cannot resolve symbol symbol : class JRException location: class CustomerReport ) throws JRException ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:56: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_CONNECTION = (JRFillParameter)parsm.get("REPORT_CONNECTION"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:56: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_CONNECTION = (JRFillParameter)parsm.get("REPORT_CONNECTION"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:57: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_BaseDir = (JRFillParameter)parsm.get("BaseDir"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:57: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_BaseDir = (JRFillParameter)parsm.get("BaseDir"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:58: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_SCRIPTLET = (JRFillParameter)parsm.get("REPORT_SCRIPTLET"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:58: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_SCRIPTLET = (JRFillParameter)parsm.get("REPORT_SCRIPTLET"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:59: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_PARAMETERS_MAP = (JRFillParameter)parsm.get("REPORT_PARAMETERS_MAP"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:59: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_PARAMETERS_MAP = (JRFillParameter)parsm.get("REPORT_PARAMETERS_MAP"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:60: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_ReportTitle = (JRFillParameter)parsm.get("ReportTitle"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:60: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_ReportTitle = (JRFillParameter)parsm.get("ReportTitle"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:61: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_DATA_SOURCE = (JRFillParameter)parsm.get("REPORT_DATA_SOURCE"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:61: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_DATA_SOURCE = (JRFillParameter)parsm.get("REPORT_DATA_SOURCE"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:63: cannot resolve symbol symbol : class JRFillField location: class CustomerReport field_CustomerCount = (JRFillField)fldsm.get("CustomerCount"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:63: cannot resolve symbol symbol : variable fldsm location: class CustomerReport field_CustomerCount = (JRFillField)fldsm.get("CustomerCount"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:64: cannot resolve symbol symbol : class JRFillField location: class CustomerReport field_BranchName = (JRFillField)fldsm.get("BranchName"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:64: cannot resolve symbol symbol : variable fldsm location: class CustomerReport field_BranchName = (JRFillField)fldsm.get("BranchName"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:65: cannot resolve symbol symbol : class JRFillField location: class CustomerReport field_BranchCode = (JRFillField)fldsm.get("BranchCode"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:65: cannot resolve symbol symbol : variable fldsm location: class CustomerReport field_BranchCode = (JRFillField)fldsm.get("BranchCode"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:67: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_PAGE_NUMBER = (JRFillVariable)varsm.get("PAGE_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:67: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_PAGE_NUMBER = (JRFillVariable)varsm.get("PAGE_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:68: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_COLUMN_NUMBER = (JRFillVariable)varsm.get("COLUMN_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:68: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_COLUMN_NUMBER = (JRFillVariable)varsm.get("COLUMN_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:69: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_REPORT_COUNT = (JRFillVariable)varsm.get("REPORT_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:69: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_REPORT_COUNT = (JRFillVariable)varsm.get("REPORT_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:70: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_PAGE_COUNT = (JRFillVariable)varsm.get("PAGE_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:70: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_PAGE_COUNT = (JRFillVariable)varsm.get("PAGE_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:71: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_COLUMN_COUNT = (JRFillVariable)varsm.get("COLUMN_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:71: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_COLUMN_COUNT = (JRFillVariable)varsm.get("COLUMN_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:72: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_TotalCustomer = (JRFillVariable)varsm.get("TotalCustomer"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:72: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_TotalCustomer = (JRFillVariable)varsm.get("TotalCustomer"); ^ 51 errors at dori.jasper.engine.design.JRCompiler.compileReport(JRCompiler.java:145) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:129) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:101) at servlets.ListOfCustomerNumberServlet.service(ListOfCustomerNumberServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) By: Teodor Danciu - teodord RE: Report encountered this error : 2003-01-09 23:42 Hi, Here's the solution: https://sourceforge.net/forum/message.php?msg_id=1814460 I hope this helps. Teodor
  4. 2002 JI Open Discussion
    By: Julie Bé²µbé­ orlibou vertical report 2003-01-09 11:44 Hi, I want to do a report like this: __________________________________ titre | titre2 | | Year1 | Year2 | | M1|M2|M3...M12|M1|M2|M3...M12| __________________________________ L1 | 2 | 3 | 4 .... 10 | 5 | 7 | 9 .... 1 | L2 | 1 | 2 | 1 .... 12 | 4 | 2 | 5 .... 11 | __________________________________ The number of column is variable. I can have Yera1, Year2, Year3 or just Year1 or 5 years... Is it possible to do that with jasperreports? Thank! By: Teodor Danciu - teodord RE: vertical report 2003-01-09 23:26 Hi, I guess you are talking about a crosstab report. JasperReports does not support them yet. Thank you, Teodor
  5. 2002 JI Open Discussion
    By: Max Po - maxpo Help with SubReports 2003-01-09 06:55 Hi Anybody can tell me how works the subreports ? Where can I found Java Samples and not only de xml and pdf files ? Thanks By: Teodor Danciu - teodord RE: Help with SubReports 2003-01-09 07:03 Hi, The complete samples are under the /demo/samples directory of the project tree. There you can find the entire "subreport" sample and you can even run it. I hope this helps. Teodor
  6. 2002 JI Open Discussion
    By: Alex Murashko - newbie25 How to count groups? 2003-01-09 04:12 I have items. They grouped into pallets by pallet id in item. Pallets grouped into orders by order id in pallet. Data that coming from DS is itemid,palletid,orderid I had created groups: OrderGroup (expr: orderid) PalletGroup(expr: palletid) And now i should show distinct pallets count for each order w/o change DS query Anyone can help? Thanks, Alex. . By: Teodor Danciu - teodord RE: How to count groups? 2003-01-09 04:49 Hi, Check the CityNumber variable in the "query" or "datasource" samples. Good luck! Teodor By: Alex Murashko - newbie25 RE: How to count groups? 2003-01-09 06:14 Hmm. Something like that, but one more nuance. It's increments count each time it's must reset palletgroup, but i need reset this count when order changed. It's possiible? Regards, Alex. By: Teodor Danciu - teodord RE: How to count groups? 2003-01-09 06:25 Hi, OK. Then you have to switch to scriptlets. I hope this helps. Teodor
  7. 2002 JI Open Discussion
    By: Max Po - maxpo Multiple table access 2003-01-09 02:05 Hi, I´d like to know if it´s possible to access different tables from a database that are not related in a single report. Thanx in advance. Wuang Wo. By: Teodor Danciu - teodord RE: Multiple table access 2003-01-09 02:59 Hi, Yes. Use subreports. This is because each report/subreport can access only one table/view/datasource, but putting multiple subreports into a master report can solve your design problem. I hope this helps. Teodor
  8. 2002 JI Open Discussion
    By: eric teo - duckizz Filling in the data in jasper report 2003-01-08 22:49 hi, i was wondering if i had a db class that contains data and i wan it to popuilate a pre-designed jasper report, is it possible ? or can jasper report only accept a db connection ? By: Teodor Danciu - teodord RE: Filling in the data in jasper report 2003-01-08 23:47 Hi, Yes, you can. Instead of suplying a Connection object, you could supply a JRDataSource instance. You can implement the JRDataSource to wrap your objects so that JasperReports could use them to fill the report. Check the "datasource" sample provided. I hope this helps. Teodor
  9. 2002 JI Open Discussion
    By: Muralidhar bp - pmurli Report encountered this error : 2003-01-08 21:57 Hello, I am running the application in weblogic and i am getting the error. I think it is the problem with the classpath. The classpath which i gave is classpath=D:BEAwlserver6.1libjasperreports.jar;C:JasperReportslibjasperreports.jar;D:BEAWLSERVER6.1LIBweblogic.jar Do i have to give anything else, please help me, It is very urgent. Thanx Murli Report encountered this error : dori.jasper.engine.JRException: Errors were encountered when compiling report design: D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:4: package dori.jasper.engine does not exist import dori.jasper.engine.*; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:5: package dori.jasper.engine.fill does not exist import dori.jasper.engine.fill.*; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:17: cannot resolve symbol symbol : class JRCalculator location: class CustomerReport public class CustomerReport extends JRCalculator ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:24: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_CONNECTION = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:25: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_BaseDir = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:26: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_SCRIPTLET = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:27: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_PARAMETERS_MAP = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:28: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_ReportTitle = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:29: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport private JRFillParameter parameter_REPORT_DATA_SOURCE = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:31: cannot resolve symbol symbol : class JRFillField location: class CustomerReport private JRFillField field_CustomerCount = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:32: cannot resolve symbol symbol : class JRFillField location: class CustomerReport private JRFillField field_BranchName = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:33: cannot resolve symbol symbol : class JRFillField location: class CustomerReport private JRFillField field_BranchCode = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:35: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_PAGE_NUMBER = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:36: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_COLUMN_NUMBER = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:37: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_REPORT_COUNT = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:38: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_PAGE_COUNT = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:39: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_COLUMN_COUNT = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:40: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport private JRFillVariable variable_TotalCustomer = null; ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:50: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport JRFillVariable[] v, ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:51: cannot resolve symbol symbol : class JRFillGroup location: class CustomerReport JRFillGroup[] g ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:52: cannot resolve symbol symbol : class JRException location: class CustomerReport ) throws JRException ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:56: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_CONNECTION = (JRFillParameter)parsm.get("REPORT_CONNECTION"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:56: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_CONNECTION = (JRFillParameter)parsm.get("REPORT_CONNECTION"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:57: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_BaseDir = (JRFillParameter)parsm.get("BaseDir"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:57: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_BaseDir = (JRFillParameter)parsm.get("BaseDir"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:58: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_SCRIPTLET = (JRFillParameter)parsm.get("REPORT_SCRIPTLET"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:58: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_SCRIPTLET = (JRFillParameter)parsm.get("REPORT_SCRIPTLET"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:59: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_PARAMETERS_MAP = (JRFillParameter)parsm.get("REPORT_PARAMETERS_MAP"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:59: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_PARAMETERS_MAP = (JRFillParameter)parsm.get("REPORT_PARAMETERS_MAP"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:60: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_ReportTitle = (JRFillParameter)parsm.get("ReportTitle"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:60: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_ReportTitle = (JRFillParameter)parsm.get("ReportTitle"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:61: cannot resolve symbol symbol : class JRFillParameter location: class CustomerReport parameter_REPORT_DATA_SOURCE = (JRFillParameter)parsm.get("REPORT_DATA_SOURCE"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:61: cannot resolve symbol symbol : variable parsm location: class CustomerReport parameter_REPORT_DATA_SOURCE = (JRFillParameter)parsm.get("REPORT_DATA_SOURCE"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:63: cannot resolve symbol symbol : class JRFillField location: class CustomerReport field_CustomerCount = (JRFillField)fldsm.get("CustomerCount"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:63: cannot resolve symbol symbol : variable fldsm location: class CustomerReport field_CustomerCount = (JRFillField)fldsm.get("CustomerCount"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:64: cannot resolve symbol symbol : class JRFillField location: class CustomerReport field_BranchName = (JRFillField)fldsm.get("BranchName"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:64: cannot resolve symbol symbol : variable fldsm location: class CustomerReport field_BranchName = (JRFillField)fldsm.get("BranchName"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:65: cannot resolve symbol symbol : class JRFillField location: class CustomerReport field_BranchCode = (JRFillField)fldsm.get("BranchCode"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:65: cannot resolve symbol symbol : variable fldsm location: class CustomerReport field_BranchCode = (JRFillField)fldsm.get("BranchCode"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:67: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_PAGE_NUMBER = (JRFillVariable)varsm.get("PAGE_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:67: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_PAGE_NUMBER = (JRFillVariable)varsm.get("PAGE_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:68: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_COLUMN_NUMBER = (JRFillVariable)varsm.get("COLUMN_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:68: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_COLUMN_NUMBER = (JRFillVariable)varsm.get("COLUMN_NUMBER"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:69: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_REPORT_COUNT = (JRFillVariable)varsm.get("REPORT_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:69: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_REPORT_COUNT = (JRFillVariable)varsm.get("REPORT_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:70: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_PAGE_COUNT = (JRFillVariable)varsm.get("PAGE_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:70: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_PAGE_COUNT = (JRFillVariable)varsm.get("PAGE_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:71: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_COLUMN_COUNT = (JRFillVariable)varsm.get("COLUMN_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:71: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_COLUMN_COUNT = (JRFillVariable)varsm.get("COLUMN_COUNT"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:72: cannot resolve symbol symbol : class JRFillVariable location: class CustomerReport variable_TotalCustomer = (JRFillVariable)varsm.get("TotalCustomer"); ^ D:BEAwlserver6.1configmydomainapplicationsListOfCustomerNoreportsCustomerReport.java:72: cannot resolve symbol symbol : variable varsm location: class CustomerReport variable_TotalCustomer = (JRFillVariable)varsm.get("TotalCustomer"); ^ 51 errors at dori.jasper.engine.design.JRCompiler.compileReport(JRCompiler.java:145) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:129) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:101) at servlets.ListOfCustomerNumberServlet.service(ListOfCustomerNumberServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
  10. 2002 JI Open Discussion
    By: Irfan Ali - umapinc JasperReports & Web Applications 2003-01-08 07:57 Hello, Can anyone walk me through an example of hooking up JasperReports with web application to display reports on web. I am already looking at webapp example in samples directory but another example will be a great help. Thanks, Irfan
  11. 2002 JI Open Discussion
    By: Muralidhar bp - pmurli java.sql.SQLException: ORA-00600: int 2003-01-08 02:56 Hello, I have written a simple report and a java program. when i complied it compiled properly and when i give "ant fill" I am getting this error. Plzz help me............... Thanx in advance. Murli C:JasperReportsEPSITFReportsListOfCustomerNo>ant fill Buildfile: build.xml fill: [java] Before fill manager [java] before loading driver [java] after loading driver [java] after getting con [java] java.sql.SQLException: ORA-00600: internal error code, arguments: [t tcgcshnd-1], [0], [], [], [], [], [], [] [java] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:1 68) [java] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) [java] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) [java] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) [java] at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) [java] at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleState ment.java:1681) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl eStatement.java:1870) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Orac lePreparedStatement.java:363) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracl ePreparedStatement.java:314) [java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE xecuter.java:353) [java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE xecuter.java:131) [java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:3 63) [java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114 ) [java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillMan ager.java:217) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF illManager.java:138) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF illManager.java:106) [java] at ListOfCustomerNo.main(ListOfCustomerNo.java:72) [java] NESTED BY : [java] dori.jasper.engine.JRException: Error executing report query : [java] select b.BRANCH_CODE, b.BRANCH_NAME, count(c.customer_id) from TF_PA R_BRANCH_PERSONALIZATION b, [java] TF_M_CUSTOMER c where b.branch_code=c.branch_code group by b.BRANCH_CODE, b.BRANCH_NAME [java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE xecuter.java:357) [java] at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryE xecuter.java:131) [java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:3 63) [java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114 ) [java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillMan ager.java:217) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF illManager.java:138) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperF illManager.java:106) [java] at ListOfCustomerNo.main(ListOfCustomerNo.java:72) [java] Java Result: 1 BUILD SUCCESSFUL Total time: 26 seconds By: Chuck Deal - cdeal RE: java.sql.SQLException: ORA-00600: int 2003-01-08 05:32 If you look near the middle of the stack trace, you'll see a line labelled 'NESTED BY:' Following this line, you will see the JasperReports exception. it is indicating that it couldn't execute your query. Perhaps, the login that you are usign in JasperReports doesn't have permission to execute that query? Perhaps you are pointing to the wrong database? Make sure that you can successfully run the query outside of JasperReports and then verify your JasperReports settings are correct (identical).
  12. 2002 JI Open Discussion
    By: ben shi - ben_shi Overflow problem 2003-01-07 13:51 Hi, I am using jasperreports 0.4.4. I set isStretchWithOverflow=”true” to a textfield, when this field contains multiple lines and overflows to next page, sometimes some other fields in the beginning of next page show some strange data. What’s the problem? Can I set something let the record entirely show begin in the next page when it need to overflow to next page? By: Vital - vitalsim RE: Overflow problem 2003-01-08 02:09 Hi, Set the PositionType attribute to "Float" to all the fields following the field which can contain multiple line data. This automatically pushes the below fields further down when data for the above field spans more than the field height Vital
  13. 2002 JI Open Discussion
    By: Bjarte Andre Eide - baeide Promblem with isReprintHeaderOnEachPage 2003-01-07 08:16 Hello! I am having some problems with the "isReprintHeaderOnEachPage" attribute on the group-element. I am using JasperReport 0.4.4 and jdk-1.4.1 Because "jasperreport.dtd" only allows me to have one element of <pageHeader> I'm using groups to simulate multiple pageheaders. The skeleton of my report is the following: <group name="grp_title"> <groupExpression>$F{ord_id}</groupExpression> <groupHeader> . . . </groupHeader> <group> <group name="grp_head" isReprintHeaderOnEachPage="true"> <groupExpression>$F{ord_id}</groupExpression> <groupHeader> . . . </groupHeader> </group> <group name="grp_expanding"> <groupExpression>$F{ord_id}</groupExpression> <groupHeader> <ban> <!-- This group contains textFields with the "isStretchWithOverflow"-attribute set to "true" --> </ban> </groupHeader> </group> <group name="grp_lastPage" isStartNewPage="true"> <groupExpression>$F{ord_id}</groupExpression> <groupHeader> </groupHeader> </group> <pageHeader> <band height="80"> . . . </band> </pageHeader> <pageFooter> <band height="30"> . . . </band> </pageFooter> -------------------------------------------------------------------------- My DataSource consists of one single row. The first page is generated correctly: <pageHeader> <group name="grp_title"> <group name="grp_head" isReprintHeaderOnEachPage="true"> <group name="grp_expanding"> <pageFooter> If the content of the textfields in "grp_expanding" is causing overflow, new pages will be generated. I would expect the layout of these pages to be: <pagHeader> <group name="grp_head" isReprintHeaderOnEachPage="true"> <group name="grp_expanding"> <pageFooter> , but JasperReports give me the following: <pagHeader> <group name="grp_expanding"> <pageFooter> The last page I would expect to be: <pagHeader> <group name="grp_head" isReprintHeaderOnEachPage="true"> <group name="grp_lastPage" isStartNewPage="true"> <pageFooter> ,but the result is: <pagHeader> <group name="grp_lastPage" isStartNewPage="true"> <pageFooter> As you can see is the group "grp_head" only printed on the first page. Is there anyone who can give me a hint on how I can come around this ? Thanks! Bjarte By: Teodor Danciu - teodord RE: Promblem with isReprintHeaderOnEachPage 2003-01-07 08:23 Hi, I don't think you'll get it through this way. If you only could explain why is it that you need multiple <pageHeader> sections, we could find a different solution. Thank you, Teodor By: Bjarte Andre Eide - baeide RE: Promblem with isReprintHeaderOnEachPage 2003-01-07 11:01 Hi! Thank you for your quick response. My PageHeader consists of three parts in the following order: 1. Company logo, address, email etc. This is to be printed on every page. (Just like a pre-printed sheet) 2. Report title This part should only apear on the first page. 3. Summary Line This should be printed on every page. This result in the following logicallly pageheader I need to find a solution for: <pageHeader> <band> </band> </pageHeader> <pageHeader> <band> <printWhenExpression>new java.lang.Boolean($V{PAGE_NUMBER}.intValue() == 1)</printWhenExpression> </band> </pageHeader> <pageHeader> <band> </band> </pageHeader> I hope this will clarify the problem. Best Regards. Bjarte. By: Vital - vitalsim RE: Promblem with isReprintHeaderOnEachPage 2003-01-08 02:04 Hi, There is a simple solution to your requirement ... You just need to put the company logo, address and email details both in the Title and the Page Header bands. Title band also contains your report title. Put your Summary Line in the page footer. Now use the PrintWhenExpression attribute for the fields placed in the page header (company logo, address, email) with the following expression so that it prints the information from the second page onwards (this is required, as the title band already prints these details once in the first page): new Boolean( ($V{PAGE_NUMBER}).intValue()>1 ) Hope I didn't confuse you too much. I had tested this and following in the XML code for the report. <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="test" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <variable name="Field" class="java.lang.String" resetType="Report" calculation="System"> <initialValueExpression>new String("Overflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig textnOverflowig text") </initialValueExpression> </variable> <title> <band height="88"> <staticText> <reportElement mode="Transparent" x="78" y="9" width="433" height="26" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" lineSpacing="Single"> <font fontName="" pdfFontName="Helvetica" size="20" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" /> </textElement> <text><![CDATA[Company Logo, address, email etc stuff....]]></text> </staticText> <staticText> <reportElement mode="Transparent" x="154" y="57" width="247" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" lineSpacing="Single"> <font fontName="" pdfFontName="Helvetica-Bold" size="16" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" /> </textElement> <text><![CDATA[Report Title]]></text> </staticText> </band> </title> <pageHeader> <band height="46"> <staticText> <reportElement mode="Transparent" x="80" y="11" width="433" height="26" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"> <printWhenExpression> new Boolean( ($V{PAGE_NUMBER}).intValue()>1 ) </printWhenExpression> </reportElement> <textElement textAlignment="Center" lineSpacing="Single"> <font fontName="" pdfFontName="Helvetica" size="20" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" /> </textElement> <text><![CDATA[Company Logo, address, email etc stuff....]]></text> </staticText> </band> </pageHeader> <columnHeader> <band height="5"> </band> </columnHeader> <detail> <band height="50"> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement mode="Transparent" x="221" y="9" width="59" height="23" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" lineSpacing="Single"> <font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" /> </textElement> <textFieldExpression class="java.lang.String">$V{Field}</textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="4"> </band> </columnFooter> <pageFooter> <band height="50"> <staticText> <reportElement mode="Transparent" x="168" y="7" width="240" height="31" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Center" lineSpacing="Single"> <font fontName="" pdfFontName="Helvetica-Bold" size="14" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="false" /> </textElement> <text><![CDATA[Your summary line goes here...]]></text> </staticText> </band> </pageFooter> <summary> <band height="50"> </band> </summary> </jasperReport> Rgds, Vital
  14. 2002 JI Open Discussion
    By: Jonathan Keller - kellerj Classloader problem with Jasper 2003-01-07 15:26 We have an interesting situation where we need classes from a classloader which is not the classloader that JRClassLoader is loaded from but IS the thread context class loader. The JRClassLoader always assigns its loader as the parent loader. Has anyone else created a work around for this problem? I was thinking that it could be corrected by adding a new static property to JRClassLoader, allowing the parent to be set prior to calls to JRClassLoader.getInstance(). This would leave the current behavior alone, but allow another class loader to be set as the parent. I would be happy to upload a patch to do this as it would solve our problem and we don't want to fork from the main distribution.
  15. 2002 JI Open Discussion
    By: RR - raffarost Package importing 2003-01-07 05:50 Hi, is it possible to import packages into the report, in order to access some class methods via textFieldExpression? Do I have to create a scriptlet to access these methods? Thanks, Raffael R. By: Teodor Danciu - teodord RE: Package importing 2003-01-07 06:06 Hi, No, you just have to use the entire name of the class (including the package prefix) when working with it in the expression. I hope this helps. Teodor By: RR - raffarost RE: Package importing 2003-01-07 06:45 Thank you. Raffael R.
  16. 2002 JI Open Discussion
    By: eric teo - duckizz I have problem compiling and displaying pdf 2003-01-06 23:09 hi...i have problem compiling and storing into pdf to display chinese characters. if i use project properties = UTF-8 and the text field properties = UniCNS-UCS2-H (Tradditional Chinese)..if i use xls , html or cvs i can compile and display. but pdf will have problems. Anyone can help ? By: Teodor Danciu - teodord RE: I have problem compiling and displaying pdf 2003-01-07 02:31 Hi, If the pdfEncoding is "UniCNS-UCS2-H" or "UniCNS-UCS2-V", then I guess pdfFontName should be "MHei-Medium" or "MSung-Light" as specified here: http://www.lowagie.com/iText/tutorial/ch09.html I hope this helps. Teodor By: eric teo - duckizz RE: I have problem compiling and displaying pdf 2003-01-07 02:45 hey thanks ! it works now => template wise so far if we need to edit the templates or create templates we have to do it manually right ? By: eric teo - duckizz RE: I have problem compiling and displaying pdf 2003-01-07 02:39 hey thanks ! it works now => template wise so far if we need to edit the templates or create templates we have to do it manually right ? By: Teodor Danciu - teodord RE: I have problem compiling and displaying pdf 2003-01-07 02:49 Hi, Not sure what you mean, but there are GUI tools for JasperReports these days or you could create report templates programatically. See the "noxmldesign" sample. Good luck! Teodor
  17. 2002 JI Open Discussion
    By: Avinash - gavinash Last Page Identification 2003-01-06 15:52 Hi, I have a 2 groups in my reports design. The footer of the 2nd group has some elements that needs te be present only in case the page is the last page. Can anyone tell me how can I achieve that. I looked at earlier messages on the same topic and found the way of doing this in case of the main group footer or the page footer, but how can I do the same thing in a group which is not the main group. Thank You Avinash
  18. 2002 JI Open Discussion
    By: Avinash - gavinash Subreports 2003-01-03 15:39 Hi, I'm new to JasperReports. I was trying to learn to use subreports in my reports. So I created a report with static texts in it's title and am now trying to embed this report in a MasterReport. It compiles and fills allright byt when I try to view it the subreport does not appear. Can someone give me a direction to solve this problem. Here;s my subreport and the master report : <?xml version="1.0"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="SubReport" pageWidth="150" pageHeight="15" columnWidth="150" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0"> <title> <band height="15"> <staticText> <reportElement x="0" y="0" width="150" height="15"/> <textElement textAlignment="Right" lineSpacing="Single"> <font size="12"/> </textElement> <text>Part of Subreport</text> </staticText> </band> </title> </jasperReport> Place where i embed the above subreport into the Master: <group name="CountryGroup" isStartNewColumn="true" isResetPageNumber="true" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="200"> <groupExpression> $F{ShipCountry} </groupExpression> <groupHeader> <band height="155"> <subreport isUsingCache="false"> <reportElement x="300" y="5" width="150" height="15"/> <connectionExpression> $P{REPORT_CONNECTION} </connectionExpression> <subreportExpression class="java.lang.String"> "SubReport.jasper" </subreportExpression> </subreport> </groupHeader> Thank You Avinash By: Teodor Danciu - teodord RE: Subreports 2003-01-06 08:32 Hi, The master report displays anything at all? Does the master report data source contain any records in it? Thank you, Teodor By: Avinash - gavinash RE: Subreports 2003-01-06 09:21 Teodor, Yes the master reports does have data and it does display it. Also if I get a pdf out of the report the subreport data appears with data properly in the pdf but the viewer does not show the subreport at all. Is there something that I'm missing. Thank You Avinash By: Teodor Danciu - teodord RE: Subreports 2003-01-06 09:33 Hi, The fact that some data appears in PDF, but not in the JasperViewer is indeed a little weird. May I see the PDF and maybe a screenshot of the report in JasperViewer ? If you could export the report to XML format and send it to me it could be even better. teodord@hotmail.com Thank you, Teodor By: Avinash - gavinash RE: Subreports 2003-01-06 11:20 Thanks to Teodord, I fixed it. The problem was that the elements had heights of 15 and font size of 12 and apparently font size 12 takes a couple of more pixels than 15 to fit. I changed them to 17 and now it does appear in the viewer. Avinash
  19. 2002 JI Open Discussion
    By: Vanishree Viswanath - vanishreehv Dynamic evaluation of columns 2003-01-02 12:20 Hi, I have a requirment that needs to evaluate columns using values from result set and also a value that is out side the result set and is got from an XML file. This value is different for each row in the result set. How do I do it ? Can the fill manger help to fill these columns by doing the calculation in the javacode ? Example. Result set looks like. ------------------ code, processingTime XML fields look like -------------------- code, maxProcessingtime Report looks like. --------------- code, % deviation in processing. ------------------------------------- %deviation in processing = (maxProcessingtime - processingTime) *100 / maxProcessingtime Thanks in advance. By: Teodor Danciu - teodord RE: Dynamic evaluation of columns 2003-01-06 08:41 Hi, There are at least two solutions fo this: 1) You create a custom data source for your report. Check the "datasource" sample. 2) You use scriptlets. Check the "scriptlet" sample. I'm sure you'll make your choice after fully understanding both features of the library. I hope this helps. Teodor
  20. 2002 JI Open Discussion
    By: Pinkal Shukla - pinkal Multiple TexField Colors 2003-01-06 08:04 I want to display multipleTextfield colors in my detail field eg. one line red and othe blue Can you pls. help me i tried printWhenexpression but no result Thanks
  21. 2002 JI Open Discussion
    By: RR - raffarost UTF-8 encoding not recognized in PDF 2003-01-06 02:33 Hi, I'm trying to use the UTF-8 encoding in JasperReports XML files, so when I want the "ᦱuot; character to be printed in a report, I use "á" instead. The compilation of the XML files is ok, but when I load the PDF file, Acrobat keeps loading the "á" character. The encoding property of the XML file is properly set to "UTF-8". Thanks, Raffael R. By: Teodor Danciu - teodord RE: UTF-8 encoding not recognized in PDF 2003-01-06 06:20 Hi, Please try this patch and tell me how it worked: http://sourceforge.net/tracker/index.php?func=detail&aid=663125&group_id=36382&atid=416705 Thank you, Teodor By: RR - raffarost RE: UTF-8 encoding not recognized in PDF 2003-01-06 07:48 Teodor, It worked perfectly. Thank you very much. Raffael Rostagno By: Teodor Danciu - teodord RE: UTF-8 encoding not recognized in PDF 2003-01-06 07:55 Hi, Well, then this will be part of the next release. Thank you, Teodor
  22. 2002 JI Open Discussion
    By: Moisey Blehman - rhal Stored Procedure... 2003-01-05 09:37 Hi, Is there a way to execute stored procedure that doesn't return a ResultSet AND doesn't have any OUT parameters? I would like to use this procedure to generate some table first and use it afterwards through select statement in the 2nd query. By: Teodor Danciu - teodord RE: Stored Procedure... 2003-01-05 23:52 Hi, Execute the store procedure before launching the report. Let JasperReports deal only with the query. I hope this helps. Teodor
  23. 2002 JI Open Discussion
    By: Moisey Blehman - rhal 2 SQLs in Reports... 2003-01-04 09:02 Hello. Is there a way to execute 2 sql queries in the report? For example - first is a procedure call, and the second is select query itself...? Thank you. By: Teodor Danciu - teodord RE: 2 SQLs in Reports... 2003-01-05 23:51 Hi, JasperReports can execute queries for you just as a bonus feature. It is not its job to behave like a general query executer. The parent application that uses JasperReports should be in charge of this if more complex JDBC calls are needed before filling a report. Support for stored procedures in JasperReports is something I plan to add however. Thank you, Teodor
  24. 2002 JI Open Discussion
    By: ervin chua joy - notinthisworld How to create an xml 2003-01-01 03:03 how can i create an xml with the correct parameters for making a good format for the report By: CARLOS ALBERTO SILVA - csilva2001 RE: How to create an xml 2003-01-01 07:11 Hi. Happy new year to you. Like you, I know nothing about xml. But need make a report. I thing IReport could help you. It is a graphic interface for jasperreport, create xml, compile, test... . Try it: http://ireport.sourceforge.net An embrace, Carlos By: ervin chua joy - notinthisworld RE: How to create an xml 2003-01-01 15:37 Happy New Year.... so here is the scenario..... i have a firebird database and some data inside.... what should i do first? create an xml so that i will the format of the report??? sorry if i ask useles questions... "complete newbie" By: ervin chua joy - notinthisworld RE: How to create an xml 2003-01-02 04:39 pls help someone By: Teodor Danciu - teodord RE: How to create an xml 2003-01-02 04:50 Hi, You can check the provided samples and start to create your own reports by modifying them. You have to keep the "Quick Reference" at hand, because it is the main document that will help you create correct XML report designs. There is no recipe for creating reports. You just start to build them and if you have troubles or quiestions, you ask. Good luck! Teodor By: ervin chua joy - notinthisworld RE: How to create an xml 2003-01-02 05:34 Good Evening Thanks teodor By: ervin chua joy - notinthisworld RE: How to create an xml 2003-01-03 15:37 if i have successfully creted an xml, what next? By: Teodor Danciu - teodord RE: How to create an xml 2003-01-05 23:46 compile, fill, view or export to PDF, HTMl, etc. Read this: http://jasperreports.sourceforge.net/quick.how.to.html I hope this helps. Teodor
  25. 2002 JI Open Discussion
    By: Pinkal Shukla - pinkal multi colored display of text in detail 2003-01-03 13:28 how to display multi colored detail in textfield pls. help thanks By: Teodor Danciu - teodord RE: multi colored display of text in detail 2003-01-05 23:40 Hi, All the content of a text element has the same font settings (size, color, etc.). Variable font settings could be introduced using HTML text content. But this is a feature that will not come too soon, as it is not simple to implement. Thank you, Teodor
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore