birt

Display blanks instead of 0 or 0.0 in a BIRT report

When using an aggregate control in some reports you would prefer to see a blank field instead of 0. There does not appear to be a way to do this automatically. Does anyone have a way that this can be done. Note, you want to maintain the '0' value for the field in cases when you export, but you want to show a blank when rendering to PD...

Initialization Troubles with BIRT Runtime Engine API

Hi, I'm new to BIRT and I'm trying to make the Reprt engine running. I'm using the code snippets provided in http://www.eclipse.org/birt/phoenix/deploy/reportEngineAPI.php But I have a strange exception: java.lang.AssertionError at org.eclipse.birt.core.framework.Platform.startup(Platform.java:86) and nothing in the log file. May...

How Do I Download the Source for BIRT?

The Eclipse projects are all stored in the Eclipse Foundation CVS servers. Using the source is a great way to debug your code and to figure out how to do new things. Unfortunately in a large software project like BIRT, it can be difficult which projects and versions are required for a particular build. So what is the best way to ge...

In BIRT, how do I access an arbitrary data set from JavaScript?

I am building my first report in BIRT. Very quickly I ran into a problem in which I wanted to display some text or data based on an expression that included data from two different tables (not tables that can/should be joined - (hypothetically example- take a student's ACT score from his record in the student table and compare it agains...

How do I avoid page breaks inside tables and groups in BIRT ?

When creating reports using BIRT 2.3.1, I don't want page breaks inside tables or groups; if the table doesn't fit in the space available at the page, I want to put the entire element in the next page. Using previous versions of BIRT it was possible to set pageBreakInside to "avoid", but it didn't work. In BIRT 2.3.1 this (useless) opt...

What is the simplest way to set up a BIRT report viewer for a xulrunner application?

I recently began using BIRT and have developed a report to use with my xulrunner application. What I haven't yet figured out is how I should deploy the viewer. It seems like BIRT mostly targets Java applications, so there are instructions for deploying on J2EE, JBoss, and other technologies -- with which I am not familiar (but I'm not ...

How do I combine multiple BIRT reports

We currently have a whole suite of report designs that cover various parts of our app, and these reports are generated on demand by our users. I want to be able to bundle up several of these reports into a single report to return to the user. I initially hacked up a custom report builder that generated report design files using segment...

birt in a desktop application

Did someone ever used a birt report in a desktop application. I'm comming from the .net environment an there you can use crystal reports to show reports in desktop apps. Is this possible with birt too, without having to set up a server environment? Can you give me some advice how to reach this goal? thanks in advance. ...

BIRT: pdf emitter, load/use fonts from relative path or from jar files

Hi all! I use BIRT since early days and still have riddles regarding PDF emitter. Short story: Can I configure fontsConfig.xml to load fonts from relative path or from jars? Long story: We are using FOP for generating PDF in our web application as well as BIRT. It will be nice to share fonts between libraries. Unfortunately, I can't ...

In BIRT, how do I access the children of a cell from the cell's event script blocks

I am creating images dynamically in BIRT and adding them to a cell of a grid. The grid is part of a List, which iterates over the records in the data source. I want to be able to modify the properties of the images on a per-record basis. Specifically I am changing the margins - but my problem is that I cannot find the way to access th...

Multiple questions on BIRT

Hi, I am new to BIRT. I have a requirement to print a HEADING based on a database value. How do I do that? How do I leave a Blank line upon break in one of the fields I am reporting? In the footer, I need to say "Page X of Y" where Y is the total number of pages? Your help is much appreciated - ASAP Thanks Nurani Sivakumar ...

Can't see all tables in datasource

I'm using Birt 3.4.1. I was able to create a datasource.. but I can't see all the tables in my database. When I try to create a database I see 1/3 of my tables in the Orace 10g database. ...

Upgrade to Birt 2.3.1 and log SEVERE: Not allowed choice any

After an upgrade to BIRT 2.3.1 have a tons of logs: org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml SEVERE: Not allowed choice any Any thoughts how to rid of them will be appreciated. ...

How best to maintain an Eclipse RCP plugin target?

I have a plugin for an RCP app that uses BIRT. I have a target for building my app which contains only the plugins/features that are required. I recently updated the BIRT plugin versions in my IDE, which created an incompatibility in the design files with previous versions of BIRT. I have the old version of BIRT in my target and need to ...

BIRT: Alternating row Color in a table group...

Hi! :-) Has anybody an idea of how the highlighting condition has to look like, to create alternating rows in groups? I want the every row with an even number of a table group (not of the whole table) to have a different color. Thanks in advance! :-) Patrick P.S.: I'm using BIRT 2.1.3 ...

BIRT Formating Legend of a bar chart

I have a small problem, a BIRT report I designed uses a bar chart. Now I want to increase the space between colored box and the text in the legend. Is that possible? (I'm using BIRT 2.1.3) EDIT: I forgot to mention I am using BIRT 2.1.3 with the RCP Designer. ...

How do I put a StockSeries in front of a BarSeries on a combination chart in BIRT?

Hi all, Consider the below source code where I create a combination chart with a BarSeries and a StockSeries. The StockSeries generates three identical Candle-stick Stock figures with a box from values 12 to 14 and low and high values 10 and 16. The BarSeries generate three bar figures with heights 11, 13 and 15. public class StockBar...

BIRT 2.2 dynamic schema name

Is it possible to make the schema name dynamic in a BIRT query. I tried this: SELECT CURRENT DATE AS DATE, (CASE WHEN DAYOFWEEK(CURRENT DATE) = 1 THEN 'SUNDAY' WHEN DAYOFWEEK(CURRENT DATE) = 2 THEN 'MONDAY' WHEN DAYOFWEEK(CURRENT DATE) = 3 THEN 'TUESDAY' WHEN DAYOFWEEK(CURRENT DATE) = 4 THEN 'WEDNESDAY' WHEN DA...

Eclipse BIRT: Problem with number of rows in a dataset

Hello!:-) My new Problem is the following: An sql-query to a database (DB2) returns 1500 rows but BIRT shows me only 500 in the dataset-editior. To count them i used a computed column (Integer) with the following logic: Total.count(row["VPK"]) I'm using the RCP-Designer (BIRT 2.1.3). How can i get the other rows as well? Patrick ...

BIRT Dynamic Filters on Runtime

Is there a neat way to access a BIRT report's datasets to add/modify some filters. I know I can just change the XML(rptdesign) file but I'm hoping for a java method or something. By the way, I'll access it through PHP-Java Bridge because my front-end is on PHP. ...