Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Only one query per report?

  1. #1
    Join Date
    May 2010
    Posts
    5

    Default Only one query per report?

    Hello,

    I have a really strange problem with the report designer. I have written 5 queries in the data tab and I have dragged each column (each query only brings back one column) into the report.

    The thing is I can only retrieve data for one query at a time. By right clicking on the query and selecting "select query". When I select the next query the previous query no longer returns rows when I preview the report.

    Is this just the report designer? so it would be fine when published?

    Thanks in advance

    David

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi David,

    the report supports only one resultl set at a time. That's how the reporting engine works, not a Report Designer problem.

    If you want to use more then one reuslt set you need to work with subreports, which support again a single query and can pick up queries defined in the main report.

    Another alternative is to combine the data either in a single statement or to do some data processing beforehand.

    Regards,
    Ingo

  3. #3
    Join Date
    May 2010
    Posts
    5

    Default

    Great, using the sub reports is allowing me to use multiple queries. thanks for your help ingo

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.