Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Unanswered: Last 7 Days formula problem

    Hi - I am a novice in Crystal and am creating a report where I have to populate cases opened in the last 7 days and cases closed in the last 7 days. "or" doesn't work and is pulling different regions than I have in the record selection formula. Can anybody help? The record selection looks like this right now:

    Last7Days=({Case_Profile.CreateDate2}; {Case_Profile.ResolutionDate}) and
    {Case_Profile.MetroName} in ["CINCINNATI-617", "COLUMBUS-616", "CONNECTICUT-602", "CORCORAN-605", "ERA HARRISBURG-612", "LONG ISLAND-604", "NEW JERSEY-608", "PITTSBURGH-610"]

    What's happening is it's pulling cases with the dates but not all of them are in one of the metros listed above. I only want to pull the dates for the above metros. What am I doing wrong?


    Thanks, Ann
    Last edited by tinteardrop; 04-16-12 at 16:53.

  2. #2
    Join Date
    Apr 2012
    Posts
    2

    Last 7 Days formula problem

    Figured it out myself. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •