Uppercase in Source Exp.

rranjanerp

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

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

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

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

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

rranjanerp

thanks a lot ..

i was trying the same....

Sog

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).