Search results for query: *

I found my problem... If you encounter the same problem, make sure you go to "report options" and check "select distinct data for browsing". Doing that solved the problem. Rick

hi. thanks for the quick response. no i don't have more than 500 unique values in the field i'm selecting. i appreciate the thought though.

Hi. Using Crystal 9 and an xl spreadsheet as my database. I have a field with customer names and I want to select a small group of these names for reporting. When I go to select expert and choose those customers as "is one of", a couple of the names aren't there to select?!? Yet if I don't...

Just FORMATTING a range of numbers in Excel as TEXT changes NOTHING. The underlying value is still a number! Is there a way to enter a formula in crystal that will convert the number to text (ToText didn't work)? Thanks for the info on text/ number known issue...did not know that.

Thanks for the quick reply. I'll be glad to give you any specifics you might need. I'm using Crystal 9. The report uses Excel as it's data source. The spreadsheet shows a number in the field in question. It's a string field and every other cell in that field (with the exception of one)...

Good morning. I've got a table with a string field that looks like this: ProductName G2301 M2398 40002 The output for ProductName omits the last value. How can I get this "number" to print in the report? Thanks.

LB, you're a genius! Thank you!!

Sorry for the delay in responding. I was abducted by aliens. Thanks for the replies. It's time to rerun this report so let me give it a try.

Greetings. I have a database that collects new assignments for the month for 20 individuals. I want to create a report that generates, let's say 10 random records for each individual. I've got the part where you add rnd() to the detail section in ascending order and using the suppress...

thanks, i'll give that a try.

Greetings. I have an excel database that keeps employee names and assignment counts monthly and ytd. One of the employees has gotten married and changed her name. How can i combine the data from her maiden name to go with her new married name. I'm using cr9 to report the data. Thanks.

greetings. figured out the answer to my problem. it had to do with null values. i went to file/ report options, and unchecked "convert database null values to default" and now my distinct counts are correct.

wow! thanks for the quick responses. the file is at work so i'll try and upload tomorrow. this is my first question on the forum so i appreciate your help. rick

using 'distinct count' in a count of data in a report that combines 3 excel worksheets. i look at the details and count manually and the count is off by one in two of the columns. ideas? thanks. rick