Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Unanswered: Crystal Command Parameters

    In Crystal (9) I am able to set the parameters to select "All" or select the chosen parameters.
    For example:
    ({branch_id}={?Branch} or {?Branch}= 'All' )
    Is there a way to do this in a Crystal Command?
    I have only been successful with:
    branch_id between '{?Branch_Start}' AND '{?Branch_End}'
    But I would like to keep the parameters to a minimum.

    Any suggestions?

    Crystal Reports 9
    Windows XP

  2. #2
    Join Date
    Apr 2006

    Using LIKE

    Here is what I've come up with.

    Branch_id LIKE '{?Branch}'

    Then I set the default to a wild card (%) and change the description in the Crystal Parameter to 'ALL' and it works.
    Only problem with this method is I am unable to do a range.

    Any other solutions?

Posting Permissions

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