Pivot Table Report Title - How to remove?

Patrick Quinlan
Giga Guru

We have just upgraded to Kingston from Helsinki. The upgrade was very smooth and we have seen very little issues. One issue, albeit minor, that we are seeing is with homepages that we have. Some of our homepages have Pivot Table reports displayed. Prior to Kingston, the title was displayed on the widget by checking the 'Title' box in the Edit Widget screen. No other title displayed as there are no title options in when creating a Pivot Table report.

Helsinki version screenshot

find_real_file.png

Now that we've upgraded to Kingston, however, the Report Title displays in the widget by default and is centered and much larger text. Our management likes the smaller, left oriented title as above.

find_real_file.png

 

If we uncheck the 'Title' box in the Edit Widget screen, it only removes the top (smaller) title, which is the one that we want to keep. I have not found a way to prevent the lower larger title from displaying as it seems to be doing it by default.

Anyone have any ideas?

5 REPLIES 5

Erich Zirnhelt
ServiceNow Employee
ServiceNow Employee

If you are using the Multi-level Pivot (or switch your report to that) you should be able to suppress the Title, as shown here in the report editor:

find_real_file.png

 

Patrick Quinlan
Giga Guru

Thanks for the response. While switching the report to a multi-level pivot does solve the issue, the resulting report is not as aesthetically pleasing as a normal Pivot Table report:

Left is the Multi-Level report - Right is the Normal Pivot Table

find_real_file.png

 

I cannot understand why the title is displayed by default with no option to remove it on a Normal Pivot table. Is there no other way to remove it besides changing the report type?

Vespertinus
Tera Expert

You may try to set the field "show_chart_title" to "never" in "sys_report"-table via script. Or did you try the new UI report designer?

Tracy Davis
Giga Guru

We just ran into this same issue and I think I have a solution.

You do need admin rights, so if you don't have that you may need to submit a request to have this done.

If you go to the list view of reports and click on a report you'll be in the report form. You can configure the layout to add 'Chart Title' and 'Show Chart Title' - so both of these could then be managed here instead of in the report designer.

 ** updating, this worked to fix the titles on the calendar reports and I can remove the old Chart Title from the pivot table, but when I unselect show title in the configuration area of the pivot widget, the title still doesn't go away. So frustrating! Also, users aren't able to do these fixes