advertisement
javaboutique
Search Tips
Articles  |   Tutorials  |   Reviews  |   Tools  |   by Category  |   by Date  |   by Name  |   Submit  |   Source  |   Forums  |  
javaboutique
Browse DevX


Partners & Affiliates











advertisement

Tutorials : Generate a PDF Report from a Database with BIRT :

Generating a Report

Now, you will generate a BIRT report from the data set you defined in the previous section. The BIRT report you added to the BIRT project is based on a Blank Report template, so you'll want to add report items to the report from the Palette view. Select the Palette view.

To add a title to the report, select a Grid Report item from the Palette.


Figure 8. Adding a Grid for Report Title

Next, you'll add a single row, and a single column grid. In the Insert Grid frame, specify number of columns as 1 and number of rows as 1, and click on OK. Select the Text Report item from the Palette to add these to the report.

To center the text, first go to the Edit Text Item frame and select HTML/Dynamic Text and Layout from the choice lists. Then click on <CENTER>. You'd click on <U> to underline the text, <B> to select bold text style, etc. Add text "BIRT PDF Report" to the text item.


Figure 9. Editing Text Item

Next, add the title text to the report.

Click on the Preview tab to preview the report design. The title will be displayed as in the report generated with the Report Designer.

Add another Grid from the Palette to the report for a JPEG. Select the number of columns as 1 and number of rows as 1. Add the Grid below the title Grid. Next, select the Image Report item from the Palette and add that to the Grid.


Figure 10. Adding Image Item to Report

In the Image Builder frame, select the Embedded Image radio button and click on Add Image.

Select a JPEG to add and click on Insert to add the image to the report. To add a table to the report, select the Table Report item from the Palette and add it to the report.


Figure 11. Adding Table Item to Report

To add data from the Data Set to the table, select the Data Explorer view and select the Data Set node. Select the first column in the Data Set.


Figure 12. Selecting Data Set Columns to add to Report

Add the CatalogId column to the first Detail row cell. A header for the column will be added and the value binding of the column is obtained from the CatalogId column in the Data Set.

To add the value binding for the columns and column headers to the table, add the Journal column from the Data Set to the second column, the Section column to the third column, the Edition column to he fourth column, the Title column to he fifth column, and the Author column to the sixth column.

Modify the header properties with the Properties Editor. Select the CatalogId header cell and select the General property in the Properties Editor. Select the Courier New font. This applies the font to the CatalogId header cell.

Similarly, set the font of the other header cells to Courier New. Set the header text style for the CatalogId header to Bold with the B button.

You'll need to set the text style for the other header cells to Bold. To modify the properties of a row cell, select the Detail row cell and select the Properties Editor. Properties specified for a Detail Row cell will be applied to all of the rows for the column.
Figure 13. Setting Row Properties

For example, select the row ["CatalogId"] Detail Row cell and select the Padding property, and add padding to row cells. Add padding this way to the other Detail Row cells.


Figure 14. Adding Padding

You can also add hyperlinks to text in a table. For example, to add a hyperlink to the Journal column, select the Journal Detail Row cell and select Hyperlink in the Properties Editor. Specify the journal URL http://dev2dev.bea.com/.

You can also add borders and margins to a report. To generate a report, select File—≫Preview as PDF. This displays the report you've generated with the BIRT Report Designer. Save a copy of the report with the Save a Copy button. The example PDF report generated is available here.

The report you generated should consist of a table and an image, but you can also add charts and lists.

Easy-to-Use, But Not Without Limitations

BIRT is an easy to use Eclipse-based reporting tool but is does have some limitations: BIRT does not support J2SE 5.0 and does not support Eclipse 3.1. Also, because of browser limiations, some of the BIRT 1.0 features are not supported.

