Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

parameter question Expand / Collapse
Author
Message
Posted Friday, September 27, 2013 7:58 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:16 AM
Points: 60, Visits: 98
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
Post #1499392
Posted Friday, September 27, 2013 8:43 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 5:16 AM
Points: 60, Visits: 98
Nevermind yall. Got it.
Post #1499436
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse