Uppercase in Source Exp.

rranjanerp · 2012-05-08

I have a field in the table which needs to be displayed as per selected in the report like Type : Inward or Outward.

I want to print the type either all in capital or first Capital & next small.

how can i use UPPERCASE in source Exp. does it requires code to be written?

Thanks..

Sog · 2012-05-08

If you want to report the value (as in you lose the option to change the value if you implement this) then you can use for sourceexpression uppercase(<field>) in your form/report/page/...

KYDutchie · 2012-05-08

Hi,

If you want to capitalize the first character only, there is a field property "Title" you can use.
If you want to all caps then you can do UPPERCASE(<Textvariable>) in your source expression.

Hope this helps,

Regards,

Willy

rranjanerp · 2012-05-09

ACTUALLY its showing error because i have to display dynamically

value to be displayed is : "Gate Entry Header"."Entry Type"
i cant write in source exp like :UPPERCASE("Gate Entry Header"."Entry Type")
plz suggest ..it would work if it was a constant..

dans · 2012-05-09

UPPERCASE(FORMAT("Gate Entry Header"."Entry Type"))

rranjanerp · 2012-05-09

thanks a lot ..

i was trying the same....

Sog · 2012-05-09

you're welcome.
The fact is, I just created a form, used an uppercase(format(<optionfield>)).
You know what, it works..
switched to another option, no problem, all uppercase.
So if you still fail to accomplish what you want, then I'd suggest you give us more information.
For example the ERROR itself. (I have never seen NAV seen just ERROR with no description whatsoever).

Uppercase in Source Exp.

Comments

Categories