Discussions
-
HTML Table as a Tooltip in a Chart
This example shows how to create a html table in a div in a text box, then use client side script to display the table as a hovering tooltip for your chart. The script is called by the invoke script interactivity in the chart design. On mouseover, the script is called to show the table and onClick, script is called to hide…
-
Showing Current Group Value in MasterPage Without Page Variables
This example shows how you can use persistent global variables to store the current group value in the onCreate of your table row, and then display this value in a dynamic textbox, in the masterpage, using onRender script. This task was made easier with the introduction of Page Variables and the Variable auto-text for the…
-
Simple BIRT CSS Style Sheet Example
This example uses a parameter to allow the user to select between two styles or the use of no style. The CSS file is then assigned to the report in the beforeFactory method. The example shows how to add styles for a grouped table, a crosstab, and a chart. A chart only has limited styling available through CSS, though, so…
-
Adjust Spacing for Dynamic Y-Axis Label
This example shows how to change the inset value of your chart's y-axis labels so that the new dyanmic value can be seen in its entirety. The inset value in this example is static, but could be made dynamic if you determine how long your longest label will be based on how you're changing them. This report was designed in…
-
Always having 'ALL' option in a cascading parameter
This sample BIRT report shows a way to make sure that ALL always shows in your cascading parameter drop downs for all levels when using an SQL dataSet. Script is used in the beforeOpen of the second level parameter's dataSet to handle an "ALL" selection in the first parameter, and script is also used in the beforeOpen of…
-
User Specified Custom Sort Order
This example allows the user to enter a numeric value for each value of a certain field, so the table can be sorted to their preference. This allows them to sort in a non ascending/descending order. An array is populated in the dataSet script, which in turn populates a form of text boxes. This is all hidden except for a…
-
Group Always Starts on Odd Page
Sample report showing how to make sure each group starts on an odd page, for when you're printing on both sides of the page. This design was created in BIRT 2.3.2, but the idea should work in all versions. It will be easier in 3.7+, because you won't have to make sure you are forcing page breaks for "pageNumber" to be…
-
Creating a "Line of Best Fit" Line in a Scatter Chart
This example shows how a "line of best fit" can be computed from the values in the scatter series. In the afterDataSetFilled, in the chart script, the average (x,y) point in the first half of the chart and the average (x,y) point in the second half of the chart are figured. These two points are then used to find the slope…
-
Changing Flat File Query Based on User Entered Parameters
This example takes 3 parameters from the user to determine which 3 columns from the flat file to bring in. Rather than bringing in all of the flat file columns and hiding the ones you don't want to see. This example changes the queryText of the flat file dataSet to only bring in the requested columns (see the dataSet's…
-
Repeat Crosstab Header After N Rows
This example shows a way to show a crosstab's header after n rows. In the original dataSet, a computed column is created that numbers the groups. The field is added as an attribute to the row group, in the dataCube. The max value of this computed filed is used to create a scripted dataSet with the number of rows that the…
-
Creating a "Line of Best Fit" Line in a Scatter Chart When X-Axis Field is a Date
This example is essentially the same as this devShare post:<br /> <br /> http://www.birt-exchange.org/org/devshare/designing-birt-reports/1548-creating-a-line-of-best-fit-line-in-a-scatter-chart/<br /> <br /> Except, it figures the line of best fit, when there is a date field on the x-axis, rather than an integer.<br />…
-
xPression Log Question
I was wondering if there was a way to display XML data in the log. Having the key information from the input would be very helpful while troubleshooting. Thanks!
-
Adding an Extra Slice to a Pie Chart
This example shows a way that an extra slice can be added to a pie chart. In this example a dataSet contains values for task "type", "scheduled" tasks, and "completed" tasks. From this data, the outstanding values are computed for each row and a total is figured from these. The pie chart shows the task type as the category…
-
Shortening the length of labels dynamically
Our application allows users to select between 1 and 8 elements to report on (creating between 1 and 8 bars or lines in each report), and allows them to enter a name for each element between 1 and 255 characters long. This caused headaches for us in the charts as legends would overlap severely, take up too much space, or…
-
Advanced Formatting for Maximo Users and Non-Maximo Users Alike
Do you have Maximo users who, for the most part, only need to run queries over your Maximo data? Most large organisations do and if you have not yet identified them then now may be the time. Maximo 7.1 and above, of course, comes with BIRT 2.3.2 as the budled report writer software, however the open source community have…
-
Embed a BIRT report in a JSP to allow dynamic change of parameters at runtime all on a single screen
Even though this guide shows how to create a report over Maximo it is equally applicable to any application that you are reporting over. Part one of this guide is available in Devshare for part two we are going to look at how to embed your reports into a JSP and add parameter selections to the header of the page so as far…
-
MongoDB ODA for BIRT
This devshare submission qualifies for Getting Started with BIRT Contest<br /> <br /> The MongoDB ODA plugin for BIRT is an Eclipse based plugin which enables you to connect to a Mongo database and pull out data to display in your BIRT report. The interface is simple and an extensive user guide is also provided with the…
-
XMLA Oda for BIRT
This DevShare submission qualifies for the Autumn 2012 Plug In 2 BIRT Contest!<br /> <br /> XML for Analysis (abbreviated as XMLA) is an industry standard for data access in analytical systems.<br /> <br /> The XMLA ODA plugin for BIRT is an Eclipse based plugin which enables you to connect to an XMLA provider like Pentaho…
-
An ODA driver to aggregate or map multiple flat files
Hi All,<br /> <br /> This ODA fulfill all our requirements while gathering required data from multiple flat files. We can fire SQL queries on flat files and it gives huge flexibility. <br /> <br /> Kindly go through the attached help document.<br /> <br /> Let me know if you have any suggestions or queries.<br /> <br />…
-
Style applied based on external data like weather
This devshare submission qualifies for BIRT Style Contest<br /> Hi All,<br /> <br /> This report design accepts RSS feeds from Yahoo weather portal and based on that data,picks styles dynamically.User needs to select 'Your Location' report parameter and report uses that value to form the query.This report uses XML data…
-
Password protected excel reports
Hi All,<br /> <br /> If your spreadsheet contains confidential information, you want to secure it against unauthorized access.The best way to achieve this is,enabling password protection.<br /> <br /> You can allow a file to be read, but a user will need a password to be able to modify the file. This is good when you want…
-
Heat Map And Mekko Chart's Plugin
This DevShare submission qualifies for the Autumn 2012 Plug In 2 BIRT Contest!<br /> <br /> Hi All,<br /> <br /> This plugin helps us to generate Heat Map and Mekkko charts.<br /> <br /> Heat Map is used to analyize performance of different companies, periodic table, employee attendance, stock market investments etc.<br />…
-
CrossTab inside Table
In this Example there is a cross tab inside table and grouping is done on the basis of multi select parameter..there is a mapping betwen table and cross tab so that ..crosstab data will be displayed according to table group.
-
Gantt Chart Auto Axis Scale Example
An example report for the following topic:<br /> <br /> http://www.birt-exchange.org/org/forum/index.php/topic/18522-setting-gantt-chart-axis-scale/
-
Scatter Chart with secondary Y-Axis for trend line
Sample Output as shown here:<br /> <br />