Running Total calculations not what expected

I am creating a crystal report (version 10) that displays the total number of records (not the actual records) for the date input by the parameter fields; my problem is, it is counting all the records in the database instead of only the ones I want counted in the date range. Its been several years since I've used Crystal Reports, can anyone shed some light on this? Your help is much appreciated.

Could you post some code? We have no idea what you tried...

SELECT `agentactivity`.`AgentDN`, `agentactivity`.`AgentFirstName`, `agentactivity`.`AgentLastName`
FROM `agentactivity` `agentactivity`
ORDER BY `agentactivity`.`AgentDN`

This is the only code I can find. I am running a total on each agent's number of calls by counting the agentDN field, which is working fine, its just not using the parameters I created as a date range for the report, and it is giving me all the calls they have had since employment. Should there be a "Where" in the statement to grab only the calls in the parameter fields (BeginDate, and EndDate)?
Thanks for your help

Have you used the parameters in the record selection formula? e.g.
{table.date} in (?BeginDate) to (?EndDate)