Search results for query: *

That did it lbass! You've made my day!!!!!!!! [bigsmile] Thank you so much!

Firstly Turkbear... him is a her. [ponytails][2thumbsup] But that aside, stuck the formula in and it seemed to be chugging along, then I got an error message that says "A string can be at most 65534 characters long." I don't really understand why I'd be getting this error since the data in...

No, I likely won't make it a multiple value parameter. The problem is only when I search for 1 - Accounting. I've used the formula Turkbear gave above, but it is now eliminating records from the results for "1" (Accounting) that also have "10" (Production) in the string. For example: If I...

Hmmmm... definitely closer. The problem that is happening now is when someone chooses 1 - Accounting, it is not pulling records where the user chose 1 - Accounting AND 10 - Production... If the user chose both of those interests, I still need them come up when someone chooses Accounting as...

Thought of that, but how would I do that for something like the 1... if I do an "if 1 is in the string", I'll also get the 10s, no? And I can't do 1; since some of them may only have a 1, so would have no semicolon.

Hi there... using Crystal 11. Basically, I need to split a string field into separate entries. Our customers entered a number of interests when they registered on our site and our system was designed to store that data as follows, "9;1;10;9;8;6;5;4;3;2" (where 9 = Accounting, 1 = Marketing, 10...

Firstly, I am using Crystal Reports 11. My problem is I need to use a multi-value parameter to pull results based on a text field. The other problem is that multi-value parameter has to allow for custom values. For example, I am asking the report user to tell which countries they want to see...

Thank you both SO MUCH for your help! lbass, I did end up using the formula you provided and it worked great. CrystalizeCanada, I will keep working with the ones you suggested so I understand how they work in case there are other instances where they might be worth trying. Thank you...

Thanks Gordon. I'd like to give this a try, but have never worked with Commands before. In your above example, where you have FROM anytable... what do I put in for anytable? Do I enter the table name + the field? (ex. Customer.'HairColour') Also, can you finish that off to explain how I...

My apologies, yes, that is correct. Thanks!

Just to clarify a bit more... in case I'm being unclear... say I have records for Tom (blond hair), Sue (brown hair), Pam (blond hair), and Jim (brown hair) and in the report I have all results grouped into people with red hair, blond hair and brown hair. My problem is, my report is currently...

Hi Gordon, Thanks so much for the response! My problem is, I don't want to display records that don't match, I only want to display group headings that have no results. I believe the formulas you've provided above works to display the records that don't fit, correct? If I did that, I would...

I am using Crystal Reports 11. Currently, a user will choose a number of groups from a parameter, and I want the report to show all groups chosen in the final report, but for ones where there are no results, for it to display something like "No results found." The problem I'm having is since I...