Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Need help in generating reports using excel sheets as a source.

  1. #1

    Default Need help in generating reports using excel sheets as a source.

    Hello Experts,

    I am very new to this tool and would like to seek help from you.
    I have a requirement where i need to generate reports using excel sheets as source.

    Small brief on what i have done:
    I have used excel as input->table output as the output.

    I have created a connection 'Test' and connection type as 'H2' and acess as native JDBC.. and port 9092. user name: sa and password: blank

    Now I have created a transformation and the transformation was success. then i have created a model and the model is saved. Now i have opened report wizard from Data integration tool. A simple and small report is created. Now i wanted it to be saved as excel where i fail

    Also, i need to compare one month data with the other month. I need help in load the excel data into database first and then pulling it into report designer and creating the reports.

    I am struggling with the connections and the data access.

    Please help..

    Thanking you in advance.

    Regards,
    Shyam

  2. #2

    Default

    Any help here please....

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    You can generate the report inside Pentaho report designer (XLS output) or with the Pentaho Reporting Output step.

    http://wiki.pentaho.com/display/EAI/Pentaho+Reporting+Output

  4. #4

    Default

    Can someone help me with the connection details, steps in connecting the report designer,

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.