We created a transformation in Spoon that goes through multiple steps. At a number of steps, we want to make some charts from the data at that specific step. We tried making 1 report, but found that each report could only use 1 query, so we could not take data from different steps. To get around this, we just made multiple sub reports that each use a specific query from the transformation. However, we are now running into the problem that each sub report runs the transformation itself. So now instead of running the transformation once and getting 10 reports, we run the transformation 10 times in total. Is there a way to run the transformation once, but use different queries for each of the reports, or charts? This is one of probably numerous ongoing queries about the use of Pentaho Community Edition to generate graphical reports from our very large postgres database and metadata.