Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Startswith function returns no data
For those who possibly run into this problem, my solution ended up as: Select Formula: ( ({PATIENT.PAT_NAME}) startswith uppercase ({?Patients Name}) or {?Patients Name} = "All" ) SQL Passed: When I enter “b” in the parameter WHERE "PATIENT"."PAT_NAME" LIKE 'B%' This accopmlishes...- Cavitt
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Startswith function returns no data
Unbelievable... The field is case sensitive... I’ve never encounter that, but I’m more accustom to working with SQL Server. Thanks for the help anyway. -cd- Cavitt
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Startswith function returns no data
I get the same result as my first attempt. No data, but it passes to the database. I suspect this has something to do with Oracle, but I'm not familiar enough with it to know why... It's like it does not recognize the field as a string or something weird like that. Thanks for the quick...- Cavitt
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Startswith function returns no data
CR Version: Crystal Reports XI Professional SP2 Database: Oracle 10.2 Connection: Native Oracle Driver Problem: I'm attempting to select only data that starts with a string provided by a parameter(Or All). The "All" function works fine, but when I enter a value, like "A", no records are...- Cavitt
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
email each page to different address
Did anyone ever solve this problem? Im facing the same issue... -cd- Cavitt
- Post #11
- Forum: Business Objects: Crystal Reports 4 Other topics
