devshare

Placing JDBC drivers for BIRT and e.Spreadsheet Reports
In order to utilize JDBC drivers to access data for your BIRT reports with the Web Viewer or through the Deployment Kit or iServer Express, the Jar files need to be placed in the proper directory. The following describes the location to place JDBC jar files according to the…
Create and use of JS functions
Define any js function in the initialize like:function myFunction(str){dosomething;}reportContext.setPersistentGlobalVariable("myFunction",myFunction);To use this function in script or in expressions just call:myFunction("str");
Combine reports
This examples shows how to combine HTML as well as PDF reports.
Create report dynamically
This example shows how to create a report using the api's. The data set will be created dynamically according to the data input. A table will be also crated dynamically and filled with the created data set elements.
BIRT - Writing an XML emitter
This blog entry by John Ward shows how to create a custom emitter for BIRT. For this example, he creates a custom XML emitter using JaxB and provides instructions for creating, configuring, and deploying the emitter…
Client-side Scripting in BIRT Reports
Often it is necessary to invoke another web based application from a BIRT report based on the data that is available in a table. This report demonstrates the use of the BIRT report text item in order to accomplish this goal. It includes some Javascript code in the table header. In the detail row of the table, HTML forms is…
Web 2.0 and BIRT
Building web 2.0 style functionality into your BIRT report may be easier than you think. Web 2.0 requires client side javascript code, and interaction with the actual report elements after the report is generated. BIRT provides a very easy to use…
Standalone Chart Engine and Builder Examples
The Chart Builder and Chart Engine can be used outside reports to create and render and charts. There are three applications in the attached examples: - Render a Chart in a web application. It also demonstrates the usage of style you can apply to the chart, and gives you an idea how to easily integrates charts…
Simple Design Engine API Example
This is a simple example showing how to create a report design from scratch entirely from the API. This example was created for BIRT 2.1.1 <div class=\"xoopsCode\" style=\"border: 1px…
Creating a Waterfall chart in BIRT
Waterfall charts are a special type of floating column charts. A typical waterfall chart shows how an initial value is increased and decreased by a series of intermediate values, leading to a final value. This example shows: - how you can prepare the data to be displayed in a bar chart that will…
First Experiences with BIRT
A JDJ article by Chris Beels, an IT professional in the Financial Services industry, describing creation of a sales report and why his organization selected BIRT. The BIRT version discussed is 2.0.http://java.sys-con.com/read/204706.htm
Box Whisker Chart in BIRT
The attached sample shows how to combine a candle-stick stock chart series and a line series to create a box whisker chart. http://en.wikipedia.org/wiki/Box_plot explains more about this type of chart. You will need to create an ODBC data source called BoxWhisker that points to the Microsoft Access db to run…
Using ODA Plug-in Wizard to create a simple ODA Driver
This tutorial ( UsingODAWizard.doc) shows how to use the new ODA Runtime and Designtime plugin wizards introduced in Europa release to delvelop a simple ODA driver. Source code attached.
Filter BIRT JDBC Query
There is a ServerUserName variable in the AppContext that gets passed to the engine tasks/report scripts. You can design a report with a parameterized JDBC query and the parameter can be bound to an expression that is a function of the ServerUserName in AppContext. Since this parameter only gets passed when it is ran on…
Solving Birt \
While using the BIRT Report Designer, you may experience crashes without warning. Something similiar to the following is seen in the log file: <blockquote style=\"margin-right: 0px;\" dir=\"ltr\"> !ENTRY org.eclipse.ui 4 0 2006-11-02 11:57:42.951<br…
Cast String to Number in BIRT
There are a couple of options in BIRT when using CSV as a data source and you want to cast a String as a number in order to do further formating (currency, etc.): * Double-click on the data field and select Decimal from the "Data Type" dropdown. Then, you will be able to format via the "Format Number" property of…
Pareto Chart in BIRT
In this entry there are examples of Pareto Charts in BIRT. For more information of what a pareto chart is you can look here http://www.isixsigma.com/library/content/c010527a.asp or here http://en.wikipedia.org/wiki/Pareto_chart. I have seen two types of pareto charts. One where there is a second…
Dynamic Content Creation in BIRT
Attached is an example of a BIRT report that dynamically created its content based on parameters. There are two parameters on the report. Each is a comma delimited list. One is a list of column headings the other is a list of the data fields. Obviously the both have to be of the same length. The example uses…
BIRT Chart as Sub Report
The Report example demonstrates the ability to link a stock chart as a child of a parent table. The parent table groups stock price information by month. For each month a chart is then displayed graphically depicting the performance of the stock price. This example was built with BIRT 1.0.1 …
BIRT Charting Example
Charting is an integral part of data summarization and analysis. BIRT provides an excellent package for charting, allowing diverse chart types such as bar charts, pie charts, line charts, scatter charts, and stock charts. Each chart type is also very customizable, offering a wide range of features to better represent data.…
BIRT Report Grouping
This example demonstrates building a grouped report in BIRT. The example report shows a list of customers and groups these by country. Key BIRT features that are covered in this demonstration are grouping, page breaks, table of contents, and aggregating data per group or as a total.
BIRT Highlighting and Conditional Formatting
This example demonstrates how to add highlighting and conditional formatting to a BIRT report. A Products list report is developed that displays all company products. The example report uses alternating row colors and highlights rows that represent a product that is low in quantity. This report also illustrates adding a…
BIRT Parallel Reports
This example demonstrates how to build a report with parallel sections. It also illustrates using table filters to cull the data displayed. The report uses a grid element to layout two columns. In each column a set of nested tables are added to retrieve employee information and group by position hierarchy. The tables are…
BIRT Sub Reports
This example demonstrates building a report that uses nested tables. The query that is bound to the inner table is parameterized to return order details for a given order number in the outer table. This example also illustrates referencing outer table columns within a nested table. This allows BIRT reports to be designed…
BIRT Drill to Details example
This example demonstrates a master-detail report. The master report list orders and allows the report user to click on a particular order number to drill into a detail report for the selected order. This style of detail reporting increases performance instead of displaying on data that the user may not need. This example…
Periodically Reload BIRT Report
This blog entry by Jason Weathersby shows a report that makes use of the script tag within a Text element. The report executes every 10 seconds and alters what is rendered based on some check boxes within the…
Interview at Java One on BIRT
Link to SYS-CON TV interview about BIRT at 2005 Java One between Bill Dudney and Mark Coggins. Provides an overview of what BIRT is with a focus on how the BIRT designer is different than the typical "banded" report writer.http://www.sys-con.tv/read/109190.htm
BIRT Sales by Product Report
Using the "Classic Models Inc." sample database, this example report illustrates building a static crosstab report using the BIRT Total function. The report presents annual sales revenue by quarter for each of the product lines that Classic Models Inc currently sells. Totals are aggregated across horizontal and vertical…
BIRT Top Customers Report
A report against the "Classic Models Inc." sample database making use of the top n and top percent filter capabilities, the report shows a bar chart with the top N customers by revenue, followed by a listing of the top M% customers by revenue sorted by customer name. This requires multiple passes over the data, but it is…
BIRT Top Selling Products Report
Using the "Classic Models Inc." sample database, displays a pie chart showing revenue by product line. Lists the top selling products, sorted by revenue. Demonstrates use of a chart and sorting a result set. Also shows image inclusion and use of grid and tables to organize report content. Finally, the report makes use of…

Debug Trace

notice

The addon with key VanillaStats could not be found and will not be started.

#0 [internal function]: Vanilla\Logging\ErrorLogger::handleError(1024, 'The addon with ...', '/var/www/fronte...', 1123)
#1 /var/www/frontend-2b8cad6fccd39e/library/Vanilla/AddonManager.php(1123): trigger_error('The addon with ...', 1024)
#2 /var/www/frontend-2b8cad6fccd39e/bootstrap.php(546): Vanilla\AddonManager->startAddonsByKey(Array, 'addon')
#3 [internal function]: {closure}(Object(Vanilla\Utility\TracedContainer), Object(Vanilla\AddonManager), Object(Gdn_Request))
#4 /var/www/frontend-2b8cad6fccd39e/vendor/vanilla/garden-container/src/Container.php(353): call_user_func_array(Object(Closure), Array)
#5 /var/www/frontend-2b8cad6fccd39e/bootstrap.php(602): Garden\Container\Container->call(Object(Closure))
#6 /var/www/frontend-2b8cad6fccd39e/index.php(28): require_once('/var/www/fronte...')
#7 {main}

info

Could not find file 'custom_default.css' in folder ''.

devshare

Discussion List