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 TouchToneTommy 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: *

  • Users: dchard
  • Content: Threads
  • Order by date
  1. dchard

    Help with stripping characters out of a field

    In Crystal 9 I have a formula (below) that searches the SO_Detail.PRTNUM_28 field and if it finds /SP or SP/ strips out those three characters. I need to expand the formula so that if it finds just SP it strips that out as well as the /SP and SP/. The formula also needs to not look at the...
  2. dchard

    Help with selecting and copying non contiguous ranges

    In Excel 2003 I have a spreadsheet that looks something like this> 2004 Units Product Jan Feb Mar ... Total ABC 1 1 2 4 124 2 0 1 3 2004 $ Product Jan Feb Mar ... Total ABC 10 10 20 40 124 30 0 15 45 I would like to create a vb sub...
  3. dchard

    Automatically increment a number in an Excel formula

    I have the following formula that sums data from another worksheet for a particular product for a particular month. When I copy the formula from one month to the next I would like to automatically have the month incremented by 1 or be able to do a search and replace on the formula in a range...
  4. dchard

    report selection based on subreport criteria

    Crystal 8.5 accessing Pervasive db via odbc connection I have a main report and several subreports that are linked to the main report. The main report is grouped by order number (subreports are details1, b, c, d, e, f, g) There is a date field subreport c. If that date field is not within a...
  5. dchard

    Can't link text fields in CR9 from an MS SQL DB

    I have two files from an MS SQL DB. In each file I have a text field called mdevice. I want to link the two files together in a Crystal 9 report using this field, but in the database links window these two fields are not displayed in the list of fields available to link. Why doesn't Crystal...
  6. dchard

    changing an access97 database odbc connection string

    I have changed an ODBC system dsn that is used by an access97 database. The name of the dsn is the same but the server and ip address have changed. I have changed the odbc setup on the client machine and tested it. It works fine and can connect directly to the database. However, I have an...
  7. dchard

    Changing the client DSN to point to a new server

    I have moved the Pervasive database that I run Crystal reports from to another server. The old server was bznas1 with Win2k server, ip address 10.10.0.50, the server DSN called MAXDAT. The new server is ILXAS1 with Win2003 server, ip address 10.10.0.51, the server DSN is called MAXDAT. So, I...
  8. dchard

    CE9 printing garbled text to HP postscript printers

    Reports are written with Crystal Reports 9. They print fine from Crystal Reports, but when printing from CE9 with the ActiveX viewer they print garbled text something that looks like 21 (77$&8 I am printing to an HP5000 postscript printer. Font is Arial on all reports. The server that CE is...
  9. dchard

    help trimming a string field

    I need help writing the formula for the following scenario. I have a text data field that contains a part number. Some of the part numbers end in /SPxx and some end in SP/xx where xx is a random number. I only want the data prior to the /SP or SP/ LDC3916 LDC3916/SP01 LDC9615SP/02...
  10. dchard

    Nec2000 need to forward calls directly to another extension voicemail

    I have inherited an Nec2000 IVS integrated with NEAXMail AD-40 voicemail system. I need to setup an extension to foward directly to another extensions voicemail but can't figure out how to do this. I am using MatWorx to program the PBX, and the Remote.exe program for setting up voicemail. I...

Part and Inventory Search

Back
Top