Hi Gopinath Thanks for this, worked perfectly. 

Hi Clifford Thanks for this. However, this does not appear in that folder; it shows the other variables, such as termination date and recommended for rehire but not termination reasons/action. I've had a look in the file which shows all the different variables within each subject area for HCM and I still can't find it 

Hi Abinash, Yes we solved this; we had 1 Summary Dataset and 2 Detailed Datasets (1 for Payables and 1 for Receivables). I joined the datasets up using the data modeller to create a link between the key IDs (in our case, project ID). The detailed datasets were joined onto the summary dataset. This formed an overall…

Hey Pradeep, This is where it gets complex; we are using the Excel Template Splitting Technique and it is working well. When we manually run the report we get the output expected (data from each dataset on separate tabs). However, we then need to automate this and burst the output by each individual project to our FTP…

Attached a very basic example of Group Left, please use your XML to run it. Obviously, this merges cells, thus can be harder to filter/unpleasing to the eye. Partioning would offer the results you are after in the output design. 

Hi Karthik, We have been doing something similar and we solved this problem by using a partitioning statement on the PO number within the SQL, have you tried that yet? The other option is to group left within the RTF template. Aaron