Not entirely sure whether this has a name but basically I have a large HTML page that is generated from results in a db. So viewing the HTML page (which is a report) in a browser directly does not display all contents immediately but displays what it has and additional HTML is added as the results from the DB are retrieved... Is there...
Has anyone tried using BIRT for reporting on a Rails app.. I am working on a pretty big app on ROR. I was trying to get BIRT to work happily with the app. Since the BIRT Report Designer cannot be used with Rails, I decided to use BIRT Viewer alone and give the links to the reports on the page and have BIRT Viewer running on Tomcat on the...
Select count(Marks), ID from Student where From >= ? and to < ? group by ID. I have this query in one of the data sets in BIRT. Now when i run the report and check "show full processlist", i am getting result as "Select count(Marks), ID from Student where From >= '' and to < '' group by ID" but after running multiple times it substi...
Hi, Is it possible to generate word documents (*.doc) in java web application using Eclipse BIRT (Report Engine)? I want .rptdesign to be an input file in generating process. I could not find any example or tutorial. What would you recommend as an alternative solution. As far as I know Jasper Reports allow only RTF format generation. ...
Cheers, we are having the following problem while generating PDF reports with the Birt framework - when the content is a table that has many rows in it then the rows get stacked together. We'd like to split the content into more pages. When we set the PDFRenderOption's PAGE_OVERFLOW to OUTPUT_TO_MULTIPLE_PAGES we can only see that the ...
For this example data: Index, State, Food 1, CA, Hamburger 2, NY, Lettuce 3, CA, Cheese 4, NY, Lettuce 5, NY, Cheese 6, AR, Cheese I would like to group by State and show the most common food for each state. So the result for the example should be: State, Popular Food CA, Hamburger NY, Lettuce AR, Cheese The problem is I can't find...
Hi, I have made a static html page (called start.jsp) containing a form where the user select 2 date ranges and this form has date pickers for those text boxes. When the user submits the form, it should take them to the BIRT report that I have designed. It SHOULD pass the 2 parameters that my report needs (start date and end date). Her...
Hi there, Thanks for reading my question. Please I need your help here. I am trying to add a column that is based on a cross-tab's grand total. The cross-tab was added by clicking on the totals option for the column. Now I want to use this total for another calculation in my cross-tab but its so difficult adding a column after the gran...
Hello everyone, I have a table, grouped by an element, like this : [GroupingELT] Header1 | Header2 [ELT1] | [ELT2] And i'd like to have the [GroupingELT] alone in the center of a page, the table on the next page and so on. Could you help me with that ? I'm new to birt (started today :p) so don't hesitate to redirect me to...
Hi, I integrate the BIRT plugin in my application. in the development environment (windows) it works fine. but my deployment is on a Linux server. i getting the application startup error about the engine initialization - i trying to configure the path in a config properties file but it is still not working - do you have the experience i...
I have an upcoming project in which reports will play a large role. The reports will be predefined in nature, but may return significant amounts of data. For the database portion of the project we've settled on PostgreSQL, but we're still debating about what stack of software to use for the frontend. The reports are a significant en...
I have a BIRT report which connects to our test database. In the productive environment I would like to supply a datasource which is provided by the container through jndi. How would I set the datasource programmatically for the given report? ... IReportRunnable design = birtEngine.openReportDesign ( new File ( properties.getPr...
Hi, I am getting following exception while running BIRT from a Linux OS. Caused by: org.eclipse.datatools.connectivity.oda.OdaException: no protocol: /home/lsingh/reporting/tmp/execution1279514184559/TDReport.xml where "/home/lsingh/reporting/tmp/execution1279514184559/TDReport.xml" is my XML data file. When i looked into the code of...
I am trying to call BIRT API in linux environment. My source is an XML file and i create html, xml and pdf reports on that source XML. My html and xml reports generates properly, but PDF report is created with size '0' (no contents). However if i run the same program from a windows system, PDF report is created properly. Is BIRT havi...
I have this Birt report that I inherited from another developer, consisting of a child table inside a master table. For each row in the master table, the child table lists items belonging to the current master row item. The two tables are fed from different data sets, the child table dataset taking a parameter indicating the master item...
I have a DataSet with a query like this: select s.name, w.week_ending, w.sales from store s, weekly_sales_summary w where s.id=w.store_id and s.id = ? I would like to modify the query to allow me to specify a list of store IDs, like: select s.name, w.week_ending, w.sales from store s, weekly_sales_summary w where s.id=w.store_id...
Hi, I am trying to create a table with two groups in a BIRT report. I first group by year, and then by a criteria in a second column. Let's say this criteria is one of [A, B, C, D]. If there doesn't exist a criteria for a year, the default in BIRT is for it to be blank. For example, if 2011 didn't have any B or D criteria, my report ...
Is there a Maven repository for BIRT 2.6.0 that I could point to? ...
I cannot create any datasource including the "Classic Models Inc. Sample Database". I do not get any error on the UI but the data source does not get created / does not show up in the Data Explorer. Has anyone else encountered this issue? How can I fix this? TIA ...
see the table here: http://www-01.ibm.com/support/docview.wss?uid=swg21376096 what i'm trying to do in birt designer is merge those two rows, and combine the Product column cells, since everything else is the same. end result would be a product cell of "IBM Tivoli Asset Management for IT, IBM Maximo Asset Management Essentials" Would t...