Zero values

[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 (8.27 KiB) Viewed 6673 times

[/img]

[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.

[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 (1.46 KiB) Viewed 6665 times

Designer (design mode)

z2.png (61.54 KiB) Viewed 6665 times

Designer (preview mode)

z3.png (16.6 KiB) Viewed 6665 times

Viewer (Browser)

z4.png (14.57 KiB) Viewed 6665 times

[Vladimir]

Hello,

Please use this hotfix, the issue should be fixed:

database_mysql_fix.zip

(1.62 KiB) Downloaded 626 times

Also this fix will be available in the next prerelease build.

Thank you.

[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?

[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.

[catalin]

Sorry, where is this option?

[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.

[catalin]

The prerelease is working with my license?

[HighAley]

Hello.

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

Thank you.