Skip to main content
I
iccsi
Inspiring
May 24, 2013
Answered

Report Function and calculation

  • May 24, 2013
  • 1 reply
  • 1300 views

I use Report Builder for summary at group footer.

I tried to function builder like

Sum(Query.MyField), but the report builder does not like this for some reason.

I tried to use Query.MyField, Report Builder still does not like it to give me ColdFusion does not recognize it.

I need to have calculation field like

sum(MyField1 * MyField2)/ sum(MyField2) and sum(MyField2) base on group elements.

for my summary field and need change color if it is neccessary.

Does Report Builder support client side code like Javascript to change client side behavior?

Your help and information is great appreciated,

Regards,

Iccsi,

This topic has been closed for replies.
Correct answer EddieLotter

Unfortunately the Report Builder does not provide a way to access the field and label properties at runtime.

The only way to make a label/field change its color depending on a value is to create multiple labels, one on top of the other; then use the "Print When Condition" property of each label to determine which one is visible for a given condition.

1 reply

EddieLotter
EddieLotter
Inspiring
September 17, 2013

If you are still having a problem with this, post a reply and we can work through the problem.

I suspect you are setting up your calculated fields incorrectly.

I
iccsiAuthor
Inspiring
September 17, 2013

Thanks for the information and help,

I use =, < and > sign, I just realized that I need use EQ, GT, and LT.

I need to change the color or the lable base on the equation, but I can not access my lable from my function to assign color.

For example, I want to change my label color to red if field value less than 10.

Thanks again for helping and information,

Regards,

Iccsi,

EddieLotter
EddieLotterCorrect answer
Inspiring
September 17, 2013

Unfortunately the Report Builder does not provide a way to access the field and label properties at runtime.

The only way to make a label/field change its color depending on a value is to create multiple labels, one on top of the other; then use the "Print When Condition" property of each label to determine which one is visible for a given condition.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices