Grouping on upper and lower case

rbuser

Hi

I have a report that groups on a field on our database that users
sometimes type in uppercase or lowercase. I've noticed report builder
groups upper and lower cases separately.

Tried using the Uppercase function but no joy.

Any ideas?

I'm using RB V7.03
Advantage Database

Many thanks.



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Bert,

Try using the Group.OnGetBreakValue event to set the current break value to
all uppercase before the group breaks.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com