Software
Building SQL reports with Eclipse BIRT
Is there desktop software (preferably open source) that can easily generate reports from SQL databases connected to our network? We want to pull report data from the database into a format that we can edit by hand. Is there something you recommend?
I've recently become a fan of the Eclipse Business Intelligence Reporting Tools (BIRT), which does almost exactly what you're asking.
With BIRT you define a SQL query that pulls your data, then you use a drag-and-drop report creation interface to lay out the data fields for your report. The report is generated in HTML, which you can save to disk, print or export as a PDF.
To get started, download Eclipse and unzip the package into a fresh directory. Then go to the BIRT downloads page and download the BIRT package.
You also need two packages (EMF and GEF) that are linked to the BIRT download page requirements section.
Unzip all three into the Eclipse directory and start Eclipse. Follow the instructions in the tutorial. The ease of report generation once the tools are in place is worth the trouble of downloading the four component packages. If you try it, you will be pleased.
| Use this form to start a public discussion with other Linux World users on this article. Log In | Register for an account (Why you should) |
Note: Register to have your user name appear; otherwise your comment will show up as "Anonymous."
*Anonymous comments will only appear once they are approved by the moderator.
• Dell puts Linux and Atom in Vostro PCs
• Mozilla names best Firefox 3 add-ons
• Torvalds: Fed up with the 'security circus'
• Dell Latitude ON - big win for Linux
• Open source advocates hail appeals court ruling
LinuxWorld Conference and Expo San Francisco, August 4-7, 2008.
Linux Plumbers Conference Portland, OR, Sept. 16-19, 2008.
FreedomHEC Santa Monica, November 8-9, 2008.
Featured Whitepapers
| The Trend from UNIX to Linux in SAP(r) Data Centers |