IT will be expand when running in ssrs,i am trying to add total its show wrong total. The Query I am Trying:
SELECT MTime,CDate ,MNAME,MemNo,Liters, FAT, SNF, MRate, Amount
FROM tblCowMilk INNER JOIN
TBLMEMBERS
ON tblCowMilk.MemNo = TBLMEMBERS.MNO
WHERE CDate '2016-02-01' Between '2016-02-10' and
group by MNAME,MTime,MemNo,CDate,Liters, FAT, SNF, MRate, Amount
See the ssrs Designing Tablix Before Running in rdlc:enter image description here
After running See this:enter image description here