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 (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 (1.46 KiB) Viewed 6784 times
Designer (design mode)

- z2.png (61.54 KiB) Viewed 6784 times
Designer (preview mode)

- z3.png (16.6 KiB) Viewed 6784 times
Viewer (Browser)

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