1. Humberto R. Baptista
  2. Report Editor
  3. Вторник, Март 06 2018, 01:16 PM
  4.  Подписаться через 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,
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Carlos,

You can add a rectangle below the content of the row and define a conditional style for it.
Комментарий
There are no comments made yet.
Carlos Betiol Ответ принят
How can I print alternate background colors to entire row ?

thanks
Комментарий
There are no comments made yet.
Humberto R. Baptista Ответ принят
Brilliant! This will solve many cases here.
Thank you!
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Ability to use the summary value in conditional formatting was implemented and will be available in the next release.
Вложения
Ссылки
  1. https://valentina-db.com/bt/view.php?id=8210
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
The color is defined in the hex format like "#FF00FF".
But there are other problems that make it impossible for now.
Комментарий
There are no comments made yet.
Humberto R. Baptista Ответ принят
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).
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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?
Комментарий
There are no comments made yet.
Humberto R. Baptista Ответ принят
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)).
Комментарий
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories