Crystal Reports - Parameters - How do i make them so they are not case sensitive?

Posted on 2012-09-17
Last Modified: 2012-09-17
I have a data base with Capitals and lower case customer number, is there a way to use crystal report to retrieve data so that if I enter in the customer number in lower case but the data in the data base is in upper case it will find the data?  right now I only am able to retrieve data is the parameter field is exactly the same as the data.
Question by:Scott Johnston
    LVL 26

    Accepted Solution

    There's a setting in both File|Report Options (specific to the report you're working on) and File|Options (global setting) for allowing for case insensitivity.  With this checked, it means you could code against a parameter like this:

    {} = {?Name}

    and it wouldn't matter if you input "jones" or "JONES", it would search against them all.

    Please note, however, this depends on your database.  Some databases, like Oracle, are ALWAYS case-sensitive, so this setting is completely ignored.  Other databases like SQL Server allow for case insensitivity, but only if they're configured that way during installation (most generally are, btw).

    Author Closing Comment

    by:Scott Johnston
    Awsome, I knew it would be simple.  Unfortuanatly the database is case sensitive.

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now