birt

Can BIRT be used within a web application without deploying a separate web application on the server?

Can I use BIRT within my application instead of deploying as a separate app on the webserver? I know that BIRT viewer can be integrated with the application by installing it on the server. I went through the process and its very cumbersome. It requires me to import too many JARs and then code too much even for a simple report. Jasper on...

Looking for advice on the best way to show BIRT reports in Drupal

On a Drupal app, my goal is to display a page with a couple of CCK or taxonomy drop-down widgets, two Date Popup Calendar widgets and a "fake" submit button. The submit will use ajax to send the info to a PHP page that generates a BIRT report and returns the complete HTML back to the page, which I'll just inject into an empty div. I'd li...

How do we group in BIRT without wasting lines, and still only printing the group item on the first line?

When grouping in BIRT, we frequently want the grouping value to show up on the first line as follows: Group User Reputation ------ --------------- ---------- Admins Bill The Weasel 51,018 Mark Grovel 118,101 Users Pax_my_bags_got_to_go 73,554 ...

Formating tooltips (help text) in BIRT 2.5 ?

Is it possible to format the built in tooltips (Help text propperty) of BIRT 2.5 ? Ex: make some words bold , even insert some html content. Thank you ...

Best way to generate report using multiple databases

Hi All, I am new to the reporting world. Wanted to know which is the right solution to about for generating a single report by querying for data from multiple databases. We are planning to use some reporting solution like Jasper Reports or BIRT. Generally the databases are going to be postgresql. Please do feel free to let me know abou...

How to reduce size of BIRT generated PDF with background image?

It seems (at least that is our understanding of the issue at this point) that given a background image in BIRT, the PDF generation routine repeats the image information inside the PDF instead of having it once referenced as the background image of all pages of the PDF. This causes our BIRT generated PDFs to be too large. Is there a way ...

BIRT vs Jasper Reports

Hi, I goggled for 2 hours to find what shall I use. I found that both are good and have good community. BIRT is supported by IBM, IBM integrated Tivoli reports with it. This proves it is good and will keep growing. Jasper Reports has fairly bid community and (probably) a better report designed (iReport). My requirement is simple: I w...

Problems with Data Explorer in RCP application

I embedded the Birt Report Designer in my RCP application, and I am able to open and save report designs easily, but there are some problems with the Data Explorer View. None of the New... menu items appear in the context menu (all of the other context menu items appear). For example Data Sources should have a menu item "New Data Sourc...

Set query FROM table using report parameter in BIRT

Hi, I am using the BIRT report writer, and I have multiple tables with the same data structure. In my report design, I want to select the table my query uses as a report parameter (as part of a mysql query in the data set) -- but I can't figure it out. When I create the data set, it's great that I can use parameters in the form of SELE...

Out of the box approach to upload XML file to the BIRT Server for Processing

Hello, I have the BIRT Report Server configured in TOMCAT and it works fine when running reports that require an XML datasource, but that XML file has be available on the network in order for the server to find it and run. Is there an out of the box configuration in the BIRT server that will prompt the user to upload the XML file direc...

Dynamic sorting of tables on BIRT without javascript

I am using WebViewerExample as my reporting. I am designing reports within Eclipse using report designer. I have a table with several columns. Data is retrieved from database. Is there an easy way to dynamically sort the tables by clicking on the column header names? I tried to pass string as a sorting condition, but it ain't helpin...

Eclipse BIRT - Unnecessary inline style with external CSS when rendering HTML

Hello! I am designing a report using external CSS with BIRT 2.5. When BIRT renders the html report, it creates copies of each external style to inline styles (name style_x) in the resulting html. The report.design contains: <list-property name="cssStyleSheets"> <structure> <property name="fileName">… mycss.css</property> <property nam...

How to change default locale in BIRT

Hi everybody, I am working with the BIRT reporting engine and my current task is to implement internationalization for reports. We are using the webviewer to generate and download pdf reports. There is a parameter (__locale) which allows me to specify the locale that should be used to generate a report. So far everything works fine. T...

Web based Report Designer Spring/Hibernate

Hello, i am looking for a web based report designer supporting spring/hibernate. I have seen BIRTStudio but it is not free. I came across this list http://java-source.net/open-source/charting-and-reporting which could be helpful.It might be appropriate to cookup my own small reporting engine as my core requirements are -End user shoul...

Eclipse BIRT - XHTML output

Is there a way to set BIRT to output a report as XHTML (1.0 Transitional would be fine) instead of HTML? I did a few tests and there are some elements that are not valid:head does not include a title, html must have a namespace (xmlns) attribute Is this functionality supported at all by BIRT? ----- EDIT ----- Here are the current cha...

Defining transaction isolation in BIRT

My BIRT report retrieves data using a SQL query (JDBC datasource). My SQL Server 2005 database is set to use snapshot transaction isolation. How do I define the transaction isolation mode in BIRT report designer ? Programatically it's done calling the datasource method setDefaultTransactionIsolation(4096) (4096 means snapshot isola...

BIRT PDF report : fixed table heigth?

Hi, I am trying to display a table to display of products (rows) in a single A4 fixed layout page. I manage to add a table with header/detail/footer sections but I can not set a minimum heigth for the detail section (150mm for example). If I set a 150mm heigth on the detail row, then Each row will have that 150mm heigth. Whereas I would ...

Birt 2.5.2 report generates empty table data when run from a cron job

I've got a shell script that runs genReport.sh in order to create a .pdf formatted report, and it works perfectly when it's run from the command line. The data source for the report is a ClearQuest database. When it's run from a CRON job the .pdf file is created, except that only the various report and column headers are displayed, and...

Class loading issues with BIRT

We bundle the BIRT runtime with our application(EAR file) and everything was fine with version 2.2 which we were using until recently. However when we upgraded to BIRT 2.5.1 we are running into class loading issues. The BIRT runtime packages a xerces.jar file which is the root cause for the class loading conflict becuase there is anothe...

Birt Global Integer

Hi there I have a Birt Report which read some stuff from a database. After that i want to increment a global Integer for every Detailrow that is loaded. So far i have initialized a global Integer with the following lines: importPackage(Packages.java.lang); reportContext.setPersistentGlobalVariable("minTotalPlus", new Integer(0)); Afte...