CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

How to create case-insensitive account name report?

edited Feb 14, 2012 5:45AM in CRM On Demand - Reports and Dashboards (MOSC) 3 commentsAnswered
We have an account report that allows users to enter part of an account name and return matching results. The prompt is case sensitive but I would like it to be case insensitive.

Since the left pane search for Account Name is case-insensitive and you can select case-insensitive when creating account list views, I am hoping there is a way to apply this same functionality to a report.

I understand I can convert Account Name to upper or lower and tell people to search that way, but that will be a last resort.

Any suggestions on how to make the prompt value and report results for Account Name case-insensitive?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center