Use WHERE instead of HAVING
WHERE fromdate = CONVERT(smalldatetime, @stdt, 103) AND todate=CONVERT(smalldatetime, @enddt, 103)
GROUP BY.....
-- CK
but it ll display only that particular fromdate and todate reports, but i want the reports from that start date to enddate, i.e it should display the reports b/w these dates including the start and end date