Allow formatting of columns on report. Allow "freeze" header for header Rows or specified columns

Idea ID 2739694

Allow formatting of columns on report. Allow "freeze" header for header Rows or specified columns

For a Work Center Listing report, give me the ability to:

  1. Freeze the header row
  2. Freeze the first "X" columns
  3. Delineate columns or groups of columns using vertical lines or color coding

Alternatively, give me a solution KB article that describes how to create a custom report template to accomplish this.

We have a report that has 70+ columns.  Users know these fields as being in different "sections" (tabs on the State and Transition) forms.  I would like the ability to delinate the fields by these sections.  For example, columns 1-2 are the Issue ID and Owner.  Those columns should never scroll off.  THe next 5 colums belong to the "Prep" section.  Those columns should be grouped together using visual clues like color or vertical delineators.  The next 6 columns are from the ESI/TESI section.  Those columns should be grouped together visually.   Etc.

Allow me to indicate that the column header row should never scroll off.  With the current design, once that scrolls off the page I'm drowning in a sea of data.

1 Comment
David_J_Easter Absent Member.
Absent Member.
The first item is implemented in SBM 11.6 using the "gridlist.htm" template. The third item is somewhat a duplicate of an existing idea. https://www.serenacentral.com/community/ideas/sbm/enhance-use-of-color-in-distribution-reports-beyond-thresholds. It's also explained how to do it as a customization in the forum (https://www.serenacentral.com/community/forums/how-can-i-change-the-background-color-for-listing-report-rows-based-on-field-value) but is also in the SBM backlog for a future release. Since we already implemented the first one and the third is somewhat well known, I'm going to close this idea as already implemented even though only the first is implemented. This is also a reason to only put one idea in at a time. 🙂
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.