HideZeros doesn't work
Posted: Tue Oct 08, 2019 10:29 am
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
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