Page 1 of 2

Zero values

Posted: Mon Feb 01, 2016 4:00 pm
by catalin
Hi,
I have a problem with zero values because the viewer it prints nothing.
The query return 0 if the value is null.
SELECT
ifnull(pdo.cas, 0) AS cas
FROM por12_deviz_obiect pdo

As you can see on the attached image I have nothing on the cells with zero value.

Thanks.[img]
zeros.png
zeros.png (8.27 KiB) Viewed 6792 times
[/img]

Re: Zero values

Posted: Tue Feb 02, 2016 7:51 am
by HighAley
Hello.

Please, check the Hide Zeros property of text components.
If this does not help, send us your report template with sample data.

Thank you.

Re: Zero values

Posted: Tue Feb 02, 2016 10:04 am
by catalin
Hello,
It's not working when I check "Hide Zeros". And you don't need the template because it's very easy to reproduce.

It's working in designer but not in Viewer

The table
z1.png
z1.png (1.46 KiB) Viewed 6784 times
Designer (design mode)
z2.png
z2.png (61.54 KiB) Viewed 6784 times
Designer (preview mode)
z3.png
z3.png (16.6 KiB) Viewed 6784 times
Viewer (Browser)
z4.png
z4.png (14.57 KiB) Viewed 6784 times

Re: Zero values

Posted: Tue Feb 02, 2016 11:13 am
by Vladimir
Hello,

Please use this hotfix, the issue should be fixed:
database_mysql_fix.zip
(1.62 KiB) Downloaded 639 times
Also this fix will be available in the next prerelease build.

Thank you.

Re: Zero values

Posted: Tue Feb 02, 2016 12:13 pm
by catalin
Thank you Vladimir,
It's working good.

Great tool, but it's not very easy to work with it. It would be possible to tell you improvements to make the tool more user friendly?

Re: Zero values

Posted: Tue Feb 02, 2016 12:55 pm
by Alex K.
Hello,

We will be happy to hear your suggestions.
Also please check the HTML5 designer(included in PHP version) which more modern and user friendly.

Thank you.

Re: Zero values

Posted: Tue Feb 02, 2016 2:36 pm
by catalin
Sorry, where is this option?

Re: Zero values

Posted: Wed Feb 03, 2016 7:35 am
by HighAley
Hello.

This is a JavaScript component that is available in our latest release.
We have made a lot of improvement there, please, download our latest prerelease build.
You could find there samples and Demo in JS folder.

Thank you.

Re: Zero values

Posted: Wed Feb 03, 2016 7:57 am
by catalin
The prerelease is working with my license?

Re: Zero values

Posted: Wed Feb 03, 2016 9:19 am
by HighAley
Hello.

Sorry, but we don't understand your question.
You could send any question about licensing to sales@stimulsoft.com.

Thank you.