Sorting and Grouping Issue with Tablix in SSRS Report

Hello Guys,

Here I am going to explain your regarding one issue  with Tablix Data while Sorting, Filtering and Grouping with Data. Actually I realized it when we just got the repeated data with more than one type. So Tablix consider only top of the data from dataset it include that data only and skip rest of the data. Here I am showing you one example. How it happens (for temporary solution you need to group it with more than one with same filed name) then it will work.

CREATE Table #ZoneData (Sr int identity(1,1), ZoneName varchar(20), ZoneType varchar(2), Amount money)
GO
INSERT INTO #ZoneData VALUES('South Zone', 'A', 2500)
INSERT INTO #ZoneData VALUES('North Zone', 'A', 2500)
INSERT INTO #ZoneData VALUES('East Zone', 'A', 2500)
INSERT INTO #ZoneData VALUES('West Zone', 'A', 2500)


--If we enter more than one zone type data then it consider only top of the data and skip the bottom one..


INSERT INTO #ZoneData VALUES('South Zone', 'A', 2500)
INSERT INTO #ZoneData VALUES('South Zone', 'B', 3500)
INSERT INTO #ZoneData VALUES('South Zone', 'C', 4500)
INSERT INTO #ZoneData VALUES('North Zone', 'A', 2500)
INSERT INTO #ZoneData VALUES('North Zone', 'B', 3500)
INSERT INTO #ZoneData VALUES('North Zone', 'C', 5500)
INSERT INTO #ZoneData VALUES('East Zone', 'A', 2500)
INSERT INTO #ZoneData VALUES('West Zone', 'A', 2500)



SELECT * FROM #ZoneData

So I found one thing to resolve the issue , to use Matrix instead of Tablix it works like charm...

I hope you enjoy the topic...

Cheers,
ved pathak