Add Dynamic Columns in RTF Based BI Publisher Report

Objective is to get Layout as below dynamically, where first row columns are dynamic.

Basic Salary			Exchange Commission			Food Allowance
Current	Prev.	Diff.	Current	Prev.	Diff.	Current	Prev.	Diff.
12,345.00	12,344.00	1.00	12,345.00	12,344.00	1.00	12,345.00	12,344.00	1.00

<G_EARNINGS>

<PERSON_ID>100000003353654</PERSON_ID>

<PAYROLL_ACTION_ID>43029</PAYROLL_ACTION_ID>

<BASE_ELEMENT_NAME>Basic Salary</BASE_ELEMENT_NAME>

<CURRENT></CURRENT>

<PREVIOUS></PREVIOUS>

<DIFFERENCE></DIFFERENCE>

</G_EARNINGS>

<?for-each-group@column://G_EARNINGS;./BASE_ELEMENT_NAME?><?sort:current-group()/BASE_ELEMENT_NAME;'ascending';data-type='text'?><?BASE_ELEMENT_NAME?> <?end for-each-group?>
<?for-each-group@column://G_EARNINGS;./BASE_ELEMENT_NAME?>Current	Prev.	Diff. <?end for-each-group?>
<?for-each-group@column://G_EARNINGS;./BASE_ELEMENT_NAME?><?CURRENT?>	<?PREVIOUS?>	<?DIFFERENCE?><?end for-each-group?>

Row#1 : It will create dynamic columns for each value of BASE_ELEMENT_NAME, which is grouped by base_element_name, hence it will place distinct values of same.

Row#2: It will also repeat but will add 3 columns for each iteration of for-each-group.

Row#3: same as row2 but instead of static data, it will add values.

Basic Salary			Exchange Commission			Food Allowance
Current	Prev.	Diff.	Current	Prev.	Diff.	Current	Prev.	Diff.
12,345.00	12,344.00	1.00	12,345.00	12,344.00	1.00	12,345.00	12,344.00	1.00