-
Wrong date format on DataSet.
<p>Hi,</p> <p> </p> <p>I'm new in BIRT reports and I am not able to fix date format. (I have version 2.6.0. )</p> <p> </p> <p>I get data from an excel with date format 'mm/dd/yyyy' but the format displayed on BIRT (on the previous results of the DataSet edit options) is 'yyyy/MM/dd'.</p> <p> </p> <p>The problem came with…
-
Determine the value of a parameter based on another parameter
<p>Hello,</p> <p> </p> <p>I have a problem with determining the value of a parameter based on another parameter.</p> <p> </p> <p>The case is as follows:</p> <p> </p> <p>A parameter, let's say param1 is given in the URL (WebViewer). With that parameter I can fetch data from a REST API which is then stored in another…
-
How to Merge columns in Birt
<p>Hi everyone,</p> <p> </p> <p>I have to create a report that has needs different columns that need different datasets. So every columns consists a count sql statement and a date. With a scripted data set I create a date column and try to join the the other datasets with a lot of joint datasets together.</p> <p> </p>…
-
BIRT runtime simple example giving exception
<p style="font-size:15px;color:rgb(36,39,41);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;">I am attempting to create a report using BIRT runtime (4.5) and below is the code I used for creating a simple demo.</p> <pre class="_prettyXprint"> public static void main(String[] args) { try { buildReport(); } catch…
-
conditional SQL query in report DataSet
<p>Hi,</p> <p> </p> <p>I want to add a condition based on the value of the report parameter. Like if the parameter value is null, don't include the condition, otherwise, add the condition. Please refer the attached image where I want to add the condition. In the screenshot, <span…
-
Parameters in DataSet throwing error
<p>Hi,</p> <p> </p> <p>I added two parameters in the Parameters tab in the edit window of DataSet. It throwing the following error. I don't have any clue why is this happening. I am a newbie to BIRT reports. Please help me.</p> <pre class="_prettyXprint _lang-nocode"> org.eclipse.birt.report.engine.api.EngineException: An…
-
Multiple DataSources with BIRT Runtime
<div>Hi!</div> <div> </div> <div>We have a BIRT Runtime (4.4.0) embedded in a web application that manages datasources in runtime with two options:</div> <div> </div> * Reports with JDBC Datasource * Reports with XML Datasource <div> </div> <div><strong>Now we need to work with more than one data source, for example with…
