Recent content by fort

I have been testing through an Access database, but I am going to switch it over to ODBC, after I get it pulling up the correct data. Do I need to switch it over before then?

I tried both of these and couldn't get them work, unless I was doing something wrong. I am using Windows 2000 and Crystal Reports 8, does this make any difference? Thanks

I am doing a report pulling up special characters. I have tried to give it a condition statement looking for ". Example ChrPos= inStr({Database.data}, """) I have tried putting it in numerous ways, but nothing works. If I put it in """, then I get an error...

Hi, I have been trying to make a report pulling out items with duplicate records. I am trying to get the same manufacturer name and having the same manufacturer number. I have tried using PreviousValue--using it I pulled up the whole database, stating which ones were duplicated. But I need...

Hi, I have been trying to make a report pulling out any item with the same manufacturer name but it can't have the same manufacturer number. I have tried using PreviousValue. Using it all I done was pull up the whole database, which stated which ones were duplicated. But I need this sorted...

I got it to work!!! Thanks so much to all of you!!!

I tried both of your tips and I still can't get it to work. Would you please go into a little more detail(I must be dense). I am using this on a {Inventory.field}. Thanks to both of you!!

I am using Windows 2000 and Crystal Reports 8. I am trying to get a report from Crystal Reports pulling up information that doesn't have a null field. I have tried a few different things, one was using the Record Selection-- but I couldn't get it to work, maybe I was inserting something wrong. I...

I am using Windows 2000 and Crystal Reports 8. I am trying to put a report together only pulling out fields which aren't duplicated. In checking the code, I can get my data, but I can not get it to print. I can only get so far in the program and I get the Run-Time Error--Not enough Memory for...

I failed to mention this for a currency field. I tried it stating-- If (IsNull({Field} or ({Field} = 0)) then.. Any more ideas?? Thanks!!

I am using Windows 2000 and Crystal Reports 8. I have been trying to determine a field which is either null or a field = 0. I have tried (IsNull{Field} or {Field} = 0. Any suggestions?? Thanks!!

Naith-- Thanks for the help on the uppercase!! I checked on turning off the Case Insensitive SQL Data (again), and it did take care of the problem. Thanks again!!

I had already tried both of these solutions and neither one worked. I just can't figure what I am doing wrong on either one. Any more ideas?? Thanks!!

I am using Windows 2000 and Crystal Reports 8. How do you determine a database field with all CAPITAL letters?? Also--trying to determine a field that is either null or a field = 0?? Any ideas?? Thanks