Intelligence (Analytics)

Analytics applications that use Magellan BI & Reporting

Stacked Bar Series - How to reorder the legend
I have a stacked bar chart with five series (A, B, C, D, E). The chart is drawn as I like to have it: A is at the bottom and E is stacked at the top. But in the Legend A is at the top and E is listed as last. How can I change the legend order without changing the stack order?
Change the legend order
Hi I create a bar chart
How to change the legend order
Hi, my Eclipse BIRT Designer version is 4.9.0 and I have a problem with the legend order in the bar chart. The legend order looks good to me for my series A, B, and C. However, when I stack the bars(check the option"Stacked" in "Series" in the "Format Chart" wizard), the legend order is reversed. Is there a way to reverse…
ClassNotFoundException
I am trying to run the following code. public static void main(String[] args) { IReportEngine engine = null; IReportRunnable design = null; IRunTask task = null; IReportDocument iReportDocument = null; IDataExtractionTask iDataExtract = null; ArrayList resultSetList = null; IResultSetItem resultItem = null; String dispName…
Use custom fonts in BIRT pdf report
Hi, We want to use a google font, Poppins, in our report. In the designer the font is shown, but when the report is deployed and generated in PDF, the fonts Times-Roman is used. BIRT is deployed in a WildFly server. Thanks
Storing dataset in BIRT array variable
Iam running a Dataset on a datasource, i need to use one column values out of the data set to another Dataset which is connected with another datasource. So i need to store the Array of row['column_name'] to a variable. I tried creating a page variable and on fetch method i tried using, uoi[i] = row["uoi_id"]; i++;…
BIRT 2.6 Bug?
I'm having some problems with the update from BIRT 2.5.2 to BIRT 2.6. First, I've found the same problem than here: https://bugs.eclipse.org/bugs/show_bug.cgi?id=322103 Second, I have troubles with "Divide by zero" error: - Let's have some data like that: A, B, C, CODE, DATA 0, 0, 0, 1, 2010-01-01 0, 0, 0, 2, 2010-02-01 0,…
ODBC connecting to MSSQL "Availability Group Listener"
We currently using TB 7.4.3 build 67790 and we are using the ODBC connector (SQL.ini) to our databases. We are trying to create a SQL cluster with a "Availability Group Listener" on top. Current configuration of the string in SQL.ini (this works fine): remotedbname=SHFL,DRIVER=SQL…
Code example for BIRT OTMM
Hi, Iam trying to create Custom reports on OTMM and BIRT, as per OTMM document i see code examples would be available under But i wasnt able to locate, kindly share me the link to locate the code example for BIRT OTMM reporting
Row values in Y series of the chart???
Hello All, I have row["val1"] to row["val15"] computed values for 15 yrs in table. I want to plot a graph based on this data. I want to take this row["val1"] to row["val15"] as y axis series and 1 to 15 yrs as X axis in the line chart. can i create a dataset by using these values or something like this to use it for the…
BIRT POJO empty report
Hello I am new to BIRT, I am trying to run my report using POJO datasource. I created my PersonBirt class with my 3 methods: public class PersonBirt { @Autowired private PersonProvider personProvider; Iterator<PeopleLinkData> iterator; public void open(Object appContext, Map<String, Object> params, PeopleLinkFilter filter)…
Unable to add column to existing table error The style "tabledetailslabelcell" used by Cell
Trying to troubleshoot this so I don't have to rewrite the entire report, I get the error above when right clicking on the colum and trying to add column to either left or right. Appears to be an embedded table, didn't write this report. Error when attempting is 'The style "table details label cell" used…
java.lang.OutOfMemoryError: Java heap space
SQL Preview shows all data, but if I run the report via Excel I get this error!?! Please help! :) Thx!
onRender method
Hi, I have recently upgraded BIRT from version 2.2.1.1 to 2.6.2. Now it seems that the onRender method has stopped working or changed its behaviour. I used it to print a text on a continuing page, a text I don't want on the first page. Does anyone know anything about this? /aca
BIRT Report not rapping strings correctly based on content
I think have found an issue with wrapping text in version 4.8.0.v201806261756 of BIRT Report Designer I have two strings that are treated differently when viewing the report in PDF format. The following two strings differ only in the character after the third hyphen SAF0250-01-002-F3991 SAF0250-01-002-73991 When I try to…
Birt Cross Tab Report Grouping on Month Wise need to merge In one single row
Hi All, I want to merge rows if there are multiples for same Item in cross tab report. I have attached the screenshot and .rptdesign file
Rounding issues?
Hi guys, I'm new to BIRT so please pardon my n00bish questions. I'm sure I'll have quite a few. I'm running a report with a table where I'm trying to calculate what is essentially an average. I expect these averages to always be very close to 1 (i.e. 0.99876). To do this, I'm running a query where I'm getting two "Count"…
problem in import package in birt script
hi all, I write below code in script . importPackage( Packages.java.io ); importPackage(Packages.java.text.SimpleDateFormat); outFile = new FileWriter("../sandfilelogtoday.txt"); out = new PrintWriter(outFile); sdf = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss:ms"); out.println(sdf.format(new Date()).toString()+"--…
Align decimal points
Thanks in advance! birt designer 4.31, we have the following data: $123.45 $3256.87 $2345667.34 $1.45 what we are looking for should look like this: $123.45 $3256.87 $2345667.34 $1.45 Thank.
BIRT Chart Scripting: Dynamic Markers and DataPoint Colors
BIRT Report Design that shows how to create global variables in a table script event and then use those variables to dynamically create chart markers. The values of the markers are used as a compasison to determine each data points color. More details and screenshots about this example can be seen at…