I am trying to pivot a table to Row which have duplicate records on all columns but, a unique ID Named ([log_ID]) at the last columns . I wont log_ID field pivoted and given dynamic name as log_ID_1 ,log_ID_2 ...etc FYI - THE log_ID's is not static they change at every execution's they could be less or more .

My table retrieve records as this .

NOTE The ROW_NUMBER() function needs an ORDER BY. I use Emp_ID even though they are all the same so that the results should be returned in the order they sit in the table. You can change the order by clause to order the log_ID's in whatever order you like.

Now in your report, add a matrix control, add a row group by emp_id and name, and add a column group grouped by col

If the table has more than one emp_id then these will appear on separate rows in the report.

That's all there is to it.