Hi

Here is the step by step process to show dynamic dataset in SSRS reports using tables

http://sivakrishnakuchi.blogspot.com/2010/02/how-to-show-dynamic-columns-in-sql.html