CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008
    Posts
    2

    Thumbs down 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.

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Running Total calculations not what expected

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

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    Feb 2008
    Posts
    2

    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

  4. #4
    Join Date
    May 2006
    Posts
    324

    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
  •  





Click Here to Expand Forum to Full Width

Featured