Case sensitive groupings

rbuser

Hi,

If I have a db where the field by which I am trying to group by contains
records that are the same, apart from the letter case, how do I group them
together?

i.e.: if the field A contains values called 'test' and 'TEST', how do I use
report builder to change a field value to uppercase, from 'test' to 'TEST'.
So all of these will be grouped together in under field A.

Red

nicocizik

Hi Red,

Try using the TppGroup.OnGetBreakValue event to set the value of the
aBreakValue parameter to uppercase.

--
Regards,

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

rbuser

Hi,

(To group the upper and lower case together)
So I have entered this code. What needs to go after the ":="?
And was I right to enter "DBText13.FieldValue"? This is the field that I
need to change to uppercase

===========
procedure Group2OnGetBreakValue(var BreakValue: String);
begin
UpperCase(DBText13.FieldValue);
BreakValue :=
end;
===========


Thanks
Red

rbuser

In article ,
redmond.shannon@sasims.com says...

Try this first:

procedure Group2OnGetBreakValue(var BreakValue: String);
begin
BreakValue:= UpperCase(BreakValue);
end;


EdB

rbuser

Hello,

Why don't you select "UPPER(fieldname) as GROUPFIELD" and use GROUPFIELD
to do the grouping?

Eric

rbuser

Thanks but that doesnt work.
The report still has the group headers in lower and upper case. And hence
they are seperated.
Any other ideas?
Thanks
Red


===========

rbuser

hello red,

If you use the db field for the header it's ofcourse lower and upper case!
Uoy may also use the same field as you use to break on ( the upper(xx))
field to display in the group header. Then all the values are in uppercase.

Eric