question

Deepthi avatar image
Deepthi asked

SSRS - TABLE INSIDE a TABLE

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!!!!
ssrstablix
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.