Recent content by kenp705

You are an absolute GURU!!! That formula works fantastic. I have a long way to go in learning Crystal. Thank you....

I have a field with street addresses. Anything that has an address which is a private property address will be 2650 N Josey Ln for example. A public roadway address will end with 00 such as 2600 block of Josey Ln. I am looking for a way to auto label addresses as public or private. What I...

Thank you Andy, there is only one thing that I forgot to mention. Some of the values in the number field are 0 and I don't want them to be Private. Your solution works great except for the 0's. Can I modify it so that the 0' are not labeled as Private? Thank you very much.....

I am using CR 11 and am having a problem with a number field. I have a number field containing 4 digit numbers, eg. 2500, 2650, etc... I need a formula that will look at the number field and label each number that does not end with 00 as Private. Can I do this with an "If then" statement...

I have an excel spreadsheet that contains fields such as Date in, time in, date out, time out. The date format is mm/dd/yy and the time format is hh:mm:ss. There can be multiple days in between. I am looking for a formula that will calculate the amount of time for each. All that I can find are...

I am using CR XI and a Unidata ODBC connection. Does anyone know if Crystal has the ability to explode multi value fields? Thanks for any help or advice.

I am using Crystal Reports XI and trying to connect to a Unidata RMS. The DB files have been converted to SQL compliancy and the Unidata ODBC drivers are loaded. When I try to logon to the DB it gives me an error 08004 key value must not contain special characters. The password does have a @...

BobSurUncle, you are a life saver. Thankyou. I just saw your previous reply and was working on that. Your suggestion works like a champ...... Thanks again.

I use WinXP and CR for ESRI XI. I have a field called Nature which contains a string that includes a "-". I have a formula field that extracts the characters before the "-", Left({tblIncidents.Nature},(InStr({tblIncidents.Nature},'-')-1)). The problem is when it comes to a Nature that does...

Newbie here, I am trying to find info on connecting Crystal Reports to our RMS which is an old Unicode based system. The RMS is/was called GEAC. Does anyone here have experience with this? GEAC has not responded in a month but did say that they have clients that do this. Any help or advice...

Thanks for the replies. I guess I need to find out how to setup the Repository. When I open it it gives the option to set it up. When I try it, it says made contact but there is no server on that port. Thanks again for your help...

I have tried to use the repository but obviously don't know what I am doing. Is there a way to save the formulas that I use in reports so that I can use them in other reports without having to remake them?? Thanks for any help.......

I am using CR XI on a WinXP desktop. Our RMS is GEAC/Extensity which is based on Unicode/Unidata. I am new to this, is there a way to connect CR to this RMS? GEAC says they have clients who do this but it has been 3 months and still no response on a solution from them. Does anyone here...

Thank you very much. Works like a charm.......

I am using Crystal 11 and WinXP. I have a field called Nature.Code in which there are text strings like BUVE-Burglary of Vehicle. I need to create a new field that looks at this field and returns everything up to the "-". It is not always the first 4 characters. I am new to this and am sure...