-
BIRT: Combining results from two tables or cubes
Hello, My report scenario, I have two tables getting data from same database but can't use same sql statement and need to check if the first column in each table is the same, then put them in the third table with their accumulated costs. The below screenshot explains my scenario clearly. _
-
Java-heap issue while exporting a BIRT report in excel using v4.5
Hi Guys, I am facing issue while exporting a BIRT report in excel using v4.5. For a report with 40 columns and .5m records it consumes like 40gb of memory which eventually causes java heap error. Now i know BIRT used spudsoft emitter for generating excel and I read that…
-
TeamSite Standard Report Error
Hi, We are using TS 16.6.1 on Linux Environment with PostgreSQL. The TeamSite Standard report was working fine earlier and stopped working now. And getting below errors. We have restarted all services but still getting this error. Error.ReportQueryLoadingError ( 1 time(s) )
detail :…
-
Edit Parameter Window on server
Hello everyone, I'm using Birt Version: Neon Release (4.6.0). What options are there to change the content in the parameters window (the inscription Parameters marked with * are required) if I upload a report to the server? I cannot influence Birt Viewer.
-
Hyper link BIRT report is not loading in TRIRIGA 3.5.1
When I import the Hyperlink Report in TRIRIGA using the document manager, then the detail report is displaying the Blank page but the master is running fine. Note: The BIRT reports are built on SQL Queries. Can anyone have any idea about this issue that how to import the hyperlink birt reports in TRIRIGA?
-
chart visibility format dynamically change at client side?
Hi, I see Visibility allows to hide certain given format [pdf->rue] meaning, it hide for pdf and visible to all other format. that is fine; I want to change expression and format at client side depends on other user selection/action. I want to handle these visibility property at any of client side exposed methods example,…
-
WebReport Generated WordML document and Blazon Conversion to PDF
Hi. I've got a webreport generating wordml output to make a dynamic work document. I can open the file ok with word2007 (I know!) on the server, but cannot work out how to get Blazon to convert it to a pdf. It just outputs the xml content instead with the otf2dl loader, and the others I've tried won't even load the file.…
-
How to call REST API from BIRT report with JWT token
I have a requirement of calling REST endpoints from BIRT report. I
created a simple report which is consuming response and showing data
correctly. But I could not find solution for below use cases: * REST call to fetch JWT token using credentials. * REST call to any request with already fetched JWT token * REST call to for…
-
Adding Multiple Row in Cross Tab Report
Hey All, I want to design a report which has multiple row area in the cross tab report. I added it but now unable to add a column. The design of that report should look like this: Can anybody suggest to me if I can use a cross tab approach or if something else will work? Any help will be appreciated. Thanks.
-
Fetch number of days for each month based on Date Report Parameter in BIRT Report
Hi , I have a birt report which has report parameter on the date field i.e. Start Date and End Date hence user can run this report for 1/3/6 months or an year. Now what I have is based on this report parameter I need to fetch the number of days of each months. For example, Start date - 1 Jan 2020 End date - 31 March 2020 I…