Alias Table Column Headers/Values in Report?

[RobSK]

Greetings,

I have a tabular report.  Just wondering... is there a way to do the following 2 things....

1. Change the column header for a given column?  (e.g. a sc_task table report, it says "Assignment Group", I would call it "Working Group".

2. Alias values in the column.  (e.g. I have a column that shows tags.  If my tag says "FlagForReview", I want the row to display "Needs Review").

Thx,

R.

[Dr Atul G- LNG · Accepted solution]

Hi @RobSK 

Have a look here:

https://www.servicenow.com/community/platform-analytics-forum/configure-report-labels-aliases/m-p/12...

Configure Report Labels: Aliases

1. Click Configure Report Labels. The Configure aliases window has tabs for all the columns that you have selected for the report.
2. Select a column that should have aliases for either the column name, or its values, or both. ...
3. Set aliases for the values in the selected column.

[Saurabh Gupta]

Hi,
You can override the label of any field extended from task. In this you can make it "Working Group", but it will be applicable for all the records of sc_task.

[RobSK]

Thx.. I am hoping to keep this solution as something report-centric... other areas would not understand the reasons for changing the field label.

[Dr Atul G- LNG · Accepted solution]

Hi @RobSK 

Have a look here:

https://www.servicenow.com/community/platform-analytics-forum/configure-report-labels-aliases/m-p/12...

Configure Report Labels: Aliases

1. Click Configure Report Labels. The Configure aliases window has tabs for all the columns that you have selected for the report.
2. Select a column that should have aliases for either the column name, or its values, or both. ...
3. Set aliases for the values in the selected column.

[Saurabh Gupta]

Hi,
You can create a view under one table sc_task and change the label as per your need and use that view in your reports.