Hello, How to make a linear regression on the chart displayed into your BIRT report. I have x and y data... but I don't see any function on eclipse BIRT to generate the linear regression... Any idea ? Many thanks ...
Has anyone got any recommendations for a reporting framework, where it is possible to export into a word document and have charts editable inside MS Word. By this I mean the user should be able to double click on the chart and customize it, add trend lines, labels etc.. So far I have evaluated BIRT and SQL Reporting Services, but as far...
I have successfully connected to DB2 database using db2jcc.jar and now facing another issue. When i create a dataset and preview it. BIRT viewer throws following error. Cannot get the decimal value from column: 1. Cannot get BigDecimal value in the result set. SQL error #1: [IBM][JDBC Driver] CLI0610E Invalid column number. SQLSTATE=S1...
I'm using birt to create report chart, I want to show tooltip on chart. How to set delays to display tooltip for long time ? Thank you in advance. ...
Hello everyone I'm designing an accounting report with various aggregations and data fields and when I try to aggregate on a field I get the following error: "Target Aggregation Name does not exist" Now... the computed field has its expression like this if( row["A"] == 'ASSET' ) { some value } else { 0; } if I put a consta...
User table contains the following attributes (dateOfBirth, race, gender, ...). We would like to generate a report in the following format. Year Race All Male Female 2000 Asian 2000 1000 1000 2000 Hispanic 1000 500 500 2001 Asian 1500 700 800 2001 Hispanic 1300 400 900 ... Total 5800 2600 3200 Ideally I would like to...
I have a pie chart in BIRT and about 80 data points. I'm looking to group them in three catagories <17 17-20 and >20. To be more specific I'm trying to make a red yellow green chart. How can I do this. I tried the grouping function, but it only allows even intervals that I can find. Thanks, Buzkie ...
I have a eclipse installed to work with BIRT reports. What files in the workspace should be committed to the repository and what files should not? ...
Hi, so I am having pretty much exactly the same problem as what someone else has described here: birt-exchange. I have integrated BIRT with my existing web application that requires the xerces jar (mine is version 2.5) and the following exception is thrown when I attempt to view the report: java.lang.NullPointerException at org.ecl...
I have one dataset and create from this set an area chart. In this case no problem. But now I have the requirement to add dynamic markers to the chart. So, this is the example: Data Set: date | workload | type The report renders a chart, which displays the date on the x-Axis and the workload on the y-Axis. The Type shows the different...
I am using Birt 2.3.1. While rendering it on PDF the format is not appropriate. For report we are having Pagination of 20 On HTML it renders fine. But when it is rendered on the PDF it displays 12 rows in one page and remaining 8 on the other. I want my all 20 rows in one page itself or if any one has any idea whats the ideal way to d...
I am building a simple BIRT report using an XML data source. However, I had to use 3 different views (3 cross-tabs) of the same data on the same report. While running the report, I noticed that BIRT was firing multiple calls to fetch the XML file (hosted in a web-server). I have tried fiddling with the settings tab of the edit screen of ...
I have a problem in the connection between db2 and birt. I found an answer that said: This may have nothing to do with BIRT specifically. Perhaps your query to retrieve the data. Have you tried using the jdbc driver stand alone in a simple Java program to try and retrieve the data? This may be easier to debug (as you can...
Hello, I tried to use BIRT in my webapplication project. But I'm getting this kind of exception all the time: org.eclipse.birt.core.framework.FrameworkException: Could not find the Framework - org.eclipse.osgi at org.eclipse.birt.core.framework.osgi.OSGILauncher.doStartup(OSGILauncher.java:123) at org.eclipse.birt.core.framework.osgi...
Hi, I am attempting to write some script that simplifies table sorting and have been getting quite close but am now wondering if I have found a bug...or have just misunderstood limitations. So my relevant code: var reportRunnable = reportContext.getReportRunnable(); var reportDesign = reportRunnable.getDesignInstance(); var table = re...
I have a situation in BIRT reporting. A report I created is insisting on displaying some fields as blank rather than zero. The situation arises when the field is actually a sub-select that returns no rows. So for example, if the select includes: 0 as p3, then the 0 is displayed okay. If however, the select has: (select sum(other_fie...
Hi all, Im having trouble with some javascript in the onFetch step of a dataset in a BIRT report. I've added logging in the initialise step of the report in a few different ways. The runtime im using is Tivoli Common Reporting, and they supply a logging framework. Its initialised as so reportContext.setPersistentGlobalVariable("logfil...
Hi, I am using BIRT APIs in a java program.My code is : package com.tecnotree.mdx.product.utils; import java.util.HashMap; import java.util.logging.Level; import org.eclipse.birt.core.exception.BirtException; import org.eclipse.birt.core.framework.Platform; import org.eclipse.birt.report.engine.api.EngineConfig; import org.eclipse.bir...
Hi, Is there a way to externalize report queries for BIRT reports. We need to support multiple database engines and so our queries are different depending on the underlying database. I would like to use a config parameter to tell BIRT report to use a specific query file ...
I am generating PDF/HTML report from a BIRT template. I am using "visibility" property to hide a grid row conditionally. It is working fine and that row is hidden in generated report. But, I am getting a bottom border missing from the upper grid row in my PDF report and although HTML report is generated perfectly fine. To understand i...