Recent content by dchard

Yes, it strips off the first three characters of the field SO.DETAIL_Partnum, and I copied it and pasted it into Crystal. The original post contains my original formula which does work. I incorrectly stated that I was trying to remove three characters from the field. Actually, I am trying to...

Well the bdreed solution does seem to get rid of the SP but it is also stripping off the first two characters of the field. I don't want those stripped off, I just don't want Crystal to look at them when considering the SP replace Thanks Deb

The SO_Detail.PRTNUM_28 contains data that looks like this SPA9000 (i would not want to strip this at all) BSP123 (i would not want to strip this at all) OMH6700/SP01 (this should be stripped to OMH6700) OMH6701SP/01 (this should be stripped to OMH6701) OMH6700SP01 (this should be stripped to...

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

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

Mike, The first one did not work, at least I could not get it to work, but the second one does. Thank you. Deb

Mike The spreadsheet that the formula is in has column headings Jan, Feb, Mar etc, the spreadsheet that the formula refers to has one column for the date of the sale and I am extracting the the data that is in column L based on the date in column B. So when I copy the formula from the Jan...

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

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

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

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

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

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

Rosemaryl, Thanks for the explanation, no I did not understand what exactly it was doing, and when I pasted inthe formula I got some kind of syntax error that I did not feel like figuring out. So, even though the second solution was more elegant, yours was the quickest to implement. I will...

Thanks to both of you for your reply, I ended up using RosemaryL's solution, with a minor modification, if InStr ({SO_Detail.PRTNUM_28},'/SP' ) > 0 then Mid({SO_Detail.PRTNUM_28},1,InStr ({SO_Detail.PRTNUM_28},'/SP' )-1) else if InStr ({SO_Detail.PRTNUM_28},'SP/' ) > 0 then...