is there a way to create custom header for the Report (report type= List)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2014 02:25 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2014 06:15 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2014 09:37 AM
I've found a way of doing this that requires the following:
- 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.
- Add Incident as a view table and add the required fields.
- 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: - Create/change the list report to use u_incident_view table. Here's an example:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2014 01:13 PM
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-25-2014 04:07 AM
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.
