Page 1 of 1

HideZeros doesn't work

Posted: Tue Oct 08, 2019 10:29 am
by PeterB
Hello,

one of my reports has a field "anzahl_wp". The field in the underlying database table contains either NULL or 1.
Using the preview function in designer.php everything seems to be OK but when I load my report with viewer.php the value "0" is shown wherever it's NULL, even if the checkbox HideZeros is active!
I also tried to fix this within the query with "... (ifnull (v_count_max_wp.anzahl_wp,'')) AS anzahl_wp ...". Same result.
What else can I do? Is it a bug or am I just too dim?

Thank you for helping me.

Peter

Re: HideZeros doesn't work

Posted: Tue Oct 08, 2019 12:26 pm
by Lech Kulikowski
Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Re: HideZeros doesn't work

Posted: Wed Oct 09, 2019 12:00 pm
by PeterB
It seems to be a case of spontanious self healing. Just when I got all the demo data together I tried another reload and all of a sudden the report operates as expected. Maybe a cache issue of the browser? Anyway, the cache of the report itself is disabled. But the main point is that it works. Thank you for your reply.

Re: HideZeros doesn't work

Posted: Fri Oct 11, 2019 2:07 pm
by Lech Kulikowski
Hello

Ok.
Please let us know if you need any additional help.

Thank you.