I have 1 dataset that provides the data for two Items A,B(Stored procedure will give output of only 2 rows. One for item a and other for item b).I have to create two tables one for Items A and other for Items B. So using the same dataset I need to split Item A values into 1 table and Item B values into another table. and the SSRS report format should be like
No of A items in Shop 2
No of A items in Warehouse 300
No of b items in Shop 3
No of b items in Warehouse 340
On each table add a filter so that it only displays the item you want.