2 Replies Latest reply on Jun 19, 2017 7:30 PM by Alex Timofeyev

    Classic report format mask and totals NOT working.

    kvsinfo

      I'm using apex 5.1 and universal theme.

       

      I have a page with classic report that is based on apex_collections.

       

      select c001 amount_due from apex_collections where collection_name = 'test'

       

      Type = plain text

      Format Mask appearance = 999G999G990D00

      Compute Sum = Yes.

       

      If you look at the output for the amount_due its all valid numbers but the mask is NOT applied and the total is zero.

       

      Thanks

       

        • 1. Re: Classic report format mask and totals NOT working.
          fac586

          kvsinfo wrote:

           

          I'm using apex 5.1 and universal theme.

           

          I have a page with classic report that is based on apex_collections.

           

          select c001 amount_due from apex_collections where collection_name = 'test'

           

          Type = plain text

          Format Mask appearance = 999G999G990D00

          Compute Sum = Yes.

           

          If you look at the output for the amount_due its all valid numbers but the mask is NOT applied and the total is zero.

           

          Why are you storing number values in a VARCHAR2 column? Either store values used in calculations as NUMBERs in the N001-N005 collection columns, or explicity convert VARCHAR2s to NUMBERs in the report query using to_number.

           

          The same principle applies to using D001-D005 for DATE values.

           

          If more than 5 number or date columns are involved, then its good practice to create a view on the collection(s), either to create a conversion layer over character column storage, or to join two or more collections together to increase the number of native Nxxx or Dxxx columns available.

          • 2. Re: Classic report format mask and totals NOT working.
            Alex Timofeyev

            Hi  kvsinfo,

             

            You keep number values in char type column.

            If you can, use n00x column. If you cannot, use to_number(c001).