uppsss aku blom pernah klo di query katanya sih pke store procedure bisa tp blom pernah dilakuin biasanya aku maennya di syntax reportnya atw klo mo ditampilin di grid aku akalin di calculate field....

DECLARE @Tgl1 AS SmallDateTime
DECLARE @Tgl2 AS SmallDateTime
SET @Tgl1 = '2007-07-01'
SET @Tgl2 = '2007-07-31'
SELECT TBM.Tanggal, SUM(TBM.Jumlah) AS Nilai, SUM(TBM.Jumlah) AS Nilai
FROM TBankMutasi AS TBM
WHERE TBM.Tanggal = @Tgl1
GROUP BY TBM.Tanggal
UNION
SELECT TBM.Tanggal, SUM(TBM.Jumlah) AS Nilai, 
(SELECT SUM(Jumlah) FROM TBankMutasi AS TBM2
WHERE TBM2.Tanggal >= @Tgl1
AND TBM2.Tanggal <= TBM.Tanggal)
FROM TBankMutasi AS TBM
WHERE TBM.Tanggal >= @Tgl1+1
AND TBM.Tanggal <= @Tgl2
GROUP BY TBM.Tanggal