Transform - Pivot Report

I have to create a report using the below query (query is in MS Access).
Can anyone tell me how to create a Transform Pivot report in SSRS?


TRANSFORM Sum(CD1([CheckAmount]))
AS [The Value]

SELECT "Total
Amount of Checks" AS Type, tblResult.AccountNumber,
tblResult.CheckDate, tblResult.Status, Sum(CD1([CheckAmount]))
AS Total

FROM tblResult

GROUP BY "Total Amount
of Checks ", tblResult.AccountNumber, tblResult.CheckDate,
tblResult.Status

PIVOT IIf(IsNull([statusdate]),"Outstanding",Format([StatusDate],"Short
Date"));