Is there a way in a Webi report to convert text to upper case? I tried doing this in the universe using the {fn ucase()}, but then I get an error because in the SQL it is trying to group by that object and I get an SQL error.
Help!
Thanks.
K
klearnsbo (BOB member since 2005-09-23)
Does WEBI support the UPPER() reporter function like full client does?
Hi,
since you’re using sql server, why not use the UPPER() function in the object ?
I never use this {fn ucase()} syntax…
I don’t believe there’s an upper function in webi, but you could use replace 24 times… 
Regards,
Gerard
highandstoned 
(BOB member since 2005-08-01)