Has anyone had issues with Crystal Reports and Trackwise database? I have "Database server is case-insensitive" checked off and it's still not working. For my parameter, if the user enters "LAV", I want "LAV, lav, LAv" all returned. But it's only returning exactly what the user types. Also, if in the parameter it's "LaV" it only returns "LaV". I have no formulas either. This is in my select expert {BAX_MV_GEMS_LOT_DISPO_RPT.LOT_NUMBER} like {?Lot Number} (because they also want to use a wildcard). even if I change it to {BAX_MV_GEMS_LOT_DISPO_RPT.LOT_NUMBER} = {?Lot Number}, still no luck. When trying uppercase({BAX_MV_GEMS_LOT_DISPO_RPT.LOT_NUMBER}) = {?Lot Number} it just does a complete table scan. Ideas?
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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Case Insensitive Not working CR 2008
- Thread starter nicmcd77
- Start date
If the database itself is case sensitive, it doesn't matter whether you have "Database server is case-insensitive" checked, the database will still process the data in a case-sensitive way.
I would change your selection formula to something like this:
Upper({BAX_MV_GEMS_LOT_DISPO_RPT.LOT_NUMBER}) like Upper({?Lot Number})
-Dell
DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
I would change your selection formula to something like this:
Upper({BAX_MV_GEMS_LOT_DISPO_RPT.LOT_NUMBER}) like Upper({?Lot Number})
-Dell
DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question