Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Add sheets in excel output for 2 different queries

  1. #1

    Default Add sheets in excel output for 2 different queries

    Need suggestion regarding adding sheets in pentaho report designer excel output.
    I have 2 different queries and trying to show on same excel i.e on sheet1 and sheet2.

    PS:If page break is answer please suggest how to use it.
    Last edited by jacob; 11-14-2014 at 07:52 AM.

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

    Default

    Let query one be solved by your main report. Then add a *banded* subreport to your report footer and setup the report for query 2 there. On that subreport, add a manual pagebreak onto the report-header via the "pagebreak-before" style property. If you feel like it, give the sheet a name by setting the "sheetname" style property on this report header and the master-report's report-header.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Tags for this Thread

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.