Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Pentaho Reporting Output - dynamic output file name

  1. #1

    Default Pentaho Reporting Output - dynamic output file name

    Hello !


    I'm using the pentaho reporting output step, and after generating the report i'm going to use the Mail utility.

    For my output file, i want the date appended.

    How can this be achieved ?

    It doesnt accept a variable in the output file field, and with generate rows, i'm not able to provide a date variable either..

    Thanks !

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Use a fixed name and rename the output file in a later step.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2013
    Posts
    22

    Default

    How is it possible to rename a file in a later step?

    Only by creating an own class in java which renames the files? Or is there an easier way?

  4. #4

    Default

    In my case, i wanted to generate a report using Pentaho reporting output, and then later rename the resulting file, and email it. These are my job steps :

    Job 1 -
    Step1-> Set Variables (required for the email step, email addresses, SMTP server details etc)
    Step2-> Call transformation for report Generation. Transformation has the following steps :

    • Generate Rows (set the prpt file name, and fixed output file name and path)
    • Pentaho Reporting Output (execute the prpt and creates result file)

    Step3-> Copy/Move Result Filenames (This step automatically knows the files resulting from the previous steps, and provides options to append dates to the resulting files, and move them to desirde folders)
    Step4 -> Mail (The attach files tab automatically knows the result files, and attaches them to the outgoing email)
    END
    Last edited by Sue; 03-05-2013 at 10:20 AM.

  5. #5
    Join Date
    Mar 2013
    Posts
    22

    Default

    Hi Sue,

    I cannot find a step to copy/move files...
    And I wonder how to set the "output report name" by variables...

    I am currently using:

    Get data list for report input
    <loop>
    generate pdf report

    Maybe you could post the xml contents of your xaction or attach it?

    Thanks!

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.