Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Creating a report with multiple sheets in excel

  1. #1
    Join Date
    Nov 2017

    Default Creating a report with multiple sheets in excel

    Hi, Can we create an excel report with multiple sheets in that report using either PDI or PRD. and for each excel sheet I have to do pivoting for different columns of same data.
    Let say I have a query and I am generating dome data using that query and I am doing crosstab for pivoting the data.
    And in the second sheet Can i use the same query and pivot different columns.

  2. #2
    Join Date
    May 2014


    It could work as a subreport which inherits the query and then does a different grouping on it. If you can convince Report Designer to put in onto separate sheets.

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.