parameter question

  • Hi all,

    Question about parameters. So i have my report query and then I have a parameter query. The paramter is built into the report query (@Muni). The parameter is not a multi-value parameter nor is it a dropdown. The user must type in their parameter value. For example, if the user types in 'Abington' values will return for Abington. My question is that I want users who type in all caps, or all lowercase letters to return the same values. So, for example, if a user types:

    Municipality

    ABINGTON

    abington

    Abington

    the parameter will return values for Abington.

    My parameter table is set up like this.

    Entry Lookup

    ABINGTON Abington

    Abington Abington

    abington Abington

    I just want to give the user the option of typing in lowercase or uppercase, etc.

    Sorry for the lenghty question.

    Thanks everyone in advance for your time and consideration.

    Mike

  • Nevermind yall. Got it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply