1. Cecilio
  2. Report Editor
  3. 日, 3月 11 2018, 08:55 AM
  4.  メールで購読
Hi.
The currency format does not show decimals.
ejmplo: 4.15 you see how 4.00 €

Instead of seeing 15 shows 00

How can it be solved without putting a pattern on all the fields?
Or can you create a standard pattern that replaces the one of currency format?

I use linux.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hi Cecilio,

That's strange. Looks like the format is not recognized.
What database is used?
If you execute select with this field you get 4.15 with a dot as the separator, right?
コメント
There are no comments made yet.
Cecilio 承諾済みの回答
Resolved. It only looks like this in the report editor, preview option.

In real it prints correct: 4.15 €

Excuse me.
コメント
There are no comments made yet.
Cecilio 承諾済みの回答
Hello, the problem persists.
Decimals are not seen in preview or in real time.

I have tried to type "Number" and format: "#, ## 0. ## €" Decimals are not seen either.

What can be the problem?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello, Cecilio,

Please add details - what database is used, is everything on Linux?

If you execute SELECT in the SQL Editor - what is the format of these values?
コメント
There are no comments made yet.
Cecilio 承諾済みの回答
MariaDB
if execute SELECT the format is 12.50 for example. All number have decimals
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
I think the problem is in the locale: when the conversion from string to number happens a wrong decimal-point character is expected.
I'll check it.
コメント
There are no comments made yet.
Cecilio 承諾済みの回答
I have changed the format and so: #.##0,0# so it works
But I'm worried that other computers stop going.
Spanish language
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
We reproduced the problem and working on the solution now.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Cecilio,

The fix is available in the version 8.6.3:
http://valentina-db.com/download/release/lin_64/

As always it is necessary to update the Valentina Studio and Xojo plugin to see changes.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hi Cecilio,

Have you already tried a new build?
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories