3 Replies Latest reply: May 28, 2013 1:25 PM by 713780 RSS

    How to show column headers before Grand Total

    713780
      In a classic report, I'm using the Sum functionality and breaks by First Column to get subtotals and report total. I Repeat Headers on Break which works great for the subtotals but I would like for the report to display the column headers above the report total for easier reading. If the last grouping has a lot of data, the user needs to scroll up to read the column headers when looking at the Grand Total.

      Is there a way to Repeat Headers prior to report total?

      Thank you for your help.
        • 1. Re: How to show column headers before Grand Total
          Denes Kubicek
          I don't think this is easy to do. Maybe you should use the freeze headers technique instead. Search this forum on freezing report headers. This topic has been discussed for several times.

          Denes Kubicek
          -------------------------------------------------------------------
          http://deneskubicek.blogspot.com/
          http://www.apress.com/9781430235125
          https://apex.oracle.com/pls/apex/f?p=31517:1
          http://www.amazon.de/Oracle-APEX-XE-Praxis/dp/3826655494
          -------------------------------------------------------------------
          • 2. Re: How to show column headers before Grand Total
            fac586
            Ana-Hill wrote:
            In a classic report, I'm using the Sum functionality and breaks by First Column to get subtotals and report total. I Repeat Headers on Break which works great for the subtotals but I would like for the report to display the column headers above the report total for easier reading. If the last grouping has a lot of data, the user needs to scroll up to read the column headers when looking at the Grand Total.

            Is there a way to Repeat Headers prior to report total?
            This is a use case for the <tt>tfoot</tt> table element. It is relatively easy to use this in a custom named column template (as used for a slightly different case in this thread: +{message:id=10107743}+ ), although the control breaks may have to be coded into the report SQL ( +{message:id=10679160}+ )

            Alternatively, a Dynamic Action could be used to insert a copy of the existing header row before the total row and wrap them in the <tt>tfoot</tt> element.
            • 3. Re: How to show column headers before Grand Total
              713780
              Are there any examples you can recommend for the Dynamic Action approach? Using the Fixed Headers does not work for me since I'm doing breaking by First Column, the report shows the value of the first column first, then the headers for the subsequent columns.
              I'm not sure if the firewall would allow access to this page but this is how the report looks like, to run just select ST3 and click Go
              [http://pdmorawebdev.tx.fnc.fujitsu.com:7780/apex_d2ma/f?p=140:6:2423328610791338::::P_PRODUCT_ID:32406.42282.25984.6122]

              Thank you.