Discussions
-
Deploying to BIRT 4.2 Viewer Web App
I am new to BIRT and I am having a hair-pulling time of it getting the report to execute in the BIRT Viewer running on Tomcat. <br /> <br /> To begin, I have performed the following tasks:<br /> <br /> * installed BIRT 4.2.1 to Tomcat 6.32 running on an iSeries machine * developed the design file using Eclipse, Version:…
-
BIRT is connected to DB but does not pull data when I preview
I use the <a class='bbc_url' href='http://troux.com'>Troux</a> Enterprise Architecture tool and its analytics are built from BIRT reports. The back end database for Troux is SQL Server 2005. I just got the BIRT data source to connect to the SQL DB. My next move was to open a report that is already made and working in Troux…
-
Line chart - Y-Series not in sync with data
Hi, I have line chart with 2-series and it value consist of float value. But somehow y-series value does not match with value the series has. Looks like it display with multiplication of 10. I have not specified anything like this. Attaching simple generated report with data and chart. Please help me on this. BR, Utkarsh
-
Birt Viewer export PDF in server Debian
Hi all, I have a problem with the value of bar chart when I make a export pdf in the birt viewer in my prod server, while in dev server it is displayed correctly. In my server dev I have a Ubuntu : Viewer Version : 4.2.1 Engine Version: 4.2.1 JRE version: 1.7.0_17 In server prod a Debian : Viewer Version : 4.2.1 Engine…
-
Adding dynamic table columns based on dataset SQL query resultset
Hello All, I have a requirement to develop a report which shows a table with dynamically changing columns based on the SQL query dataset resultset, which have to be analyzed to create required columns. I read some previous posts about dynamic column addition, but couldn't find any in which dataset result set is analyzed to…
-
change NaN value to another value
Hi, I want to create a computed column in a data set, which is the ratio of 2 output columns I wrote an expression to change possible NaN result due to division by 0, but I still have NaN as a result. Here is my expression : value = new Number(row["C1"]/(row["C2"])*100); if(value == Number.NaN) { value = 100; } value; Any…
-
Use of Design and Report API in scripted dataset open method
I have an xml data source. I need to insert a chart line in my report and I cannot get all data from single/joint dataset as there are some complex calculation I cannot perform using simple XML.<br /> I need to create a scripted datasaset that reads data from the input xml and performs some calculation in order to define…