Try:
SELECT report_type,count (report_type) AS Count1 FROM Transactions WHERE R_Date BETWEEN @STARTDATE AND @ENDDATE
Then just provide teh start and end date values via parameters.
BTW: You do know you can use Parameters.AddWithValue instead?
cmd.Parameters.AddWithValue("@STARTDATE", dtime.Date);