Is it possible to change column labels in reporting?

antonymirza
Tera Expert

Is it possible to change column labels as per user's requirement? These columns may include dot walking as well.

1 ACCEPTED SOLUTION

feroz4051
Mega Expert

you can create database view and then you can change field values of database view using Language field.


View solution in original post

16 REPLIES 16

gyedwab
Mega Guru

If you use Explore Analytics for live, interactive reporting, you can change column labels on a per report basis, rather than changing anything in the database.


rashmic
Giga Contributor

Hi Antony,



Yes, I had the same issue which I resolved that by following the steps provided in the below link.



Hence, same comments as Feroz and Chad has mentioned above is the solution and it works.



Yes, you can access the fields using variable prefix for the table (whatever you have defined for the table in the view)


http://wiki.servicenow.com/index.php?title=Database_Views#Relabeling_a_Column&gsc.tab=0




Another thread on the same topic is


https://community.servicenow.com/thread/173602



RC


Ashish Kumar Ag
Kilo Guru

Hey check the below article.


Database Views - ServiceNow Wiki



Keep in mind the element name must be from data base view. Ex: inc_state   not state.


antonymirza
Tera Expert

Thank you all for sharing your inputs, it's been an interesting thread and I believe will be proven helpful for many others like me to fulfill their requirements.



Marking it as answered now 🙂


Would this include setting up a label when the field is dot walked to on a list?



Example:



The setup:


Incident list, columns have been setup with all default incident columns, but also has one column dot walked to show the assigned to user's manager field.



The modification:


This manager field's label on the list, is "Name", but there is already a name field natively with Incident without having a to dot walk anywhere, to show the name of the client that the incident is for (might not be exactly this, but for sake of explaining this it is). I want to change the label of "Name" for this dot walked manager name field, to instead be "The boss".



Have you or anyone else seen a way to do this? Having multiple columns, native to the record, and then ones dot walked to related records, with the same label, is confusing and not helpful to anyone viewing the list of incidents.




Thank you.