Search results for query: *

I need to print the name of a model where the parent id = the model id. the submodels are on the same table as the models. lparentid modelname modelid 62345 abc 62345 62345 xyz 67543 67588 test 67588 62345 sample 68726 i want to return "abc" on records "xyz" and "sample" since they both...

I need a formula that tells me how much a UnitPrice has changed from one month to the next to show if we've added cost to an asset in our database. Example, UnitPrice change from July 1, 2007 to July 31, 2007 or UnitPrice change in LastFullMonth. How do I write the formula for "change"...

I need to know the command to suppress an entire record if it a key field is duplicated. Example, if the employee number is duplicate I only want to see the first record on that employee. can someone help?? Thanks!

Is there a way to have Crystal read data for a previous date. Example, I am working with a depreciation report. Everything is read as of the data in the db at the time I hit "refresh". Sometimes, however, we may need to go back and review what the depreciation was on a particular date in the...

I would like to delete all words up to the word "Barcode" and after the 6 digits that follow. Ex: "text string describing equipment BARCODE 123456 Used for description of items" I have been playing with this formula: Replace ({POLN.FREEFORM},"BARCODE","") Obviously it needs an "Upto"...

I would like to suppress certain words from a free form field. Ex., we have an application that has an auto-fill for the initial step ("0 :PEM:"). I would like to suppress just that value throughout the field but leave all other text in tact. Is there a formula I can write in order to...