Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Parameter in CAPS Post Reply Post New Topic
Author Message
Minco
Groupie
Groupie
Avatar

Joined: 28 Nov 2012
Location: United States
Online Status: Offline
Posts: 62
Quote Minco Replybullet Topic: Parameter in CAPS
    Posted: 19 May 2016 at 3:59am
I have created a report that tracks the units purchased on sales orders that utilize our current Promotion going on. There is a field on the sales order that lists a promo code for that line item if the item is on the promo. SPRING16 is the data in the field on the sales order. My report parameter asks for the user to enter the specific promo code (and date range) for the report. My problem is, I can't figure out how to make the parameter all caps - SPRING16. It always changes it to; Spring16 and no data is returned for the report. I also tried to make the selection of the report Like {?Promo Code} but that has not worked either.

Thank you in advance!
Be kind to those less fortunate.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 19 May 2016 at 4:07am
There is the UCase function which will change any string to upper case (i.e., UCase({StomeField}) = UCase({?SomeParameter}), then I seem to recall (on some version of Crystal), you can tell it whether or not the database is case sensitive (but then maybe it is the database side).
IP IP Logged
Minco
Groupie
Groupie
Avatar

Joined: 28 Nov 2012
Location: United States
Online Status: Offline
Posts: 62
Quote Minco Replybullet Posted: 19 May 2016 at 4:12am
YES! This is what worked in the select criteria;
= (UCase ({?Promo Code}))

Thanks much!
Be kind to those less fortunate.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.