Recent content by Alicia159

First of all, I am running Crystal 9 with SQL 2000. I have a field in a vendor's database called "crscore" that is integral in a variety of my reprots. The field used to be numeric, and has been converted to a string to accomidate the very few people who do not have a score, but instead...

I realize that I could select all of the ATM records, but to get the information I need I also need to exclude people who have both an ATM and a Visa. So that I get only the people who have only an ATM card.

Hello, I am running SQL 7 and Crystal 8.5 and need to figure out how to get a formula to eliminate records if a field shows up more than once...for example right now I have data Acct Number Card type address 12345 ATM 123 maple 12345...

Hello, I hope someone can help me out with an issue that I have been staring at for a while now. I am running Crystal 9 and conecting to a DB2 database. Basically I am trying to get a report that shows a random 10% of records for each group, so I created a random number field, sorted by...

Hello, I am hoping that someone can help me out here. I am trying to put together a report that will compare data to different parameters depending on the value of the data. For example: Fields: Tier, Rate and 4 parameter fields Tier has four values, 1-4. I want to have everything that...