Collapse Multilevel Pivot Report table by default.

anubhavr
Giga Expert

I have a report on Multilevel Pivot. By default, it is coming in expanded form. I want to make it Collapse by default. How can I achieve it?

12 REPLIES 12

Pratyusha
ServiceNow Employee
ServiceNow Employee

Hi Anubhav,



When we click on Edit report UI action on the report, we have different options like Data, Type, Configuration and Style on the left. Under the Style heading, we have an option called 'Default expanded' for this multi-level pivot type report. Please uncheck this checkbox and save the report. It should then be opened in collapsed manner by default.



Thanks,


Pratyusha


Hi Pratyusha,



Thanks for the quick response.



Where Can I get UI actions of report??


Pratyusha
ServiceNow Employee
ServiceNow Employee

Hi Anubhav,



Please enter sys_report.list in the navigator and navigate to the list of reports. Then apply a filter 'Type = Multilevel Pivot' (URL query - /sys_report_list.do?sysparm_query=type%3Dpivot_v2) and select the report to be modified from this list. At the bottom of the form we have the 'Edit Report' UI action. We can then follow the steps described above.



Let me know if you face any issues.



Thanks,


Pratyusha


Hi Pratyusha,



I went to the same page but I can't see any Style Heading or Default expanded.