0

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

Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
Nandha
  • 41
  • 7

0 Answers0