Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

is there a way to create custom header for the Report (report type= List)

hemnath
Kilo Contributor

In a report of type List the header are same as the table name/label but we would like to customize the column header, please let us know if the is possible .

 

I had already gone through the old discussion and i don't find a way to customize the report header. just trying to double confirm.

5 REPLIES 5

mitchell_stutle
Mega Expert

I haven't tried this, but here is a SN Guru article describing a way to do this:



» How to Add a Logo to Public Report Pages


amadosierra
Kilo Guru

I've found a way of doing this that requires the following:



  1. Create a database view for the table used in the List report that includes every column needed   (Database Views - ServiceNow Wiki). For example: if the list report is for the Incident table, create a database view and call it u_incident_view.
    view1.PNG
  2. Add Incident as a view table and add the required fields.
    view2.PNG
  3. Go to sys_documentation table and create a new entry for each field you need to change the label for.
    For example, if instead of Assigned to we would like to display Assignee:
    view3.PNG
  4. Create/change the list report to use u_incident_view table. Here's an example:
    view4.png


Thanks Mitchell and Amado



@ Amado : your suggestion perfectly fits when the column are fetched directly from the table but in my case we are trying to create a report by dot walking the fields in a particular table to know the Hierarchy of the organization. as per the above instruction I created a custom view but   dot walking shown in the below figure is not possible in the fields of the custom view.custom_column_header.jpg
I am   still working on your suggestio to see if the dot walking is possible in any other way.



please feel free to correct my mistakes.


This probably isn't preferred, but you could add a new field on the Group table that mimics the name field, but with the label that you want to see in the column headers. You would have to create a before insert/update business rule that would copy the name value to your new field. Then you would just use your new field on the report.