1. Dale
  2. Valentina Studio
  3. Friday, February 01 2019, 02:32 PM
  4.  Subscribe via email
Hi! I would like to apply a currency symbol aside from dollars ($) in Valentina Studio Pro Report Editor. Is there a format setting that can display, say, Peso?

Thank you.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Dale,

1) If you need to have different currencies in one project you can define own pattern for the field or summary control.

Just select Number value for property Kind and input a format, like here:
₱#,##0.##

It will produce values like
2,222.99

The format can be quite complex, it is implemented by the ICU library.

Here is the documentation for formatting in reports.

2) Or if you just want to print one currency instead of another in entire project - it is controlled by Locale setting on the project tab.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
Hi Dale,

pre_build script of the report is better for this task - it is executed just once.

For example, currency symbol may be passed as the parameter:
report.controls.field1.pattern = report.parameterValue( "currencySumbol" ) + ",##0.##";
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Dale Accepted Answer
Sergey, your guidance solves my problem. Thank you very much!

Cheers!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Dale Accepted Answer
Thank you for the response, Sergey. However, I am dealing with international transactions where the currency is changed as per transaction. The currency symbol is stored in the database. Can I generate the format at run-time? Something like, ThisObject.Format = Table.FieldCurrency + "###,###,##0.00"? There's a Pre-Place script but I don't know how to make use of it.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
  • Page :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories