How can we rename the column names in a report.

shanawazkhan9sh
Tera Contributor

I have created a report based on a catalog item. In that catalog item I have two variables "Requester Name" and "Receiver Name" the question text for both variables is Name.On the report i have now two columns with Name as header. I need to rename them to "Requester Name" and "Receiver Name" without modifying the catalog item variables. Is it possible ??

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron
Tera Patron

For those who are still searching for an answer, a database view can be created on top of the table on which you wish change the column names while seeing them in a report. Once a database view is defined go in the System Definition> Language File module and create new field records by selecting the Database view in the table section and by providing Element name and label name for the field.

Also, a new property has been introduced in Paris to provide Report Field Aliases (glide.report.enable_alias_config) once set to true will allow users to define aliases on the report itself.

The aforementioned property is currently disabled by ServiceNow as it seems this feature is not ready yet and may be available in Quebec release.

Please see this thread for more information.

View solution in original post

3 REPLIES 3

prajaktanaik
Giga Expert

Hi Shahnawaz,



As per my knowledge it is not possible to rename columns in a report. Better you change the question text for those variables or you can rename the columns by exporting the report in excel.



Regards,


Prajakta



PS - Hit Like, Helpful or Correct based on the impact of the response.


tejeswararaom
Mega Contributor

Hello, 

Please use Field labels to achive this.

https://community.servicenow.com/community?id=community_question&sys_id=5cb18d43db6a1b00200f0b55ca961956

 

Please check if this may help you.

Sandeep Rajput
Tera Patron
Tera Patron

For those who are still searching for an answer, a database view can be created on top of the table on which you wish change the column names while seeing them in a report. Once a database view is defined go in the System Definition> Language File module and create new field records by selecting the Database view in the table section and by providing Element name and label name for the field.

Also, a new property has been introduced in Paris to provide Report Field Aliases (glide.report.enable_alias_config) once set to true will allow users to define aliases on the report itself.

The aforementioned property is currently disabled by ServiceNow as it seems this feature is not ready yet and may be available in Quebec release.

Please see this thread for more information.