Analytics

Analytics applications that use Magellan BI & Reporting (OpenText iHub, iServer, or Eclipse BIRT runtime)

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…
Auto Reload
I have a legacy BIRT (2.6.1) report that is using a text block, set to HTML, causing the report to reload every 60 seconds. I am recreating the report in BIRT 4.2.1 I did some research and it appears to have been sourced from <a class='bbc_url'…
Adding Tags to PDF Report
Hi, I've to design a report that is ADA compliant for which I need to add tags to the report. I'm new to this and I'm unable to find resources to learn about adding tags to the PDF Report. If anyone could let me know of any such resource it would be really helpful. Also, I have few…
Spudosoft xlsx emitter occupies more heap space
I have requirement to export the Birt report into xlsx format. I see Birt is using spudosoft emitter for xlsx format. For less records , the export seems to be fine. if there is more records involved, then export takes lot of time and heap space is filled up. But xls export seems to be fine with limited 65 k records. Do we…
Tracking User Usage
Does anyone have a good way to track user usage? (i.e. a counter, or a view to show the time/date a user opened up a report)