Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to generate a report from an Excel file

  1. #1
    Join Date
    Jun 2008
    Posts
    27

    Question How to generate a report from an Excel file

    Hi,

    I've got an Excel table like this:
    Customer | CustomerID | DeliveryDate | TypeOfOrder | TotalCost
    a | 1 | 1.1.09 | 10 | 300
    b | 2 | 3.1.09 | 10 | 200
    a | 1 | 5.2.09 | 20 | 150
    and so on.

    Now I want to have a report like:
    How much did customer a, b, c ... order in january, feb, mar, ... with the type 10 order.

    This is this only thing my customer wants to know and delivered already a xls from his database. I could do it in Excel, but I think a nice reporting tool would be more appropriate?
    More over I guess Pentaho Suite is oversized - what else can I do?

    Thank you in advance.
    Bye, Transmitter

  2. #2
    Join Date
    Jun 2008
    Posts
    27

    Question

    Did nobody ever do it before?

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

    Default

    Use a Kettle transformation or a ODBC driver that emulates a database on top of your Excel file.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  4. #4
    Join Date
    Jun 2008
    Posts
    27

    Default

    Ahh .. with ODBC. That does work, thank you.

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.