-
How to compare current row value and next row value in a column using Magellan
Hi Team, I am working on a Magellan report which contains a column with the following logic: If( Next(col1)!=col1 ) { Result. } Here it was comparing the current row value in column(col1) with next row value in that same column. How to write this logic in Magellan using javascript. I got strucked on this task from 1 week.…
-
Magellan BI& Reporting CE 22.4 - iHub failed to generate the reports which contains 84K+ records
iHub report is unable to generate the results if the report contains more than 84K+ recorders And in the report it shows 700+ sheets but not updating.
-
Numeric data type is lost after exporting to Excel
We are developing an ERP application and for the Reporting component we are using open source BIRT report engine & open source BIRT designer tool; however we are facing a miss functionality after exporting an excel formatted file that includes numeric data type. The problem arise after exporting an excel sheet as the…
-
Magellan Bi & Reporting - iHub 22.4 report's Export to excel gives wrong values to the Decimal field
Hi Team, I am using MDD & Magellan Bi & Reporting 22.4 and trying to export the report output into Excel. All decimal values shows wrongly in the excel file. if click on the specific value in the excel it shows the correct values in the formula. How handle this issue? Original report values Excel Values Value in the Excel…
-
Birt scripting in Dashboard
Is it possible to do scripting in Birt Dahboard, i can see Scripting option in Datasets, but for the dahbaord itself, i dont see any option where i can write by scripts, basically, iam using a report paramter in my Dahboard, and my laoding icon is not showing until the query gets executed, it just appers and disappers, i…
-
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
-
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…
-
Does any Magellan components offer to upload .parquet files from HDFS?
I see there are data sources like Hive/sparks to load data, but I cant see any way we can upload hdfs .parquet files directly? I see Flat Files offer url to browse but only csv,.xls,.data but not .parquet?
-
How I can get connection properties on OdaDataSourceHandle
How I can get properties from org.eclipse.birt.report.model.api.OdaDataSourceHandle? if I use REST Data source with predefined connection profile, i want to read properties of connections in report, either in beforeFactory or in datasource beforeOpen etc methods.
-
Localizing row data for PDF TOC
I'm working on a report build where I've got a few tables that have multiple grouping levels. The groups are indicator text (think regulatory report sections) that needs to be localized, so I created all the mappings in a resource properties file for the detail rows which works as expected. However, whenever I try to set…