Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: two result set on one report

  1. #1
    Join Date
    Mar 2008
    Posts
    2

    Question two result set on one report

    I am writting a report where i read data from two different data sources. i.e One data is from SQL Server and the other data is from Mysql. I have been trying to combine the result set of the two data sources so as to display them on a single report in a tabular format without using subreport.

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    If you dont want subreports, then you would have to start to use Kettle to combine the data. The reporting engine does not do any complex data processing - we query existing sources and that's it. Anything beyond that is data-preparation and thats part of Kettle's job.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.