1. Humberto R. Baptista
  2. Report Editor
  3. Dienstag, März 06 2018, 01:16 PM
  4.  Abonnieren via E-Mail
Hi.
I have a Summary Filed on my forms that I wish to format using the Conditional Style, but I cannot reference the value of the summary field.

Is there any way to do it? For instance if the average of a filed is negative I'd like to have the font printed in red, etc.

Cheers,
Kommentar
There are no comments made yet.
Humberto R. Baptista Akzeptierte Antwort
PS: if I try to add the aggregate expression:
Avg(VarFaturamLiq1) < 0
in the conditional style dialog and then preview the report this crashes my Valentina Studio
(running Valentina Pro Studio 8.0.2 (64-Bit) on OS X El Capitan (10.11.6)).
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello, Humberto,

No, the value of summary can't be referenced.

I tried to do such styling in the JavaScript but not everything works as I expected.
In which region is this summary placed?
Kommentar
There are no comments made yet.
Humberto R. Baptista Akzeptierte Antwort
Hi Sergey,

It is in the Page Footer region. I tried also via Javascript (tried to put a pre_place like: report.controls.MYSUMMARY.fore_color="RED";) to no avail.

Any ideas?

(in other systems there is a "self" variable or function that can me used in expressions to signify the value of the object/field).
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
The color is defined in the hex format like "#FF00FF".
But there are other problems that make it impossible for now.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Ability to use the summary value in conditional formatting was implemented and will be available in the next release.
Anhänge
Referenzen
  1. https://valentina-db.com/bt/view.php?id=8210
Kommentar
There are no comments made yet.
Humberto R. Baptista Akzeptierte Antwort
Brilliant! This will solve many cases here.
Thank you!
Kommentar
There are no comments made yet.
Carlos Betiol Akzeptierte Antwort
How can I print alternate background colors to entire row ?

thanks
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Carlos,

You can add a rectangle below the content of the row and define a conditional style for it.
Kommentar
There are no comments made yet.
  • Seite :
  • 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