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

so, let's say my database stores the change, how would I word the formula? Thanks!!

Your "else if" doesn't have a condition. You've stated: "if {Asgnmnt.CSHold} ISNULL then" but when you say "else if" you don't tell it "if what". In other words, is it if CSHold is True? if CSHold is False, etc. Try giving your "else if" a condition. If isnull({Asgnmnt.CSHold}) then "HOLD"...

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

Thank you both! I was thinking there was a formula but I just didn't know the syntax. This has been incredibly helpful for this and other reports I have written.

Thank you! I'll try grouping the records.

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!

Thank you!!! I found a way to do this without writing a formula. I was trying to create a "Parameter" and happened upon the following on the menu bar: "Report" "Set Print Date and Time" sorry if I wasn't clear about my question but this is exactly what I was trying to accomplish. Using...

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

Thank you!! this was perfect: if "BARCODE" in {POLN.FREEFORM} then mid({POLN.FREEFORM},instr{POLN.FREEFORM},"BARCODE"),14) else "" Then, I used that formula (@Barcode)to write a second: right ({@Barcode},6) This gives me just the 6 digit barcode number. I was definitely on the wrong track...

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

Replace ({HPD_HelpDesk.Work Log}, "0"+chr (10)+":PEM: Added to by NetCmmnd, ", "") This got rid of the blank line that I was struggling with. Chr (10) is "new line". above is the final code used and it worked like a charm!!

I just decided to set up two separate formulas. The first one takes out the "O", the second one uses the first one then takes out the ":PEM:". Thank you for all your assistance!!

Crystal doesn't like this. I get messages like "the ) is missing," . I am writing Replace ({HPD_HelpDesk.Work Log}, "0" chr (13), "") If I include it in the quotes it looks for that exact string. If I don't I get the error message. any ideas? Thank you!

Thank you!! Is there a code for a hard return? It actually reads 0 :PEM: (text)... I was able to get rid of the ":PEM:" part but not in connection with the 0.

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