Results 1 to 4 of 4

Thread: Parameter Field

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    Parameter Field

    I included a parameter field in my crystal report so that
    I can report on a specific organization or ALL...

    I would like to allow the user to pick "ALL" and report on all the
    organizations...

    How can I do that.. If the user picks "ALL"...?

    Thanks in advance..

  2. #2
    Lively Member
    Join Date
    Sep 2003
    Posts
    74
    easiest way to do this is using selection formula

    If selection formula is empty, it will show everything, if it has a value, it will compare it to the value of the chosen parameter

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    ...

    Hi! I came up with the answer.. Thought it might come handy for others searching later on..

    In select expert..
    Use a formula (just like the one below) for this parameter field

    if {?DisplayDataPerOrg} = "All" then
    true
    else
    {MyTestRpt.OrgName} = {?DisplayDataPerOrg}

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Aug 2000
    Posts
    617

    Thanks thomas

    Just saw your reply..

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