Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i have a table in that two columns like current_user and Full name but current user is displaying short names instead of full name.
my question is for all current user field i want to map full name please help how to add.
for ex:
CURRENT_USER | FULL_NAME |
Rosh.Gupta | Rosh Gupta |
Ks | KSHIRSAGAR |
SEaso | |
VMalani | Vijay Malani |
balu.ingale | Balu Ingale |
VSutar | VISHAL SUTAR |
SEaso | Shibu Chacko Easo |
for all current_user i want to display full name.
Would you mind giving us more information about your needs?
You have both the fields or only Current_User field only?
if yes,Both are into same table or different table?
Then use the FULL_NAME field instead of CURRENT_USER where you want to show the full name.
Hi Gysbert,
that two fields are coming form diff tables and i have merged into single table in my report am using more than 150 fields
in my report diff scenarios like based on order status.
for ex if order status is complete it is displaying current user , full name is displaying blank.
like that i have many scenarios so ..
How did you merge these two tables??
Also if you Full name is blank, then hope you are using Current_user?
Ok, and the problem is...?
yes ur guess is correct but current user is displaying short names that is the problem.
That is the data that you are getting, for that you need to make change in data at database level.
If data is getting stored like what you are getting, then you can do anything.
If it is 1 or 2 values, then you can customize it but not for multiple values.
for ex:
ID | OREDER_STATUS | CURRENT_USER | FULL_NAME |
550844 | COMPLETE | SEaso | |
995490 | COMPLETE | nadeem.ansari | |
1033074 | COMPLETE | das.patil |
in above ex current user is displaying names bt not full name so here i want to display current user fullname insted of short name.
for ref please find attachement ! !