Discussions
-
Hanging Indent
The trick is to use an indent of -x with a padding of +x. Take a look at the style HangingIndent.
-
Dynamic Content from Library
Thanks goes to Jason Weathersby for the assist. The attached example executes a query in code (beforeFactory) and then based on the data returned adds specific grids from a library to the design. This is very useful for use cases when the content of a report is based on user preferences.<br /> <br /> The design uses…
-
Opening old report in 4.3
<p>I have a report I created using BIRT 4.0, and it isn't working in 4.3. It will open the report, but when previewing, it throws an error saying the established connection to the data source is not active. This report was working just fine in 4.0, is it not compatible with 4.3? Will I need to re-write the whole report in…
-
Problems customizing inbox.
Hi, I'm trying to extend our inbox to add a custom attribute, and I'm running into some issues. The first thing I'm doing is under my virtual root\custom\config, is create the component file, inboxclassic_extends.xml: <?xml version="1.0" encoding="UTF-8"?> <config version="1.0"> <scope> <component id="DEQinboxclassic"…
-
Dynamic Columns in a Report
Thanks go to Jason Weathersby and Kalesh Mahendrakar for the assist. The attached example dynamically adds columns to a report based on parameters. It could also come from a database for example user preferences. The interesting things (at least for me) were:<br />* I could change the database query on the fly and BIRT…
-
Simplified Printable Table of Contents
This new version was designed by Puck Puck. This is an updated version of the example here:<br /> <br /> http://developer.actuate.com/community/devshare/_/designing-birt-reports/1080-another-report-with-printable-table-of-contents-toc<br /> <br /> This one is much simplified and uses Report variables instead of script…
-
Treemap HTML5 Example
The report uses the Google Treemap visualization found here:<br /> https://developers.google.com/chart/interactive/docs/gallery/treemap<br /> <br /> The attached report was desiged in Actuate 11 SP3 but should work in any version of BIRT that supports report variables.<br /> <br /> The example uses a CSV file (also…
-
Simple Technique for Custom Sort
Let's say I want to sort in this order - High, Medium, Low. This is obviously not alphabeticaly. What I did in this example is create a column with values 1, 2, 3. Then used the Map tab to create a mapping where 1=High, 2- Medium, 3-Low. When one sorts on the coilumn (whether in BRD or Interactive Viewer) the column will…
-
Deploying BIRT to Liferay Portal
I have written this post in my blog, about creating Liferay portlets that use BIRT reports.<br /> <br /> http://mdelapenya.wordpress.com/2011/05/23/integrando-liferay-con-birt/ (in spanish)<br /> <br /> Thanks to@sujhaav for his comment!!
-
Hiding specific columns in report based upon the input
Hello,<br /> Just a few days back, I was stuck with a need to hide column(s) in a table when there were no data for that column.<br /> A very straignt forward and obvious approach would be have a check in the java code that is trigerring the report and pass a parameter to BIRT indicating that there are no values for that…
-
Ways to specify Dynamic Query
Hi All,<br /> <br /> I googled about dynamic query in BIRT a few days back, but I got little idea on how to do so though this article was informative click here.<br /> <br /> So I thought of sharing few things that I learnt by just playing around. I encountered two ways of doing it, though there may be many, these two are…
-
New Report Item for Report Parameter
This devshare submission qualifies for Plug In 2 BIRT Contest<br /> <br /> As an Architect for a BIRT based RCP app that is used by the end customers, I find it interesting to cut down on the need for custom javascript code, and it seems like this is one of the few issues I keep hitting, being able to show multi select…
-
CSV Emitter Plugin for BIRT
This devshare submission qualifies for Get Started with BIRT Contest<br /> <br /> The CSV Report Emitter is a custom made Eclipse plugin for BIRT which enables you to output your BIRT report in CSV format.<br /> The usage of CSV Emitter as an Report Output Option is easy and in line with current Output Options Usage.<br />…
-
Limiting an Embedded Crosstab to a Value from the Outer Table
When you filter a crosstab to limit it to the data for the group of the outer table only in newer versions, your filter would compare the crosstab dimension or attribute to the outer table value with a condition like:data["dimensionName"] Equal to row._outer["rowName"] <br /> I was working on this same issue for someone in…
-
Manual Page Breaks For Multi-Line Rows
BIRT 2.6.2 has improved page breaking in that the pageBreak events are called when you reach the end of a page, not when the pageBreakInterval is met. Prior to 2.6.2, row counts were not reset and pageNumbers were not incremented for use in TOC's and such. You would end up with incorrect page numbers if you had multi line…
-
EclipseCon 2011 "Hands on Tips from the BIRT Forums" Examples
Examples from my session, Hands on Tips from the BIRT Forums, at EclipseCon 2011.<br /> <br /> Examples include:<br /> <br /> * Displaying a "No Data Returned" label when the query returns no data.<br /> * Multi-Select parameter / Editing the query in script<br /> * Nested table using dataSet parameter binding<br /> *…
-
Extending a Table to a Certain Number of Rows with Alternating Row Color
This example shows how to extend a table group to be a certain number of rows with alternating row color even if there is not enough data on the page to force the table towards the bottom. This is done by adding extra group footer rows and keeping track of how many rows are on a page and using that value to determine how…
-
Changing Integer to String Number
This example report shows the use of a simple function created by BE user: santoshsingh1056. The forum with the function to use to do this is located at the following link:<br /> <br /> http://www.birt-exchange.org/org/forum/index.php/topic/22298-convert-number-into-word/<br /> <br /> A sample report showing the use of…
-
Adding "Continued..." to Title Label on Masterpage After First Page
The attached report shows two different ways to add "continued..." to a title label in your masterpage after the first page. The first way, the one that is in the header of the masterpage, should work for all versions of BIRT. A dynamic textbox is put in the masterpage header with "Orders Report" as the text. In the…
-
Group Page Numbering
This example shows a way to have group page numbering within a grouped table. The example uses persistent global variables in the onCreate script of the detail and group footer rows to keep track of group page numbers. Then, in the onRender of a text box in the masterpage footer, the page numbers for the different groups…
-
Resize Bar Chart Based on the Number of Bars
This example shows how you can use chart scripting to check the number of bars that will be in the chart and then resize the chart accordingly. A minimum chart size is set so that if there are very few bars, the chart won't cut off needed information. A maximum size is also set so that the chart will always fit onto your…
-
Show/Hide Chart with Radio Button
This example report uses client side script to take a radio button input to determine which chart to show. The example has a bar chart and a line chart that represent the same data, but allows the user to select which view they'd like with a radio button. This works in HTML outputs only.<br /> <br /> This report was…
-
Explode Largest Pie Slice in Pie Chart
This example shows how to explode the largest slice in a pie chart. Script in the AfterDataSetFilled function in the chart's onRender script is used to find the largest value in the chart and then store this value in a global variable. Then, in the chart editor, you recall this variable to define the slice that is to be…