1. Humberto R. Baptista
  2. Report Editor
  3. Tuesday, March 06 2018, 01:16 PM
  4.  Subscribe via email
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,
Comment
There are no comments made yet.
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)).
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
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).
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
The color is defined in the hex format like "#FF00FF".
But there are other problems that make it impossible for now.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Sergey Pashkov Accepted Answer
Ability to use the summary value in conditional formatting was implemented and will be available in the next release.
Attachments (1)
References
  1. https://valentina-db.com/bt/view.php?id=8210
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
Brilliant! This will solve many cases here.
Thank you!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 6
Carlos Betiol Accepted Answer
How can I print alternate background colors to entire row ?

thanks
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 7
Sergey Pashkov Accepted Answer
Hello Carlos,

You can add a rectangle below the content of the row and define a conditional style for it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 8
  • 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