2 Replies Latest reply: Feb 22, 2014 11:57 PM by Postie RSS

    Hide 0's in report

    Postie

      Hi

       

      How can I hide all zeros in my report?

       

      I did this

      <script>

      $('#MYTABLE tr:last').filter(function() {return $(this).text() == '0';}).css("font-size","0%");

      </script>

       

      But this is not doing all rows?


      Any help please


      Dean

        • 1. Re: Hide 0's in report
          fac586

          Postie wrote:

           

          Hi

           

          How can I hide all zeros in my report?

           

          I did this

          <script>

          $('#MYTABLE tr:last').filter(function() {return $(this).text() == '0';}).css("font-size","0%");

          </script>

           

          But this is not doing all rows?

          Your selector is only for the last row:

           

          $('#MYTABLE tr:last')


          Why are you trying to do this in such an odd way? For example, have you considered that shrinking the text won't hide the zeroes from users who can't see them? This visual change will have no effect on screen readers (or CSV exports for that matter). What about the ugly flickering that will result as the browser redraws the table when it executes this script?

           

          If you really want no zeroes in the report output, remove them at source in the query:

           

          select
              nullif(col1, 0) col1
            , ...
          from
              ...
          
          • 2. Re: Hide 0's in report
            Postie

            Hi will that still sum in a group by roll up?

             

            or show in report totals in apex?

             

            dean