Best way to generate report using multiple databases

Posted by Vinaaven on Stack Overflow See other posts from Stack Overflow or by Vinaaven
Published on 2010-03-24T02:06:41Z Indexed on 2010/03/24 2:13 UTC
Read the original article Hit count: 475

Filed under:

reporting

|

jasper-reports

|

birt

|

multiple-databases

Hi All,

I am new to the reporting world. Wanted to know which is the right solution to about for generating a single report by querying for data from multiple databases. We are planning to use some reporting solution like Jasper Reports or BIRT. Generally the databases are going to be postgresql.

Please do feel free to let me know about any other better solutions as well.

Thanks.

© Stack Overflow or respective owner

Related posts about reporting

SQL Azure Reporting Limited CTP Arrived

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
It’s about 3 months later when I registered the SQL Azure Reporting CTP on the Microsoft Connect after TechED 2010 China. Today when I checked my mailbox I found that the SQL Azure team had just accepted my request and sent the activation code over to me. So let’s have a look on the new SQL Azure… >>> More
Telerik Reporting introduces WPF Report Viewer, the first reporting tool supporting all .NET desktop

as seen on Dot net Slackers - Search for 'Dot net Slackers'
With the release of Telerik Reporting Q1 2010 Service Pack 1 we are proud to announce a very important addition to Telerik Reporting. Finally, our suite of report viewers is now complete, making Telerik Reporting the first reporting tool to support all .NET desktop and web platforms: ASP.NET,… >>> More
JD Edwards World Reporting Made Easy with Real Time Reporting Tools from The GL Company

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Fred talks to Paul Yarwood, US Operations General Manager and Richard Crotty, North America Business Development Manager for The GL Company, an Oracle Certified Partner, and Denise Grills, Senior Director of Marketing and Product Strategy for Oracle's JD Edwards World products. They discuss how the… >>> More
Complex reporting on subversion (possibly Export Subversion log into database for reporting)

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the best way to do complex reporting on subversion logs like the following for each file? file, directory, last revision date, previous revision date(where revision date is at least 30 older than last), days diff(between revision dates) Since Subversion allows on revision to change multiple… >>> More
An Introduction to XBRL (eXtensible Business Reporting Language)

as seen on Internet.com - Search for 'Internet.com'
XBRL (short for eXtensible Business Reporting Language) is an XML-based standard for handling corporate financial information. This article explains what XBRL is, provides an introduction to some of it's uses, and provides links to a number of XBRL related resources for you to continue learning about… >>> More

Related posts about jasper-reports

How to solve this nullPointer Exception in jasper report?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am new to jasper report, I need to create pdf document with BeanDatasource and subreport. I refer the following blog " http://knol.google.com/k/jasper-reports-working-with-beans-and-sub-report# " . I followed all the steps perfectly. While i am running the report using IReport i can get the… >>> More
Applet Loading Error - Jasper Report

as seen on Stack Overflow - Search for 'Stack Overflow'
I encountered very silly error , but any way i can not figure out solution.i am loading java applet which encompass a simple jasper viewer in it. when the applet is loaded it throws following exception. SEVERE: Servlet.service() for servlet JasperReportServlet threw exception java.lang.ClassNotFoundException:… >>> More
How to resolve: 'cmd' is not recognized as an internal or external command?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched other forums to solve this error where it would either end with: 1.) re-install OS 2.) Setting path variable C:/Windows/System32 The latter did not work, and as you can probably imagine, I do not want to have to re-install my OS... I am running the command "mvn jetty:run" and the… >>> More
Error loading the report template:org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid con

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, i'm newer in jasper reports.i've some problem when i call iReport from jsp....some error occurs at run time as like below :- Error loading the report template: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'head'. One of '{"http://jasperreports… >>> More
BIRT vs Jasper Reports

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I goggled for 2 hours to find what shall I use. I found that both are good and have good community. BIRT is supported by IBM, IBM integrated Tivoli reports with it. This proves it is good and will keep growing. Jasper Reports has fairly bid community and (probably) a better report designed… >>> More