Search Transfer Summary Report based on the specification given by Luadimer and found one under SLCI brand Edit the connection of the report from GAP to Cartier Edit the script in the report to Cartier details Patch the Stored Procedure in Charming_Charlie_dm where the Cartier is also reside Try to generate the report using the report designer with this I can easily test the report and got back to it, If I encounter an error while testing the report. Validate the data generated from the Transfer Report Summary in Pentaho versus JDA After I validated that the data in report was correct, Arvin instruct me to do the same this is for me to familiarize with this kind of issue in Pentaho and ask me to send the generated report to Laudimer for there checking also. Also we provided the access for the new report created for this.