sql server reporting services: Upper case format -- sql server reporting services

You're in the

sql server reporting services

group:

Upper case format

Kyriakos
1/31/2006 9:13:27 AM

sql server reporting services:

Hello all,

does anybody know the format code for upper case field formating?
I.E. in MS Access it's the greater sign ">" and turn all the fields text to
upper case.

Re: Upper case format

Bruce L-C [MVP]
1/31/2006 12:37:49 PM

You can do this multiple ways. You can do it in SQL
Select upper(myfield) from sometable

You can do it in the expression:
= ucase(Parameters!Table.Value)

=(Fields!Column_Name.Value).toupper

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Upper case format

Kyriakos
2/1/2006 12:20:28 AM

Thanks,

I need to start experimenting more on the VBA commands...

By the way, I find it hard to use the offline help in reporting services.
When I want to do a search I do not see in the "Filter by" drop down field

Re: Upper case format

Bruce L-C [MVP]
2/1/2006 9:45:19 AM

For RS 2005 you open up the SQL Server 2005 help. Mine has a filter by for
RS.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn