1 Reply Latest reply: Nov 16, 2016 12:20 PM by Jean-Pierre Bakhache RSS

    Columns are not being displayed if one of the levels is null

    Jean-Pierre Bakhache

      Hello everyone,

       

      I'm trying to create a report in Nprinting with 4 dimensions and several expressions.

      So in Nprinting I created 4 levels for these dimensions, and formulas for each needed field containing "=only(fieldname)".

      Attached a snapshot of the report design.

       

      The problem is that we might not have all levels filled, in which case the rest of the columns are not being displayed although they contain values.

      If all levels are filled, then we get all the values in the report.

       

      Can someone suggest how to solve this please ?

       

      Thanks.

        • Re: Columns are not being displayed if one of the levels is null
          Jean-Pierre Bakhache

          I actually solved this by creating a formula by level by field (so in my case, 4 formulas for each field).

          In the formula, I check if the subsequent level is null or not to actually know if the value should be displayed on this level or the next one:

           

          example:

          Comment_Level3 = if(isnull(Level4), if(isnull(Comment), '', Comment), '')

           

          I don't know if that's the optimal solution, but it could be helpful to someone who's facing the same.

          Or if someone could share a better solution, this would be great.