-
February 1st, 2008, 04:21 PM
#1
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.
-
February 1st, 2008, 05:50 PM
#2
Re: Running Total calculations not what expected
Could you post some code? We have no idea what you tried...
-
February 4th, 2008, 12:30 PM
#3
Re: Running Total calculations not what expected
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
-
February 4th, 2008, 04:06 PM
#4
Re: Running Total calculations not what expected
Have you used the parameters in the record selection formula? e.g.
{table.date} in (?BeginDate) to (?EndDate)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|