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 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. petsgalore

    Editing Crystal Reports SQL Query

    Hi, I just loaded Crystal Reports Version 11. I was previously using Version 8.5. I am trying to use version 8.5 reports in version 11 and I'm having problems editing the query. I can't edit the report's SQL query through the 'Show SQL Query' dialog box in version 11 as I used to in version...
  2. petsgalore

    Phone Number Formatting

    Hi, I have a similar question to BENTK in thread767-1020693 except that my phone number data is a 10 digit number (example: 9999999999) not a string. When I tried Picture(({field.name}),"xxx-xxx-xxxx") to format the data, it gave me the error 'A string is required here'. When I tried...
  3. petsgalore

    Count of formula, New to Crystal

    Thank you for all the quick responses. I tried lbass's suggestion and it worked.
  4. petsgalore

    Count of formula, New to Crystal

    I'm new to Crystal Reports and I'm setting up a report in Version 8.5. I need a count of a field when a particular option is present in the data, i.e., the field has four possible options; 'N', 'H', 'C', or it can be left blank. Basically, I need to count all the 'N'. I've tried setting up...

Part and Inventory Search

Back
Top