Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

What is the best way to hide zero or empty value rows?

Answered
Milan Dragovic asked on July 6, 2020

Also is there a way to default the report to do this form openning?

3 answers

Public
Milan Dragovic July 6, 2020

I need to filter out highlighted lines as attached

Public
Vera Didenko Flexmonster July 6, 2020

Hello, Milan,
 

Thank you for writing to us. 
 

We kindly suggest one of the following approaches:

  1. Representing zero values as null instead of 0:

    In Flexmonster, empty rows are not shown by default.
    This means that if all zeros are represented as null, then the zero value rows will not be shown.

    Please see the following JSFiddle example for illustration: https://jsfiddle.net/flexmonster/wvu6cp9b/

  2. Applying a value filter: 

    Another solution is to apply a value filter to the corresponding hierarchy to filter out the zero value rows.

    Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/g4jkxe5m/
    In the example, the filter is specified in the initial slice configuration, therefore, the zero value rows will be filtered out by default. 

    For more information about configuring the slice object, please see the following guide: https://www.flexmonster.com/doc/slice/ 

Please let us know if this works for your case. 
Looking forward to your reply.
 

Kind regards, 
Vera

Public
Milan Dragovic July 15, 2020

Hi Vera, thanks for your response, will try these two approaches when I get a moment.  I’m sure it’ll be fine
Cheers
M

Please login or Register to Submit Answer