Home / Articles / Generate a PDF Report from a Database with BIRT / 1 / 2 / 3 /

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.

 Avaya DevConnect Center
 Service Component Architecture/Service Data Objects Solution Center
 Intel Go Parallel Portal
 Internet.com eBook Library
 IBM Software Construction Toolbox
 Microsoft RIA Development Center
 Destination .NET
XML error: not well-formed (invalid token) at line 53
advertisement
Receive Articles via our XML/RSS feed
Receive Articles via our XML/RSS feed

JavaBytes
Internet Cyclone
This powerful, easy-to-use, internet optimizer is for Windows 95, 98, ME, NT, 2000 and XP. It's designed to automatically optimize your Windows settings, boosting your Internet connection up to 200%.

Red Hat Takes on HPC Market, Microsoft
Python's New Release Bridges the Gap
No Flash Seen on iPhone Horizon
Apple Yields to Complaints Over iPhone NDA
Microsoft Shows Some Ankle With Visual Studio
Gentoo Linux Cancels Distribution
It's Official: Windows 7 at PDC, WinHEC
Oracle Keeps Building on Spoils From BEA
Intel, Oracle Head For 'The Cloud'
Oracle Focuses on Grid, Developer Tools

eCryptfs: Single-File Encryption in Linux
CCXML in Action: A CCXML Auto Attendant
Ballmer: Current Woes Won't Halt Tech, Microsoft
Microsoft Uses VMworld to Hype Its Hypervisor
Microsoft Charges Ahead in Virtualization
Microsoft Shows Some Ankle With Visual Studio
Top 5 Reasons to Adopt SQL Server 2008
Make Application Development Easy With Software Plus Services
SharePoint Applied: 10 Things You Wish They Had Told You?Part 2
Introducing Zend_Search_Lucene

Advertising Info  |   Member Services  |   Contact Us  |   Help  |   Feedback  |   Site Map  |   Network Map  |   About



JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Solutions
Whitepapers and eBooks
IBM Whitepaper: Innovative Collaboration to Advance Your Business
Internet.com eBook: Real Life Rails
Avaya Article: Call Control XML - Powerful, Standards-Based Call Control
Internet.com eBook: The Pros and Cons of Outsourcing
Go Parallel Article: Scalable Parallelism with Intel(R) Threading Building Blocks
Internet.com eBook: Best Practices for Developing a Web Site
IBM CXO Whitepaper: The 2008 Global CEO Study "The Enterprise of the Future"
Avaya Article: Call Control XML in Action - A CCXML Auto Attendant
Go Parallel Article: James Reinders on the Intel Parallel Studio Beta Program
IBM CXO Whitepaper: Unlocking the DNA of the Adaptable Workforce--The Global Human Capital Study 2008
Adobe Acrobat Connect Pro: Web Conferencing and eLearning Whitepapers
Go Parallel Article: Getting Started with TBB on Windows
HP eBook: Storage Networking , Part 1
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
Go Parallel Video: Intel(R) Threading Building Blocks: A New Method for Threading in C++
HP Video: Is Your Data Center Ready for a Real World Disaster?
Microsoft Partner Portal Video: Microsoft Gold Certified Partners Build Successful Practices
HP On Demand Webcast: Virtualization in Action
Go Parallel Video: Performance and Threading Tools for Game Developers
Rackspace Hosting Center: Customer Videos
Intel vPro Developer Virtual Bootcamp
HP Disaster-Proof Solutions eSeminar
HP On Demand Webcast: Discover the Benefits of Virtualization
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
Microsoft Download: Silverlight 2 Software Development Kit Beta 2
30-Day Trial: SPAMfighter Exchange Module
Red Gate Download: SQL Toolbelt
Iron Speed Designer Application Generator
Microsoft Download: Silverlight 2 Beta 2 Runtime
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
IBM IT Innovation Article: Green Servers Provide a Competitive Advantage
Microsoft Article: Expression Web 2 for PHP Developers--Simplify Your PHP Applications
Featured Algorithm: Intel Threading Building Blocks - parallel_reduce
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES