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

by Paul Thompson on June 12, 2019

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.

    Ideas

    Target Release
    SBM 11.6
  • Please login to view any attachments.

  • 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. :-)
    David J. Easter Commented by David J. Easter June 21, 2019
    #1 Reviewer  -  

    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. :-)

     

Print