I have tranformation:

Get File Names => Modified Java Script Value (where I create paths for report definition file and output file and path to Excel file) => Pentaho Reporting Output

PRD report (Pentaho Reporting Output step) base on PDI transformation. I need to receive parameter from first transformation and use it to pass to PRD query transformation (this is the name of Excel file to open).

The PRD query transformation is:

Get System Info => Microsoft Excel Input (read filename from step) => Sort rows

Well, I just try to find solution... No idea if Get System Info is able to receive parameter ("command line argument" type there)... no idea if the parameter, string (path to excel file), can be read by Microsoft Excel Input...

Anyone can help?