Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hootlehead

    Creating a Parameter that contains Multiple Default Values

    Ok got it to work.... now is there a way to add an 'ALL' Parameter in the selection list as well?
  2. hootlehead

    Creating a Parameter that contains Multiple Default Values

    ( ({@Created Date} = {?Date} and {CADUNITLOG.CADUNITLOG_UNIT_CLASS} = "L" and {CADUNITLOG.CADUNITLOG_ON_DEPT} = "04") and {CEVENT.CEVENT_DESC} = {?Events to Show} or {CEVENT.CEVENT_DESC} = 'ASSAULT IP' or {CEVENT.CEVENT_DESC} = 'ASSAULT JO' or {CEVENT.CEVENT_DESC} ='ASSAULT PE' or...
  3. hootlehead

    Creating a Parameter that contains Multiple Default Values

    It is disregarding the rest of my selection critera such as the date range and departments and returning all information in the database.
  4. hootlehead

    Creating a Parameter that contains Multiple Default Values

    I am sorry, this isn't helping to solve the problem I am having. All I need to be able to do is always select the following (CEVENT_DESC = 'ASSAULT IP') or (CEVENT_DESC = 'ASSAULT JO') or (CEVENT_DESC ='ASSAULT PE') or (CEVENT_DESC ='BURGLARY IP') or (CEVENT_DESC ='BURGLARY JO') or (CEVENT_DESC...
  5. hootlehead

    Creating a Parameter that contains Multiple Default Values

    I am trying to create a report that has multiple default parameters. I have tried creating a command as seen below however it returns all values and not the ones I have specified. I am using Crystal 11. My Table name is CEVENT and my field Name is CEVENT_DESC. Why is this not working -...

Part and Inventory Search

Back
Top