Discussions
-
Access to the ResultSet by java
<div>I use eclipse 4.4.1, windows 8.1, java 7, birt 4.4.1 and the demo-database of birt.</div> <div> </div> <div>I have created a report with the Report-Designer with his own DataSource "Classic Models" and his own DataSet "Invoice Data". When i use this report, all went well.</div> <div>I change the SQL-Statement of the…
-
Use Data from one DataSet in another DataSet
<p>Hello,</p> <p> </p> <p>I have the following question:</p> <p> </p> <p>I use a JDBC Connection and SQL Source as DataSet. The SQL Statement is very long and it lasts also very long for executing. My query is like that (it's simplified, but logical the same):</p> <pre class="_prettyXprint _lang-"> SELECT a.name, a.city,…
-
International paper sizes
<p>Hi,</p> <p> </p> <p>Is it possible to implement a script in BIRT that would determine the local default paper size for each end user running a PDF report? If this is not possible then what option is best used as a "standard" when implementing a report within an international company?</p> <p> </p> <p>Thanks for you…
-
How to list only scheduled jobs.
Is there any way to get the list of schedule jobs from all users without using clt. Is there a way to get it using cssdk??
-
Pagination In TPL
Hi , Can anyone help me to do pagination in TPL. Example I have 150 data and I want to show 10 data per page. Thanks a lot for the help in advance.
-
config console in blank
When I acces to config console it doesn't show anything. Some ideas? Thank you.
-
Designing a group left report (BIRT Designer)
<p>Hi,</p> <p> </p> <p>I am trying to develop a group left report as mentioned in the following link:</p> <p> </p> <p><a data-ipb='nomediaparse' href='https://drive.google.com/file/d/0B33yoKjP7eXhSDB0UzNTOVdSXzg/view?usp=sharing'>https://drive.google.com/file/d/0B33yoKjP7eXhSDB0UzNTOVdSXzg/view?usp=sharing</a></p> <p> </p>…
-
Start and End Date Difference Less than One Year
<p>Hello,</p> <p> </p> <p>I have a report that I am working on for a customer for Lease Management. They have a request for a field called "Lease Term Less Than 1 Year". This field should look at the Start Date and End Date of the lease, and if it is less than 1 year difference, return a YES, otherwise return a NO. I set…
-
report design file not displaying pdf on cloud server
<p>Hi I have a report which is working fine on my local machine. i am using eclipse birt and birt viewer app. when i deploy on the cloud machine (which we brought on internet) report pdf is not getting displayed instead it is showing the following error. what could be the problem?</p> <p> </p> <p>My localhost OS is…
-
Crosstab causes SQL query to execute multiple times
<p>Hello,</p> <p> </p> <p>I have seen some discussions of this, but none that resolve the issue.</p> <p> </p> <p>I have a simple dataset -- 8 columns</p> <p> </p> <p>I have a simple datacube -- 3 dimensions and 1 measure.</p> <p> </p> <p>I create a crosstab using these elements. It is in the report header. No groups or…
-
Combining data of two crosstabs
<p>Hi guys,<br><br> what seems extremely easy in Excel is not in Birt I guess. I have two datasets based on two different db tables. For both datasets I created each a crosstab that gives me accumulated results for each month. I want now create a third table or crosstab that shows me computed results from the two before…