Search results for query: *

I am unable to link two dbase tables despite strict adherance to the CR help files. I have 41 fields in each of my databases and these are structured via numeric,string (character), logical and date fields. all 41 fields have the same names/titles regardless of the FILE name. The common field...

Dgillz...It worked! I used "if len(ToText({Ccs.REV_WT}))>0 then Rev:= {Ccs.REV_WT};" & etc. AND IT WORKED. A 10000 thanks to you and Daaf for your support. But, I must say that CR makes it very difficult for such an easy calculation. I did it first try with dBase iii. It's...

Daaf, I am still trying, but nothing worthwhile to report after having used my own or your codes. There is no real pattern to the figures that I do not want to see. A few examples are: a + b c =============== 73.85 73.85 158.45 158.45 65.85 65.85 67.85 67.85 39.73...

Daff, It worked perfectly....so easy yet so difficult for some (Gulp!) I feel sorry for you had to type my funny field names. BTW, the Syntax "Imp" is used by CR I,therefore, changed it to IMPT. I jumped up & down too quickly because when I applied the new codes, the results were the...

daff, both your set of codes worked...and added the two fields. This, I checked in dbase via dbase easy commands e.g. &quot;disp rev_est for rev_wt+imp_dam<>rev_est&quot; My problem is getting the codes right past the fist two fields while using CR. As you can see, I have data in 7 fields...

To both dgillz and daaf, thank you for answering. dgillz, I dlready tried changing the decimal points without much success - thanks anyway. daaf, I did use your argument, but it returned 0...all the way. For what it's worth, here is the real thing that will not work...pick at it, please. As...

I have 3 numeric fields in a database i.e. {abc.a},{abc.b} & {abc.c}. Data in RECORD fields {abc.a} + {abc.b} should equate data in record field {abc.c}. To check this, I created a new report file (using the active database) in Crystal and named it Data_Check. Data_Check displays {abc.c}...

Hello Ken! It worked via changing the table location. Thank you for your interest and advice. Kind regards. Claude PS: I may invest in the later ver

Ken, I'm afraid that I made a Bozo of myself. I explained myself very badly earlier....to recap I have amended the text below. ......where the formula for the field &quot;client&quot; is entered, this being {Client} and NOT AS I MENTIONED EARLIER {@Client}. CR5 will not accept the formula...

Dear Ken, I have numerous dbf files, one of which is called &quot;ABC&quot;. The file &quot;ABC&quot; has some 41 fields (similar in field names & LEN to my other files). If have created a number of reports (effortlessly) with CR4 and they work like a dream. The updates in the latter ver of...

Many thans for replying Ken. I will try again....and again if need be. I don't seem to be able to manage. Could it be because I may have a DLL file missing or something similar. So simple yet so hard for me + it's frustrating. Cheers Claude

I am still using CR v4 that came with VB5. It accepts {@fieldName} as a formula for all the fields in my dbf files i.e. without the need to insert the file name i.e. If I use the FILE &quot;ABC&quot; that has a field called &quot;CLIENT&quot; I can, with CR4, create a field formula by just...