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!

  • Congratulations gkittelson 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. dwalsh514

    Problem with record selection including empty fields

    I created the sql statement in Crystal record selection. Once I ran the report, the Show Sql that is posted above is what was returned. I did fail to say that the report return empty, no records were selected at all. If you could look at the Crystal record selection and suggest how to correct...
  2. dwalsh514

    Problem with record selection including empty fields

    Hello all, I am trying to setup a record selection that uses a parameter to query a field called Workorder.phone on an Oracle 8.1 database. My goal is to report on all records that do not have ie, '11/06', in the Workorder phone field. So far, I've managed to pull the records that do not have...
  3. dwalsh514

    Help on Sql where statement for Crystal Reports 8.5

    Once again, Thank you for your patience with me. Ok, I got it to perfom as desired. I'm able to vary my parameters to obtain desired results. As you can tell from my postings I'm very new to Crystal, I have the report behaving as I want it too. Now, how can I set the report up so when a user...
  4. dwalsh514

    Help on Sql where statement for Crystal Reports 8.5

    Thanks synapsevampire for replying. My goal is to have 4 parameters for the user to choose from. But, there may be a case when 3 out of the 4 parameters are not desired by the user. I found that if I use and "=" comparing the parameter to the database field, the parameter value has to match...
  5. dwalsh514

    Help on Sql where statement for Crystal Reports 8.5

    Hello All, I'm trying to establish a record selection formula to use against an Oracle 8.0 database using Crystal Reports 8.5 I've tried to read up on it and use some ideas from fellow posters, but I can't seem to get the record selection to work here's what I have in my Record selection...

Part and Inventory Search

Back
Top