question

Please Some one Help? Assume I have a Table Called product : with Product-name, Sales, Date Assume I have 10 products : Product-name l Sales l date Pro1 l 1000 l 2-1-2000 Pro2 l 100 l 2-1-2000 Pro3 l 9999 l 2-1-2000 Pro1 l 1000 l 2-2-2000 Pro1 l 445 l 2-2-2000 and so on.... Every month Number of Product varies. In SSRS I need SSRS To Dynamically Split this tables based on individual product I have Product name as multi-value Parameter. .If I choose Pro1,2 it should show me the result as ----------------Table1 Data for product 1 Product | Sales ---------------------------Table 2 Data for product 2 Product | Sales --------------------------- If I choose Pro1,2,3 it should show me the result as ----------------Table1 Data for product 1 Product | Sales ---------------------------Table 2 Data for product 2 Product | Sales --------------------------- Table 3 Data for product 3 Product | Sales --------------------------- I know that We have to insert another table into the first table and group it...but I am not able to achieve it Please HELP!!!!