Floating Headers in Summary and Matrix Reports

Floating Headers in Summary and Matrix Reports

Last Updated on June 1, 2022 by Rakesh Gupta

It is hard to remember the headers when you are viewing a report with thousands of rows. Instead of scrolling, create floating headers by freezing columns and rows. After the Spring’14 release when you scroll down to read a report, you can choose to have the header rows at the top or on the left of the report stay visibility. This feature is available in Developer, Performance, Enterprise, Professional, Contact Manager, Group, and Unlimited except Database.com editions.

Enable Floating report headers

To enable this feature to follow the steps below:

  1. Click on Setup | Feature Settings | Analytics | Reports & Dashboards | Reports and Dashboards Settings
  2. Select Enable Floating Report Headers (Salesforce Classic only) check-box

    Report and Dashboard User Interface Setting
    Report and Dashboard User Interface Setting
  3. Click Save.

Proof of Concept

First of all, you have to create a summary or matrix report then you can use this feature. Here I am going to use the Opportunity Pipeline standard report. Follow the below steps to create a report with a floating header

  1. Navigate to the Reports tab
  2. Click on the Opportunity report folder and Click on Opportunity Pipeline report, Same like below screenshot:

    Opportunity Pipeline Report
    Opportunity Pipeline Report
  3. It will open the report on another page, from where you can Run Report. On this Screen Click on Customize button

    Customize Report
    Customize Report
  4. Now you are ready to customize the report, Select filters value as per your business requirement. change the report format to Summary if it’s not in that format.

    Add & Remove filter and Report format
    Add & Remove filter and Report format
  5. Click Save.
  6. Now perform steps 1 & 2. You are now on the Opportunity Pipeline report page. When the top row of data passes the top of the browser window, click the up arrow that appears just under the address bar. The grouping rows remain in view no matter how far you scroll.

    Report with Floating Headers -1
    Report with Floating Headers -1
  7. Finally it will look like the below screenshots.

    Report with Floating Headers - 2 (Final Outcome)
    Report with Floating Headers – 2 (Final Outcome)

Similarly, when you scroll to right and the left-most column of data passes the left edge of the browser, you can click the rightward arrow to see a stationary display of the row labels in the left column.

Formative Assessment:

I want to hear from you!

What is one thing you learned from this post? How do you envision applying this new knowledge in the real world? Feel free to share in the comments below.

Have feedback, suggestions for posts, or need more information about Salesforce online training offered by me? Say hello, and leave a message!

8 thoughts on “Floating Headers in Summary and Matrix Reports

  1. Good stuff. I had not noticed that arrow before. It appears NOT to work in Chrome on Lightning Edition. Chrome and Classic Edition works fine.

  2. Hi Rakesh,

    Had done exact same steps, but i did not get header fixed not get even up arrow.

    let me know if any setting i need to follow


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.